→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
danielm
Champion Sweeper II
How can the report for "
Device: Not seen in the last 30 days " be filtered to ignore LOCATION asset type

Of course, why is location listed there since it's not a device 🙂
1 ACCEPTED SOLUTION
Daniel_B
Lansweeper Alumni
That report simply lists all assets which are not Windows assets. If you would like to exclude Location assets, you might edit the report and replace the SQL code with the following:

Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.AssetName,
tblAssetCustom.Model,
tblAssetCustom.Manufacturer,
tblAssetCustom.Location,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssetCustom.AssetID
From tblAssetCustom
Inner Join tblAssets On tblAssetCustom.AssetID = tblAssets.AssetID
Inner Join tsysAssetTypes On tblAssets.Assettype = tsysAssetTypes.AssetType
Where tblAssets.Lastseen < GetDate() - 30 And tblAssetCustom.State = 1
And tsysAssetTypes.AssetTypename Not In ('Windows', 'Location')
Order By tblAssets.AssetName

View solution in original post

1 REPLY 1
Daniel_B
Lansweeper Alumni
That report simply lists all assets which are not Windows assets. If you would like to exclude Location assets, you might edit the report and replace the SQL code with the following:

Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.AssetName,
tblAssetCustom.Model,
tblAssetCustom.Manufacturer,
tblAssetCustom.Location,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssetCustom.AssetID
From tblAssetCustom
Inner Join tblAssets On tblAssetCustom.AssetID = tblAssets.AssetID
Inner Join tsysAssetTypes On tblAssets.Assettype = tsysAssetTypes.AssetType
Where tblAssets.Lastseen < GetDate() - 30 And tblAssetCustom.State = 1
And tsysAssetTypes.AssetTypename Not In ('Windows', 'Location')
Order By tblAssets.AssetName

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now