→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
jgessay
Engaged Sweeper
My department has asked that I generate a report listing all the computers on our network with the latest version(s) of Adobe Flash and Java installed. Is this a report that already exists in Lansweeper? Or must I create a customized report to show just this information?

1 ACCEPTED SOLUTION
Daniel_B
Lansweeper Alumni
The built-in report "Software: List of software by computer" helps you to get a list of PCs with all software installed on them. You can filter in column Software for what you are interested in to see. If you would like to list all computers not having a specific version installed, use a custom report like the one below. It lists workstation computers not having one of the two defined software packages installed, together with what currently is installed on them.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Lastseen,
tSoftware.softwareName As [Software present on system],
tSoftware.softwareVersion
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Left Join (Select tblSoftware.AssetID,
tblSoftwareUni.softwareName,
tblSoftware.softwareVersion
From tblSoftware
Inner Join tblSoftwareUni On tblSoftware.softID = tblSoftwareUni.SoftID
Where (tblSoftwareUni.softwareName Like 'adobe flash player%') Or
(tblSoftwareUni.softwareName Like 'java %')) tSoftware
On tSoftware.AssetID = tblAssets.AssetID
Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
Where (tblAssets.AssetID Not In (Select tblSoftware.AssetID
From tblSoftware Inner Join tblSoftwareUni On tblSoftware.softID =
tblSoftwareUni.SoftID
Where tblSoftwareUni.softwareName Like 'adobe flash player%' And
tblSoftware.softwareVersion Like '16.0.0.235') Or
tblAssets.AssetID Not In (Select tblSoftware.AssetID
From tblSoftware Inner Join tblSoftwareUni On tblSoftware.softID =
tblSoftwareUni.SoftID
Where tblSoftwareUni.softwareName Like 'java 8 update 35%')) And
tblAssetCustom.State = 1 And tblComputersystem.Domainrole < 2
Order By tblAssets.AssetName,
[Software present on system]

View solution in original post

1 REPLY 1
Daniel_B
Lansweeper Alumni
The built-in report "Software: List of software by computer" helps you to get a list of PCs with all software installed on them. You can filter in column Software for what you are interested in to see. If you would like to list all computers not having a specific version installed, use a custom report like the one below. It lists workstation computers not having one of the two defined software packages installed, together with what currently is installed on them.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Lastseen,
tSoftware.softwareName As [Software present on system],
tSoftware.softwareVersion
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Left Join (Select tblSoftware.AssetID,
tblSoftwareUni.softwareName,
tblSoftware.softwareVersion
From tblSoftware
Inner Join tblSoftwareUni On tblSoftware.softID = tblSoftwareUni.SoftID
Where (tblSoftwareUni.softwareName Like 'adobe flash player%') Or
(tblSoftwareUni.softwareName Like 'java %')) tSoftware
On tSoftware.AssetID = tblAssets.AssetID
Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
Where (tblAssets.AssetID Not In (Select tblSoftware.AssetID
From tblSoftware Inner Join tblSoftwareUni On tblSoftware.softID =
tblSoftwareUni.SoftID
Where tblSoftwareUni.softwareName Like 'adobe flash player%' And
tblSoftware.softwareVersion Like '16.0.0.235') Or
tblAssets.AssetID Not In (Select tblSoftware.AssetID
From tblSoftware Inner Join tblSoftwareUni On tblSoftware.softID =
tblSoftwareUni.SoftID
Where tblSoftwareUni.softwareName Like 'java 8 update 35%')) And
tblAssetCustom.State = 1 And tblComputersystem.Domainrole < 2
Order By tblAssets.AssetName,
[Software present on system]