LsAgent last scan timing

[Alan_LS]

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.

[Alan_LS]

JacobH, Thank you for your input and it's work

[JacobH]

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'