cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
stephane_leblan
Engaged Sweeper
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
1 ACCEPTED SOLUTION
RCorbeil
Honored Sweeper II
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

View solution in original post

2 REPLIES 2
stephane_leblan
Engaged Sweeper
Thanks for the quick response. It's exactly what I was looking for.

Cheers
RCorbeil
Honored Sweeper II
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