Create a report

[mdias_software]

Deall all,

Could you help us create a report to see the managers in my AD and information about his machine?

Specifically this data from the "sAMAccountName" database.

Could you help us please?

[Mister_Nobody]

LS has built-in report Users: AD users and their managers 

You can combine it and assets info

[mdias_software]

Dear support,

The items keep repeating, sorry but we don't have an employee with expertise in SQL.

Select Top 1000000 tblADObjects.sAMAccountName As ManagerName,
tblADObjects.domain As ManagerDomain,
tblAssetCustom.Department,
tblAssets.IPAddress,
tblAssets.OScode,
tblAssets.AssetName,
tblAssets.Memory,
tblAssets.Processor,
tblAssetCustom.Model,
tblAssetCustom.Manufacturer
From tblADusers
Left Join tblADObjects On
tblADObjects.ADObjectID = tblADusers.ManagerADObjectId,
tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID

 Could you help us please?

[Mister_Nobody]

Select Top 1000000 tblAssets.Assetid,
tblAssets.AssetName,
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
  Inner Join tblAssets On tblADusers.Username = tblAssets.Username And
      tblADusers.Userdomain = tblAssets.Userdomain
Order By tblADusers.Userdomain,
  tblADusers.Username

[Mister_Nobody]

1. Clict Edit report  Users: AD users and their managers

2. Save As Users: Assets and AD users and their managers OR copy code into new report

3. Search tblassets and drag&drop it 

4. Link by drag&drop userdomain and username of tbladusers and tblassets

5. Check all needed fields

No SQL knowledge is required for Report Builder GUI part.