Report Software by Assetgroup

[jrichg]

I am looking for a report that will display the software installed on an Asset by its Asset Group.

- Thanks
Joe

[jrichg · Accepted solution]

For all wondering, I was able to get this done and here is the code snippet how. I thought it would be useful to add why I need this. In our company we separate users by asset and department in their specific asset groups. It works very well for pulling data quickly about a specific departments usage.

Select Distinct Top 1000000 tblSoftwareUni.softwareName As software,
  tblAssetGroups.AssetGroup
From tblSoftware
  Inner Join tblAssets On tblSoftware.AssetID = tblAssets.AssetID
  Inner Join tblSoftwareUni On tblSoftware.softID = tblSoftwareUni.SoftID
  Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
  Inner Join tblAssetGroupLink On tblAssets.AssetID = tblAssetGroupLink.AssetID
  Inner Join tblAssetGroups On tblAssetGroups.AssetGroupID =
    tblAssetGroupLink.AssetGroupID
Where tblAssetCustom.State = 1 And tblComputersystem.Domainrole < 2
Group By tblSoftwareUni.softwareName,
  tblAssetGroups.AssetGroup