Find Computers Which Have Not Been Seen in the Last 30 Days
Find computers with potential network or other issues. Discover devices that have failed to scan the last 30 days. These devices might have a network or other problems that must be resolved. If these devices have been replaced or decommissioned, there are automatic cleanup or archiving settings.
Computer Not Seen in the Last 30 Days Query
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.Domain,
tsysOS.OSname,
tblAssets.Description,
tblAssets.Lastseen As [Last Seen],
tsysOS.Image As icon
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where tblAssets.Lastseen < GetDate() - 30 And tblAssetCustom.State = 1
Order By [Last Seen] Desc,
tblAssets.AssetName
