en Passant
not letting life just pass on by
Tool to Export DL Membership
Here is a small HTA applet that I have built to export the membership of various groups in Windows Active Directory. It provides some basic filtering (owner, specific OU, name contains), plus 3 modes of export, XLS, CSV, or HTML to screen. Beware, if you have office 2007, XLS is XLSX format.
To run this in your environment, it will need to be modified:
line 27 & 28
strHTML=strhtml&"<option value=""LDAP://dc=local,dc=corp"" >All OUs"
strHTML=strhtml&"<option value=""LDAP://ou=sub,dc=local,dc=corp"" >This SUB OU Only"
strHTML=strhtml&"<option value=""LDAP://ou=sub,dc=local,dc=corp"" >This SUB OU Only"
line 55 & 56
strHTML=strhtml&"<option value=""LDAP://dc=local,dc=corp"" >All OUs"
strHTML=strhtml&"<option value=""LDAP://ou=sub,dc=local,dc=corp"" >This SUB OU Only"
strHTML=strhtml&"<option value=""LDAP://ou=sub,dc=local,dc=corp"" >This SUB OU Only"
CSV mode gives the best detail as XLS has a 255 character limit on single fields.
Just fixed issue where it required you to pick a subOU in order to continue.
| Attachment | Size |
|---|---|
| DL Export Report.zip | 6.3 KB |
Comments
This is an awesome tool
This is an awesome tool thanks a lot for sharing!
Hi ! My Salute to you. I
Hi ! My Salute to you. I bogged my head a lot to export a DL membership many days. That group includes contacts as well as other groups. Other utilities like csvde could not bring any result to me. But your solution worked like charm to me.
Thanks a lot !!
Hello MyITForum Users. Glad
Hello MyITForum Users.
Glad to have you visit my site.
If you have a moment, I would also suggest checking out my other technical articles (here).
Come back soon, I try to update my site regularly. One of my current projects is a series of Logparser scripts to process Performance Monitor data to evaluate server performance.
Post new comment