Detect Computers Which Have Not Been Seen in the Last 7 Days
Detect computers with potential network or other issues. Discover devices that fail to scan the last 7 days. These devices might have network or other issues which might need to be resolved. If these devices have been replaced or decommissioned, there are settings for automatic cleanup or archiving.
Computer Not Seen in the Last 7 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() - 7 And tblAssetCustom.State = 1 Order By [Last Seen] Desc, tblAssets.AssetName