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!
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
