
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-01-2016 03:06 PM
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
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
Solved! Go to Solution.
Labels:
- Labels:
-
Report Center
1 ACCEPTED SOLUTION
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-06-2016 04:03 PM
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
1 REPLY 1
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-06-2016 04:03 PM
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
