cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
tcooper
Engaged Sweeper III
Does Lansweeper import the "Managed by" AD field when pulling PCs from AD? If so, does it list the user as its owner in the relations pane? If not, is there a way to do the import so that a list of all devices "Owned" by a user can be shown in their User page?
1 ACCEPTED SOLUTION
Susan_A
Lansweeper Alumni
The computer manager should be scanned, but I don't think this information is listed on individual computer or user pages. You can run the computer manager report below though, by following these instructions.
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.IPAddress,
tblAssets.Firstseen,
tblAssets.Lastseen,
tblAssets.Lasttried,
tsysOS.Image As icon,
tblADusers.Username As Manager
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tblADComputers On tblAssets.AssetID = tblADComputers.AssetID
Inner Join tblADusers
On tblADusers.ADObjectID = tblADComputers.ManagerADObjectId
Where tblAssetCustom.State = 1
Order By Manager,
tblAssets.AssetName

View solution in original post

2 REPLIES 2
tcooper
Engaged Sweeper III
This worked perfectly. Thank you.
Susan_A
Lansweeper Alumni
The computer manager should be scanned, but I don't think this information is listed on individual computer or user pages. You can run the computer manager report below though, by following these instructions.
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.IPAddress,
tblAssets.Firstseen,
tblAssets.Lastseen,
tblAssets.Lasttried,
tsysOS.Image As icon,
tblADusers.Username As Manager
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tblADComputers On tblAssets.AssetID = tblADComputers.AssetID
Inner Join tblADusers
On tblADusers.ADObjectID = tblADComputers.ManagerADObjectId
Where tblAssetCustom.State = 1
Order By Manager,
tblAssets.AssetName