AD groups (all) with users

[klax]

Hello,

i need a custom report with all active directory groups and users/groups assigned to them.

Thanks you in advance for your help.

[Hemoco · Accepted solution]

Hi,

Can you try to use the following report:
Select Distinct Top 1000000 tblADGroups.Name,
tblADGroups.Description,
tblADusers.Username,
tblADusers.Userdomain,
tblADusers.Displayname
From tblADGroups
Inner Join tblADMembership On tblADMembership.ParentAdObjectID =
tblADGroups.ADObjectID
Inner Join tblADusers
On tblADusers.ADObjectID = tblADMembership.ChildAdObjectID


To use the report above, do the following:
• Open the report builder under Reports/Create New Report.
• Paste the SQL code we provided at the bottom of the page.
• Left-click somewhere in the upper section of the page so the code applies.
• Give the report a Title and hit the Save & Run button to save it. Export options are listed on the left.