Report query help
08/18/2017 707 views
(Thought I posted this already, but can't find it)
I'm trying to add the software version number to this report query, but I'm not sure what value I need to add, I've tried 'VERSION' which returned an empty column.
SELECT M.NAME AS SYSTEM_NAME, IP, S.DISPLAY_NAME, VERSION, USER_LOGGED USER,LAST_SYNC
FROM MACHINE M
LEFT JOIN MACHINE_SOFTWARE_JT ON M.ID = MACHINE_SOFTWARE_JT.MACHINE_ID
LEFT JOIN SOFTWARE S ON MACHINE_SOFTWARE_JT.SOFTWARE_ID = S.ID
WHERE (S.DISPLAY_NAME like 'Zscaler%')
ORDER BY M.NAME
I want to list all PC's that have a bit of software called 'Zscaler' installed and show it's version.
Also how can run a report that shows only the PC's that don't have it installed please?