![Alan_LS Alan_LS](https://community.lansweeper.com/html/assets/User_Avatar.png)
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-21-2019 03:33 AM
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.
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.
Labels:
- Labels:
-
Report Center
2 REPLIES 2
![Alan_LS Alan_LS](https://community.lansweeper.com/html/assets/User_Avatar.png)
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-25-2019 12:18 PM
JacobH, Thank you for your input and it's work
![JacobH JacobH](https://community.lansweeper.com/html/assets/User_Avatar.png)
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-21-2019 02:24 PM
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'
![](/skins/images/C814C14E754F4012AB6B3098C075832D/responsive_peak/images/icon_anonymous_message.png)