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 Changing/Editing tblComputerSystem.DomainRole
by  Brian.Kintech   Go to last post Go to first unread
Last post: Today at 7:23:33 PM(UTC)
Lansweeper Insert custom report into database
by  mc_connected  
Go to last post Go to first unread
Last post: Today at 3:46:06 PM(UTC)
Lansweeper LsAgent deployment problem
by  krejar   Go to last post Go to first unread
Last post: Today at 3:45:41 PM(UTC)
Lansweeper Static Text block for tickets...
by  Jay29  
Go to last post Go to first unread
Last post: Today at 2:41:29 PM(UTC)
Lansweeper Local Workstation and or User Profile Size
by  Argon0   Go to last post Go to first unread
Last post: Today at 10:03:10 AM(UTC)
Lansweeper Suggestions for SonicWall Setup
by  AZHockeyNut  
Go to last post Go to first unread
Last post: Yesterday at 3:32:33 PM(UTC)
Lansweeper Spare Hard Drives
by  AZHockeyNut   Go to last post Go to first unread
Last post: Yesterday at 3:20:40 PM(UTC)
Lansweeper Add Document as File Link
by  AZHockeyNut  
Go to last post Go to first unread
Last post: Yesterday at 3:18:49 PM(UTC)