
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-09-2015 09:34 PM
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,
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,
Solved! Go to Solution.
Labels:
- Labels:
-
Report Center
1 ACCEPTED SOLUTION

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-10-2015 03:07 PM
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
1 REPLY 1

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-10-2015 03:07 PM
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
