Community FAQ
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
danielk
Engaged Sweeper III
is there a view to see which computers were scanned by lspush? Thanks
1 ACCEPTED SOLUTION
Daniel_B
Lansweeper Alumni
By running the following report you will receive a list of computers which have been scanned with LsPush:

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblAssets.LastLsPush As [Last LsPush scan]
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where tblAssetCustom.State = 1 And Coalesce(tblAssets.LastLsPush,
'1900-01-01') <> '1900-01-01'


For instructions on how to run a report, please refer to this forum note.

View solution in original post

2 REPLIES 2
Susan_A
Lansweeper Alumni
Just an FYI: you can also look at the Last LsPush Scan value in the Scan Time tab of individual computer webpages to determine whether and when computers were scanned by LsPush.
Daniel_B
Lansweeper Alumni
By running the following report you will receive a list of computers which have been scanned with LsPush:

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblAssets.LastLsPush As [Last LsPush scan]
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where tblAssetCustom.State = 1 And Coalesce(tblAssets.LastLsPush,
'1900-01-01') <> '1900-01-01'


For instructions on how to run a report, please refer to this forum note.

Reports & Analytics

Ask about reports you're interested in and share reports you've created. Subscribe to receive daily updates of reports shared in the Community.

New to Lansweeper?

Try Lansweeper For Free

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

Try Now