cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Subtitling
Engaged Sweeper
Would someone please show me the Lansweeper code for showing all computers that have software with "ZoneAlarm PRO ANTIVIRUS" and "McAfee Internet Security" in the software title and installed on the same computer? My SQL isn't what it should be! 😞

Many thanks
1 ACCEPTED SOLUTION
Nick_VDB
Champion Sweeper III
Please use the report below for the information that you are after. You can add the report to Lansweeper by following the steps found here. If the software names are not correct you can replace them in report.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where tblAssets.AssetID In (Select Top 1000000 tblAssets.AssetID
From tblAssets Inner Join tblAssetCustom On tblAssets.AssetID =
tblAssetCustom.AssetID Inner Join tsysAssetTypes
On tsysAssetTypes.AssetType = tblAssets.Assettype Inner Join tblSoftware
On tblAssets.AssetID = tblSoftware.AssetID Inner Join tblSoftwareUni
On tblSoftwareUni.SoftID = tblSoftware.softID
Where tblSoftwareUni.softwareName Like '%ZoneAlarm PRO ANTIVIRUS%') And
tblAssets.AssetID In (Select Top 1000000 tblAssets.AssetID
From tblAssets Inner Join tblAssetCustom On tblAssets.AssetID =
tblAssetCustom.AssetID Inner Join tsysAssetTypes
On tsysAssetTypes.AssetType = tblAssets.Assettype Inner Join tblSoftware
On tblAssets.AssetID = tblSoftware.AssetID Inner Join tblSoftwareUni
On tblSoftwareUni.SoftID = tblSoftware.softID
Where tblSoftwareUni.softwareName Like '%McAfee Internet Security%')
And tblAssetCustom.State = 1

View solution in original post

2 REPLIES 2
Subtitling
Engaged Sweeper
Thank you, that works fine.
Nick_VDB
Champion Sweeper III
Please use the report below for the information that you are after. You can add the report to Lansweeper by following the steps found here. If the software names are not correct you can replace them in report.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where tblAssets.AssetID In (Select Top 1000000 tblAssets.AssetID
From tblAssets Inner Join tblAssetCustom On tblAssets.AssetID =
tblAssetCustom.AssetID Inner Join tsysAssetTypes
On tsysAssetTypes.AssetType = tblAssets.Assettype Inner Join tblSoftware
On tblAssets.AssetID = tblSoftware.AssetID Inner Join tblSoftwareUni
On tblSoftwareUni.SoftID = tblSoftware.softID
Where tblSoftwareUni.softwareName Like '%ZoneAlarm PRO ANTIVIRUS%') And
tblAssets.AssetID In (Select Top 1000000 tblAssets.AssetID
From tblAssets Inner Join tblAssetCustom On tblAssets.AssetID =
tblAssetCustom.AssetID Inner Join tsysAssetTypes
On tsysAssetTypes.AssetType = tblAssets.Assettype Inner Join tblSoftware
On tblAssets.AssetID = tblSoftware.AssetID Inner Join tblSoftwareUni
On tblSoftwareUni.SoftID = tblSoftware.softID
Where tblSoftwareUni.softwareName Like '%McAfee Internet Security%')
And tblAssetCustom.State = 1

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now