→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
berickson
Engaged Sweeper
Im looking for a report that will show all machine descriptions in AD that do not match the last Logged in User

For example.

If Desktop1 has a description of Bob, Joe in AD but the last logged in user was Smith, Jane the report would give me the machine name and what OU its located in as well as the last logged in user and the current description of the machine in AD.

Thank you
1 ACCEPTED SOLUTION
Susan_A
Lansweeper Alumni
I assume you are referring to the display name of the user. If so, please use the report below to list machines whose AD description does not match the display name of the last logged on user. You can add this report to your Lansweeper installation by following these instructions.
Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.Username,
tblAssets.Userdomain,
tblADusers.Displayname,
tblAssets.IPAddress,
tblADComputers.Description,
tblADComputers.OU,
tblAssets.Firstseen,
tblAssets.Lastseen,
tblAssets.Lasttried
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblADComputers On tblAssets.AssetID = tblADComputers.AssetID
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tblADusers On tblADusers.Username = tblAssets.Username And
tblADusers.Userdomain = tblAssets.Userdomain And
tblADComputers.Description <> tblADusers.Displayname
Where tblAssetCustom.State = 1
Order By tblAssets.Domain,
tblAssets.AssetName

View solution in original post

1 REPLY 1
Susan_A
Lansweeper Alumni
I assume you are referring to the display name of the user. If so, please use the report below to list machines whose AD description does not match the display name of the last logged on user. You can add this report to your Lansweeper installation by following these instructions.
Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.Username,
tblAssets.Userdomain,
tblADusers.Displayname,
tblAssets.IPAddress,
tblADComputers.Description,
tblADComputers.OU,
tblAssets.Firstseen,
tblAssets.Lastseen,
tblAssets.Lasttried
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblADComputers On tblAssets.AssetID = tblADComputers.AssetID
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tblADusers On tblADusers.Username = tblAssets.Username And
tblADusers.Userdomain = tblAssets.Userdomain And
tblADComputers.Description <> tblADusers.Displayname
Where tblAssetCustom.State = 1
Order By tblAssets.Domain,
tblAssets.AssetName