
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-19-2013 08:55 PM
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
Thanks
Solved! Go to Solution.
Labels:
- Labels:
-
Report Center
1 ACCEPTED SOLUTION
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-19-2013 09:54 PM
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.
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
2 REPLIES 2

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-20-2013 06:15 PM
Thanks for the quick response. It's exactly what I was looking for.
Cheers
Cheers
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-19-2013 09:54 PM
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.
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
