AD Description does not match Last Logged in User

[berickson]

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

[Susan_A · Accepted solution]

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