Extracting directory membership

[bbuilder]

Hi

Does anyone know a way to extract the memebership lits of groups within AD to notepad or excel?

 

[crobin1]

CSVDE is your friend. The following command will export all groups in the domain along with their members:

csvde -f groups_users.csv -s domaincontroller -d "dc=yourdomain,dc=com" -p subtree -r "(objectClass=group)" -l "member"

 

[bbuilder]

Hi Crobin1

That seems to work, is there a way to easily tidy the info once in excel? The info need to go to my HR depart and i think they may have a problem deciphering the infomation.

Cheers

 

[crobin1]

Search and replace. For example:
Find what: ,dc=yourdomain,dc=com
Replace With: leave the field blank
There are other ways to get the information, such as with VBScript, where you can clean up some of the information during the extraction, but I still find this to be one of the quickest ways to do it.