cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Windows: Not seen in the last 30 days (Built-in)

Daniel_B
Lansweeper Former Employee
Lansweeper Former Employee
Old name: Computer: Not seen in the last 30 days (Built-in)

The report below lists Windows based assets that were not scanned within the last 30 days

The report will only list assets that meet all of the following criteria:
  • The asset state is set to "active".
  • The asset has been successfully scanned at least once.
  • The asset is a Windows computer.
  • The Last seen date is more than 30 days ago.


Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.Username,
tblAssets.Userdomain,
Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon,
tblAssets.IPAddress,
tsysIPLocations.IPLocation,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tsysOS.OSname As OS,
tblAssets.SP,
tblAssets.Lastseen,
tblAssets.Lasttried,
tsysAssetTypes.AssetTypename
From tblAssets
Left Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tsysIPLocations On tsysIPLocations.LocationID =
tblAssets.LocationID
Inner Join tblState On tblState.State = tblAssetCustom.State
Where tblAssets.Lastseen < GetDate() - 30 And tblState.Statename = 'Active' And
(tsysAssetTypes.AssetTypename = 'Windows' Or tsysAssetTypes.AssetTypename =
'Windows CE')
Order By tblAssets.Domain,
tblAssets.AssetName
1 REPLY 1

Shawn_Heydorn
Engaged Sweeper
I personally do not want to see assets in the last 30 days, I want to see them older than 30 days. I used the statement below this instead of "Where tblAssets.Lastseen < GetDate() - 30"

Where tblAssets.Lastseen Between DateAdd(day, -999, Current_TimeStamp)
And DateAdd(day, -30, Current_TimeStamp)