Is there a report or Label that I can create to see if I have multiple version of Java such as 32 bits and 64 bits installed on my users computers...
1 Comment   [ + ] Show Comment

Comments

  • As in, any machines that have multiple java installs?
Please log in to comment

Answers

0
Same report I gave you in the other post, just Break on Column to DEVICE. Again the wizard can do this as well. 

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)%"*/



Answered 07/26/2016 by: nshah
Red Belt

  • I got the following error: Error Running Report

    The query does not contain specified break field.
    • try MACHINE.NAME instead of DEVICE in the Break on Column field.
      • It will not except Machine.Name as a Break
Please log in to comment
Answer this question or Comment on this question for clarity