Java installed path

[atul557]

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

[AM13337]

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]

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