→ The Lansweeper Customer Excellence Awards 2024 - Submit Your Project Now! Learn More & Enter Here

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.