→ 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: 
atul557
Engaged Sweeper III
hi all,

I want to get a report of machines having programfiles\java\jre version with path installed.
the reason for creating this report is for vulnerability identified as 'Oracle Java Out of Date'.

Thanks & Regards

Atul S
2 REPLIES 2
AM13337
Engaged Sweeper III
You could also create a Dynamic Group to give you this information, it's easier then a report and after you could export it.

I have my filters setup as such:

Software Installed - Like - Java
Software Installed - Not Like - Java 8 Update 111
IP Location - Like - City
Domain - Like - My Domain
sullivane
Champion Sweeper III
Here is my report that shows you all assets with Java install that is not equal to the version you set. If you install the newest version you can get that number and plug it in.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique,
tblSoftwareUni.softwareName,
tblSoftwareUni.SoftwarePublisher,
tblAssets.AssetName,
tblSoftware.softwareVersion
From tblAssets
Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftware.softID = tblSoftwareUni.SoftID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Where tblSoftwareUni.softwareName Like '%Java%' And
tblSoftwareUni.SoftwarePublisher Like '%Oracle%' And
tblSoftware.softwareVersion Not Like '%8.0.1010.13%' And
tblAssetCustom.State = 1
Order By tblAssets.AssetName