Notification

Icon
Error

LSAgent Report

Posted: Monday, June 14, 2021 1:10:12 PM(UTC)
brodiemac-too

brodiemac-too

Member Original PosterPosts: 42
0
Like
This issue has been solved! Click here to view the solution
Need help modifying the lsagent not seen in 7 days report to show only active devices. Any help is always appreciated.
Brandon
#1Brandon Member Posts: 169  
posted: 6/14/2021 5:17:00 PM(UTC)
This should work.

Quote:
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName As [Asset Name],
tblLsAgentGroup.Name As [LsAgent Group],
tblAssets.LastLsAgent As [Last LsAgent Scan],
tblAssets.LsAgentVersion,
tblLsAgentAssetState.statename As Status,
tblAssets.Domain,
tblAssets.Username,
tblAssets.IPAddress As [Last known IP],
tsysOS.OSname As OS,
tblAssets.SP As [Service Pack],
tblAssets.Description
From tblAssets
Inner Join tblLsAgentAsset On tblLsAgentAsset.AssetID = tblAssets.AssetID
Inner Join tblLsAgentAssetState On tblLsAgentAssetState.id =
tblLsAgentAsset.Status
Inner Join tblLsAgentGroup On tblLsAgentGroup.LsAgentGroupID =
tblLsAgentAsset.LsAgentGroupID
Left Join tsysOS On tblAssets.OScode = tsysOS.OScode
Inner Join lansweeperdb.dbo.tblAssetCustom On tblAssets.AssetID =
tblAssetCustom.AssetID
Where tblAssets.LastLsAgent < GetDate() - 7 And tblAssetCustom.State = 1
Order By [Last LsAgent Scan] Desc,
[Asset Name]
brodiemac-too
#2brodiemac-too Member Original PosterPosts: 42  
posted: 6/14/2021 5:27:29 PM(UTC)
Perfect, thank you!

Active Discussions

Lansweeper Monitor history showing only last monitors
by  cross_eur   Go to last post Go to first unread
Last post: 7/23/2021 6:06:51 PM(UTC)
Lansweeper Report Login time reduces number of computers by 300
by  cross_eur  
Go to last post Go to first unread
Last post: 7/23/2021 6:05:42 PM(UTC)
Lansweeper Merging 2 reports
by  Apaulcolypse   Go to last post Go to first unread
Last post: 7/22/2021 10:02:59 PM(UTC)
Lansweeper HELP - Add Registry Key Values to Asset Report
by  Apaulcolypse  
Go to last post Go to first unread
Last post: 7/22/2021 9:26:43 PM(UTC)
Lansweeper Can I request a custom report here?
by  Brian G   Go to last post Go to first unread
Last post: 7/22/2021 7:20:56 PM(UTC)
Lansweeper List all users with E-mail address
by  Brandon  
Go to last post Go to first unread
Last post: 7/21/2021 7:06:36 PM(UTC)
Lansweeper Identifying users of Windows legacy authentication
by  Baronet   Go to last post Go to first unread
Last post: 7/21/2021 5:26:38 PM(UTC)
Lansweeper Windows Version different between reports
by  RC62N  
Go to last post Go to first unread
Last post: 7/21/2021 3:27:04 PM(UTC)