Computer Not Seen in the Last 30 Days

Find Computers Which Have Not Been Seen in the Last 30 Days

Find computers with potential network or other issues. Discover devices that fail to scan the last 30 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 30 days

Click to Open - 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

Run This Report in 3 Easy Steps

Download-Install-Lansweeper

1. Download & Install Lansweeper

Save-and-Run-the-Report

3. Run the Report

Download Lansweeper to Run this Report

Harness the Power of Reporting