Creating a report which lists all Java version

[asciimov]

Hi there

I am looking to make a report which lists all the different Java version installed on our network, and a count of how many. Once you click on each version, it will then list all hosts with that version installed.

I hope this is possible.

[Hemoco · Accepted solution]

Please use the following report:


Select Top 1000000 tblSoftwareUni.softwareName As software,
tblSoftware.softwareVersion As version,
Count(tblSoftware.SoftwareID) As number
From tblSoftware
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Group By tblSoftwareUni.softwareName,
tblSoftware.softwareVersion
Having tblSoftwareUni.softwareName Like '%java%'
Order By number Desc

To use the report above, do the following:
• Open the report builder under Reports/Create New Report.
• Paste the SQL code we provided at the bottom of the page.
• Left-click somewhere in the upper section of the page so the code applies.
• Give the report a Title and hit the Save & Run button to save it. Export options are listed on the left.