Report Filter

[C1Hol]

Hello 🙂

Want to create Reports for specific Asset Groups. For example a All Software Report for Asset Group 1

I tried to edit the All Software Report but the filter doesn't really apply.
I want to create more Reports like Hardware for specific Asset Group so it would be awesome if someone could tell me how to filter it.

Select Top 1000000 tblSoftwareUni.softwareName As Software,
  tblSoftware.softwareVersion As Version,
  tblSoftwareUni.SoftwarePublisher As Publisher,
  Count(tblSoftware.AssetID) As Total
From tblSoftware
  Inner Join tblAssets On tblSoftware.AssetID = tblAssets.AssetID
  Inner Join tblSoftwareUni On tblSoftware.softID = tblSoftwareUni.SoftID
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID,
  tblAssetGroups
Where tblAssetCustom.State = 1
Group By tblSoftwareUni.softwareName,
  tblSoftware.softwareVersion,
  tblSoftwareUni.SoftwarePublisher,
  tblAssetGroups.AssetGroup
Having tblAssetGroups.AssetGroup Like '%ASSET1%'
Order By Count(tblSoftware.AssetID) Desc

[Hemoco · Accepted solution]

You haven't linked tblAssetGroups to anything. Please try the report below instead. Note that clicking on a software link will still take you to a list of all computers that have that software installed, as these links are generated internally.

Select Top 1000000 tblSoftwareUni.softwareName As Software,
tblSoftware.softwareVersion As Version,
tblSoftwareUni.SoftwarePublisher As Publisher,
Count(tblSoftware.AssetID) As Total
From tblSoftware
Inner Join tblAssets On tblSoftware.AssetID = tblAssets.AssetID
Inner Join tblSoftwareUni On tblSoftware.softID = tblSoftwareUni.SoftID
Inner Join tblAssetGroupLink On tblAssets.AssetID = tblAssetGroupLink.AssetID
Inner Join tblAssetGroups On tblAssetGroups.AssetGroupID =
tblAssetGroupLink.AssetGroupID
Where tblAssetGroups.AssetGroup Like '%ASSET1%'
Group By tblSoftwareUni.softwareName,
tblSoftware.softwareVersion,
tblSoftwareUni.SoftwarePublisher