Sample report:
Select Top 1000000 tblADusers.Username,
tblADusers.Userdomain,
tblADusers.Firstname,
tblADusers.Lastname,
tblADusers.Name,
tblADusers.Displayname,
tblADusers.OU,
tblADusers.Lastchanged,
tblADGroups.Name As [Group],
tblADGroups.Description As GroupDescription
From tblADGroups
Inner Join tblADMembership On tblADMembership.ParentAdObjectID =
tblADGroups.ADObjectID
Inner Join tblADusers On tblADMembership.ChildAdObjectID =
tblADusers.ADObjectID
Order By tblADusers.Userdomain,
tblADusers.Username,
[Group]
To use the specified report, do the following:
• Browse to the Reports\Create New Report section of the web console.
• 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.
