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.

Answer Summary:
Cancel
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Community Chosen Answer

2

Here is what I use

 

Answered 09/04/2013 by: SMal.tmcc
Red Belt

  • Very cool, works like a charm. Thank you very much
    • I throw the last sync in so I know if it needs to be worried about or not. We swap out machines here and sometimes the old machine gets left in Kace.
  • Gotcha. Thank again
Please log in to comment

Answers

0

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
Answered 09/04/2013 by: dugullett
Red Belt

  • Thank you. This works great as well.
Please log in to comment
Answer this question or Comment on this question for clarity

Share