Installed applications by computer

[Liam_O]

Hello All,

I'm looked for a report that lists all workstations, with a count of installed applications next to each one, with the asset status if possible.

The part I’m struggling on is returning a count of installed applications, instead of listing the device multiple times with the individual software.

Any help would be greatly appreciated.

Thanks, Liam.

[Liam_O]

Bruce, that is exactly what I needed! Thank you.

[Bruce_B · Accepted solution]

The report below lists all Windows workstations with their state and a total count of scanned software.

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tblState.Statename,
  tsysAssetTypes.AssetTypename,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.IPAddress,
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  Count(tblSoftwareUni.softwareName) As [Software count]
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Inner Join tblState On tblState.State = tblAssetCustom.State
  Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
  Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
  Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
  Inner Join tblDomainroles On tblDomainroles.Domainrole =
    tblComputersystem.Domainrole
Group By tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tblState.Statename,
  tsysAssetTypes.AssetTypename,
  tsysAssetTypes.AssetTypeIcon10,
  tblAssets.IPAddress,
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  tblDomainroles.Domainrolename
Having tblDomainroles.Domainrolename Like '%workstation%'
Order By tblAssets.Domain,
  tblAssets.AssetName