Community FAQ
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
jimmern
Engaged Sweeper II
Hi !

is there any way to have a report showing :

Employee name and what Active Directory Group the employee belongs to ?
2 REPLIES 2
jimmern
Engaged Sweeper II
Hi !

Thanks, this report solved my problem
Hemoco
Lansweeper Alumni
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.

Archive

This board contains archived posts from the retired Lansweeper Forum and Insiders Community.

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now