→ 🚀What's New? Join Us for the Fall Product Launch! Register Now !
‎01-20-2015 11:42 AM
Select Top 1000000 tblADusers.Username,
tblADusers.Userdomain,
tblADusers.Firstname,
tblADusers.Lastname,
tblADusers.Name,
tblADusers.Displayname,
tblADusers.email As Email,
tblADObjects.sAMAccountName As ManagerName,
tblADObjects.domain As ManagerDomain
From tblADusers
Left Join tblADObjects On tblADObjects.ADObjectID =
tblADusers.ManagerADObjectId
Order By tblADusers.Userdomain,
tblADusers.Username
‎02-24-2015 09:05 AM
Each "level" will require new links to tblADusers and tblADObjects. A sample report that adds one level can be seen below. You can add additional levels by repeating the snippets marked in yellow and replacing the 1 with a different number. Instructions for running reports can be found here. If you are interested in building or modifying reports, we would recommend:
- Reviewing some SQL tutorials, as the Lansweeper report builder uses standard SQL queries. This seems like a good tutorial.
- Updating to Lansweeper 5.2, if you haven't already. Lansweeper 5.2 includes a database dictionary, which is linked at the top of the report builder.
Select Top 1000000 tblADusers.Username,
tblADusers.Userdomain,
tblADusers.Firstname,
tblADusers.Lastname,
tblADusers.Name,
tblADusers.Displayname,
tblADusers.email,
tblADObjects.sAMAccountName As ManagerName,
tblADObjects.domain As ManagerDomain,
tblADObjects1.sAMAccountName As ManagerName1,
tblADObjects1.domain As ManagerDomain1
From tblADObjects
Right Join tblADusers On tblADObjects.ADObjectID =
tblADusers.ManagerADObjectId
Left Join tblADusers tblADusers1 On tblADusers1.Username =
tblADObjects.sAMAccountName And tblADusers1.Userdomain = tblADObjects.domain
Left Join tblADObjects tblADObjects1 On tblADObjects1.ADObjectID =
tblADusers1.ManagerADObjectId
Order By tblADusers.Userdomain,
tblADusers.Username
‎02-18-2015 12:04 PM
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now