→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
ServiceDeskAPS
Engaged Sweeper
First Name, Last Name, Description, Department, Manager

If anybody can help me gemerate a report with this information that based on Manager I can email out on a monthy basis through the lansweeper console that would be awesome. I am having problems joining the required tables together.

Thanks,
1 ACCEPTED SOLUTION
Daniel_B
Lansweeper Alumni
You need to add tblADusers a second time to your report under a different alias and join it's ADObjectID column to the first table's ManagerADObjectID column. In the report below we did it two times for two levels of managers.

Select tblADusers.Firstname,
tblADusers.Lastname,
tblADusers.Description,
tblADusers.Department,
tManager.Displayname As Manager,
tManagersManager.Displayname As [Manager's Manager]
From tblADusers
Left Join tblADusers tManager On tManager.ADObjectID =
tblADusers.ManagerADObjectId
Left Join tblADusers tManagersManager On tManagersManager.ADObjectID =
tManager.ManagerADObjectId
Order By tblADusers.Firstname

View solution in original post

1 REPLY 1
Daniel_B
Lansweeper Alumni
You need to add tblADusers a second time to your report under a different alias and join it's ADObjectID column to the first table's ManagerADObjectID column. In the report below we did it two times for two levels of managers.

Select tblADusers.Firstname,
tblADusers.Lastname,
tblADusers.Description,
tblADusers.Department,
tManager.Displayname As Manager,
tManagersManager.Displayname As [Manager's Manager]
From tblADusers
Left Join tblADusers tManager On tManager.ADObjectID =
tblADusers.ManagerADObjectId
Left Join tblADusers tManagersManager On tManagersManager.ADObjectID =
tManager.ManagerADObjectId
Order By tblADusers.Firstname