Reports

Computer Not Seen in the Last 7 Days

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

Show

Hide

Ready to get started?

Explore the full platform, free for 14 days.
No credit card required.

Need help evaluating?
Get guidance on pricing at scale and enterprise requirements.
Talk to sales
Clear pricing as you grow
Transparent plans that scale with your environment.
View plans & pricing