Canned Software Report

[tyuma]

Hi,

I'm using the canned report 'Software: All installed software' as seen blow however this does not list the asset name (computer name) that these programs are installed on. What needs to be modified in this query for me to ba able to see what machine the reported software is installed on? The rest of the report is great but just missing that one piece. Please advise. Much obliged.

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
Where tblAssetCustom.State = 1
Group By tblSoftwareUni.softwareName,
tblSoftware.softwareVersion,
tblSoftwareUni.SoftwarePublisher
Order By Total Desc

[Susan_A · Accepted solution]

There is a built-in report for this, "Software: List of software by computer".

[Daniel_B]

The report above lists counts of installations per software. Therefore individual assetnames can't be displayed.
If you would like to list software and computers on which the software is installed, add tblSoftware and tblSoftwareUni to a new report and select tblSoftwareUni.softwareName, tblSoftware.softwarePublisher and tblSoftware.softwareVersion. We recommend adding a filter as otherwise this will be a long list.

[tyuma]

Disregard. Thanks.