K1000 Report that displays a count of Java Installations
I need to create a report that will display a count of Java version xxx.xxx installed on all of machines managed by KACE.
It can be any format or even graphical in nature. For example the report needs to tell me I have 80 machines with Java 7 Update 25, 125 machines with Java 7 update 16, etc.
0 Comments
[ + ] Show comments
Answers (2)
Answer Summary:
Please log in to answer
Posted by:
dugullett
11 years ago
It sounds like Smal has already answered this, but here's another form of what you can use. This will only include machines that have inventoried in the past two weeks. If you don't need that take that line out.
SELECT S.DISPLAY_NAME, COUNT(DISTINCT M.NAME) AS 'Machine Count' FROM MACHINE M LEFT JOIN MACHINE_SOFTWARE_JT MSJT ON M.ID = MSJT.MACHINE_ID LEFT JOIN SOFTWARE S ON MSJT.SOFTWARE_ID = S.ID WHERE S.DISPLAY_NAME LIKE 'JAVA %' AND S.DISPLAY_NAME LIKE '%UPDATE%' AND M.LAST_SYNC > DATE_SUB(NOW(), INTERVAL 2 WEEK) GROUP BY S.DISPLAY_NAME ORDER BY S.DISPLAY_NAME
Comments:
-
Thank you. This works great as well. - wd_bs 11 years ago
