cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
cojast
Engaged Sweeper III
I was just wondering if there was a setting or something that can be changed so we can see more then the last 10 Assets or Users scanned on the main page?
3 REPLIES 3
Hemoco
Lansweeper Alumni
You can create a custom report with the information you are after and add it to the Data Report widget.

Last Seen Assets
Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Lastseen
From tblAssets
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Order By tblAssets.Lastseen Desc


Last Seen Users
Select Top 10 tblAssets.Username,
tblAssets.Userdomain,
Coalesce(tblADusers.Displayname, tblAssets.Username) As Displayname,
tblAssets.Lastseen,
tblAssets.AssetID,
tblAssets.AssetName,
Coalesce(tsysOS.Image, 'notscanned.png') As compimage
From tblAssets
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Left Outer Join tblADusers On tblAssets.Userdomain = tblADusers.Userdomain And
tblAssets.Username = tblADusers.Username
Where Not (tblAssets.Username Is Null) And tblAssets.Username <> ''
Order By tblAssets.Lastseen Desc
cojast
Engaged Sweeper III
On the default main page on the right hand side you have scanning status, Last Seen Assets, last Seen Users,and Lansweeper Latest News
Hemoco
Lansweeper Alumni
Could you please clarify which specific page/report/widget you're referring to.