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