Graph on Front page

[chads]

Chart: Asset Summary

Is there a way to get such a graph to only show asset location. So be able to select only show Site B or only Site A?

[chads]

This looks awesome now.. Now i just need to figure out other reports like i did for software for the sites. trying to create site based tabs 🙂

[Hemoco]

This should look better:

Select Top 1000000 tsysAssetTypes.AssetTypename,
Count(tblAssets.AssetID) As Total
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tblAssets.Assettype = tsysAssetTypes.AssetType
Left Outer Join tsysIPLocations On tblAssets.IPNumeric >=
tsysIPLocations.StartIP And tblAssets.IPNumeric <= tsysIPLocations.EndIP
Where tblAssetCustom.State = 1 And tsysIPLocations.IPLocation = 'site A'
Group By tsysAssetTypes.AssetTypename
Order By Count(tblAssets.AssetID) Desc

[chads]

Ok tried this it is listing the IP Location but it is not breaking down like the Chart: Asset Type Summary.

Should i create a duplicate report like Chart: Asset Type Summary and tweak it to where it only queries the specific IP Location i want to show? if so what would that code look like.

[Hemoco]

Please try this sql code:

Select Top 1000000 Count(tblAssets.AssetID) As total,
tsysIPLocations.IPLocation
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Left Outer Join tsysIPLocations On tblAssets.IPNumeric >=
tsysIPLocations.StartIP And tblAssets.IPNumeric <= tsysIPLocations.EndIP
Where tblAssetCustom.State = 1
Group By tsysIPLocations.IPLocation
Having tsysIPLocations.IPLocation = 'site A'