home recent topics recent posts search faq
Home » Scripting » export AD Groups and Members in to Excel Messages in this topic - RSS
|
3/31/2010 5:03:00 AM
ajf
ajf
Posts 1 		guys,

i really like this script(what it can do) but what i would like to know if a versions exists with an inputbox for the export. I need to export several(not all) groups with their content(users and other groups) into excel.
thanks in advance.
4/26/2010 12:26:13 PM
admin
admin
Posts 331 		One option would be to run the full script and filter the data required in MS Excel. Another option would be to modify the search filter of the script. e.g.

cmd.commandtext = "<LDAP://" & searchRoot & ">;(&(objectCategory=Group)(|(sAMAccountName=group1)(sAMAccountName=group2)(sAMAccountName=group3)));ADsPath,primaryGroupToken;subtree"

This change to the script would be appropriate if you need to extract members from the same groups on a regular basis. If the groups are different every time then it might be better to add an inputbox to the script that takes a comma separated list of groups and then convert this into a valid filter. Let me know if this is what you require?
pages: 1
|
Home » Scripting » export AD Groups and Members in to Excel