Request Query to show only software installed on specific OS

[stephane_leblan]

I'm looking to produce a report that would list all installed software on only Windows 7 systems within my domain. Any help would be appreciated.

Thanks

[stephane_leblan]

Thanks for the quick response. It's exactly what I was looking for.

Cheers

[RCorbeil · Accepted solution]

Minor tweak to the Software: All installed software report.

1. Add a link to tSysOS in order to find the OS name.
2. Add two filters to the WHERE clause for your domain and the OS name.

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
  INNER JOIN tSysOS         ON tSysOS.OSCode = tblAssets.OSCode
WHERE
  tblAssetCustom.State = 1
  AND tblAssets.Domain = 'your_domain'
  AND tSysOS.OSName = 'Win 7'
GROUP BY
  tblSoftwareUni.softwareName,
  tblSoftware.softwareVersion,
  tblSoftwareUni.SoftwarePublisher
ORDER BY
  Count(tblSoftware.AssetID) Desc