All installed software’s Report

[SEC_ALERTS]

Hi Team,

I have already refereed built-in report with same name but need more fields.
Need one single report for all installed software’s with below details.

Software name
Software version
Software publisher
Software count
Asset name
IP address

Thanks in Advance!!!

Regards,
SEC_ALERTS

[SEC_ALERTS]

Thanks a lot !!!

[Hemoco · Accepted solution]

Please use the report below.

Select Top 1000000 tblSoftwareUni.softwareName As Software,
tblSoftware.softwareVersion As Version,
tblSoftwareUni.SoftwarePublisher As Publisher,
SubQuery1.Total As Count,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.IPAddress
From tblSoftware
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Inner Join tblAssets On tblAssets.AssetID = tblSoftware.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join (Select Top 1000000 tblSoftwareUni.softwareName,
tblSoftware.softwareVersion,
tblSoftwareUni.SoftwarePublisher,
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) SubQuery1 On SubQuery1.softwareName =
tblSoftwareUni.softwareName And SubQuery1.softwareVersion =
tblSoftware.softwareVersion And SubQuery1.SoftwarePublisher =
tblSoftwareUni.SoftwarePublisher
Where tblAssetCustom.State = 1
Order By Count Desc,
Software,
Version,
tblAssets.AssetName