→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
aemery
Engaged Sweeper
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
1 ACCEPTED SOLUTION
Susan_A
Lansweeper Alumni
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

View solution in original post

1 REPLY 1
Susan_A
Lansweeper Alumni
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