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
Admin Script Editor
Admin Script Editor is an integrated scripting environment available free here at ITNinja

Share