Notification

Icon
Error

Asset names in chart report

Posted: Tuesday, June 11, 2019 7:37:53 AM(UTC)
Johnny

Johnny

Member Original PosterPosts: 7
0
Like
Hi,

I have a chart report for Antivirus up to date, see below. When I hoover the charts it lists the number of computers that are true or false. Is it possible to list asset names instead when hoovering?

Thanks in advance!

Quote:

Select Top 1000000 tblAntivirus.productUpToDate,
Count(tblAssets.AssetID) As Total
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblAntivirus On tblAssets.AssetID = tblAntivirus.AssetID
Left Join tsysIPLocations On tblAssets.LocationID = tsysIPLocations.LocationID
Where (tblAntivirus.productUpToDate = 0 And tblAssetCustom.State = 1) Or
(tblAntivirus.productUpToDate = 1)
Group By tblAntivirus.productUpToDate
Order By Total Desc,
tblAntivirus.productUpToDate

Active Discussions

Lansweeper BlueKeep Vulnerability
by  miek_g   Go to last post Go to first unread
Last post: Today at 3:09:22 PM(UTC)
Report Center Failed Logins Report/Chart
by  KDavis  
Go to last post Go to first unread
Last post: Today at 1:17:05 AM(UTC)
Lansweeper Office 365 OneDrive Usage and Sync
by  AZHockeyNut   Go to last post Go to first unread
Last post: Yesterday at 7:17:50 PM(UTC)
Lansweeper Firefox 67.0.3 zero-day vulnerability
by  B Claeys  
Go to last post Go to first unread
Last post: Yesterday at 3:13:30 PM(UTC)
Lansweeper VLC Player CVE-2019-5439
by  Esben.D   Go to last post Go to first unread
Last post: 6/18/2019 9:19:29 AM(UTC)
Lansweeper Enabled/Disabled Local/AD Admin accounts
by  vqT4cDoP9iXyMZwoDUWU  
Go to last post Go to first unread
Last post: 6/17/2019 9:12:30 PM(UTC)
Lansweeper code in posts
by  AZHockeyNut   Go to last post Go to first unread
Last post: 6/14/2019 4:39:46 PM(UTC)