Report: Count Assets in Static Group

[aemery]

Hello,

I'm relatively new to LANSweeper but I've been tasked with coming up with a report to show the count of assets we have in our Static groups. Data to be used as a report and/or chart.


Output to look something like below.
Group 1 = 20
Group 2 = 30
Group 3 = 40

Any help would be appreciated.

Thanks

[Susan_A · Accepted solution]

I've included a sample report below that counts the active assets in each static group. You can add this report to your Lansweeper installation by following these instructions and display its results on your dashboard with the built-in Data Report widget. You can also display it as a chart with the Chart Report widget, if you give the report a name that starts with "Chart:"

Select Top 1000000 tblAssetGroups.AssetGroup,
  Count(tblAssetGroupLink.AssetID) As Count
From tblAssetCustom
  Inner Join tblAssetGroupLink On tblAssetCustom.AssetID =
    tblAssetGroupLink.AssetID
  Inner Join tblAssetGroups On tblAssetGroups.AssetGroupID =
    tblAssetGroupLink.AssetGroupID
Where tblAssetCustom.State = 1
Group By tblAssetGroups.AssetGroup
Order By tblAssetGroups.AssetGroup