Is there a way to create a Smart Label in Kace to tell which version of Java my users have on their computer.
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
Answers (1)
Please log in to answer
Posted by:
chucksteel
8 years ago
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 - nshah 8 years ago