http://www.ldapsoft.com/forum/posts/list/4.page JForum - http://www.jforum.net
I am using AD Admin & Reporting Tool. ]]> http://www.ldapsoft.com/forum/posts/preList/56/190.page http://www.ldapsoft.com/forum/posts/preList/56/190.page GMT
1. Open AD Admin and reporting tool and connect to Active Directory

2. Click on the SQL button (top tool bar), copy and paste (top panel) the following statement

[i][color=blue]Select cn,memberOf from RootDSE where objectCategory='person' and objectClass='user' and sAMAccountType!=805306370 subtreescope[/color][/i]

3. Click on the Export button and select Excel Export

4. Uncheck ExportDN and Export Operational Attributes (Middle right)

5. Provide the file name and click Export

-------------Version 4.2+ skip to step 8 ---------------------------

6. Open the exported file - click Tool --> Macro --> Macro -- Enter a name for Macro (any name) and Click Create Button

7. Replace the text in the window with

[color=blue]Sub ReplaceTags2()
Dim c As Range
For Each c In ActiveCell.CurrentRegion.Cells
c.Value = Application.WorksheetFunction.Substitute(c, "|", Chr(10))
Next
End Sub[/color]

click Run button (Tool Bar)

-------------------------------------------------------------------------------------------

8. Select all row and columns (click top left header) copy and paste it to word.

Word will show all row text as excel has a row height limit.
]]> http://www.ldapsoft.com/forum/posts/preList/56/191.page http://www.ldapsoft.com/forum/posts/preList/56/191.page GMT
I hope this type of report is needed enough by other people that maybe someday it can be worked into the program.]]> http://www.ldapsoft.com/forum/posts/preList/56/192.page http://www.ldapsoft.com/forum/posts/preList/56/192.page GMT