4 weeks ago
Deall all,
3 weeks ago
LS has built-in report Users: AD users and their managers
You can combine it and assets info
3 weeks ago
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?
3 weeks ago - last edited 3 weeks ago
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
3 weeks ago - last edited 3 weeks ago
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.
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now