→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
tyuma
Engaged Sweeper
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
1 ACCEPTED SOLUTION
Susan_A
Lansweeper Alumni
There is a built-in report for this, "Software: List of software by computer".

View solution in original post

3 REPLIES 3
Susan_A
Lansweeper Alumni
There is a built-in report for this, "Software: List of software by computer".
Daniel_B
Lansweeper Alumni
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
Engaged Sweeper
Disregard. Thanks.