Users: AD users and their managers (Built-in)

[Susan_A]

Added in v.6.0.100

The report below lists scanned domain users and their managers in Active Directory. AD manager scanning was added in Lansweeper 5.1. If you have an old Lansweeper installation, update to the latest release and rescan your users.

Domain users are automatically scanned when they log into a computer during a computer scan. Additional users can also be scanned with Domain User Scanning.

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

[Susan_A]

Question received and answered via email as well:

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

[haran]

Hi
i need to get mangers manger AD item , is it possible you to give me a code for that for
example User "V" manger is W, w manger is X, x manger is y and Y manger is Z