In an ideal world I would like to be able to export our Active directory to SQL server and then produce reports as required by different departments as needed.

I.E. I...

As an example All tables have the colums 'UserName' 'LastName' 'FirstName'

I want to add 'GoupMembership' as a colum to allow me to produce reports by groupmembership.

I would like to...

The database is an import of part of our active directory, so I didn't design it and all I want to do is when required produce a report of usernames,real...