I need to create a Smart Label to give me what version of Java each of my users has loaded on their computers.
3 Comments   [ + ] Show Comments

Comments

  • You could but using the reporting wizard would be easier and you can then sort by software title to see which machine as which version. You can change around the < 9 line if you want.


    SELECT DISTINCT MACHINE.NAME AS DEVICE,SOFTWARE.DISPLAY_NAME AS SOFTWARE, SOFTWARE.DISPLAY_VERSION AS VERSION FROM MACHINE_SOFTWARE_JT,MACHINE,SOFTWARE
    WHERE SOFTWARE_ID = SOFTWARE.ID AND
    MACHINE_ID = MACHINE.ID
    AND
    DISPLAY_NAME LIKE "%JAVA%"
    AND DISPLAY_NAME NOT LIKE "JAVA AUTO UPDATER" AND DISPLAY_NAME NOT LIKE "%SE Development%"
    AND DISPLAY_VERSION < 9
    /*AND DISPLAY_NAME LIKE "%(64-BIT)%" OR "%32-BIT)%"*/
    ORDER BY VERSION DESC, MACHINE.NAME
  • The only thing I would add is that the Smart Label would be better if you find that you need to target machines for updates or version removal.
  • Thank You So, Much for your assistance. I decided to make a Smart Label.
Please log in to comment

Answers

1
If you want a custom inventory rule this will work on both Windows and Mac:
ShellCommandTextReturn(java -version)

Answered 07/28/2016 by: chucksteel
Red Belt

Please log in to comment
Answer this question or Comment on this question for clarity