Exporting using multiple containers

We have our Active Directory setup as email enabled security groups to allow each container to be used as an outlook distribution list.

What I need to do is to come up with an export script that will allow me to either export all the containers under one container to a CSV file, or if easier, set up and open query in SQL so that when a user requests a group list, I can return all the attributes for each user in the group.

To give you an example of the structure, it goes as follows

Programs
     |
Leadership Program
      |
Committee/Workgroup Name
      |
User (member of committee)


What is the best approach for this, and where do I put the path of containers in the query syntax?
CVLEWISAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

PaulHiebCommented:
Your talking about doing an LDAP query to dump to a CSV? Seems like XML would be a better approach as it provides the heirarchial structure that a .csv can't match very well and is easily published to a web page. This could even be a dynamic thing in an ASP/ASPX page to pull the group structure out on page load.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows 2000

From novice to tech pro — start learning today.