cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Alan_LS
Engaged Sweeper II
How to create a report or a way to trace the last LsAgent scan time?
I have been discovered a number of systems did not report to Lansweeper for a couple of days or even a few weeks. It will be good to have such a report to surface out which system's LsAgent is not functioning and thus perform the troubleshooting.
2 REPLIES 2
Alan_LS
Engaged Sweeper II
JacobH, Thank you for your input and it's work
JacobH
Champion Sweeper III
Though I don't use LSAgent, this report is what I use for Last LSPush scan.. I changed it from LastLSPush to LastLSAgent, so it should work. (My report has no results obviously)



Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblAssets.LastLsAgent As [Last LsAgent 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.LastLsAgent,
'1900-01-01') <> '1900-01-01'