→ 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: 
SEC_ALERTS
Engaged Sweeper
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
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
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

View solution in original post

2 REPLIES 2
SEC_ALERTS
Engaged Sweeper
Thanks a lot !!!
Hemoco
Lansweeper Alumni
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