Report query help
(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?
Please log in to answer
Posted by: chucksteel 3 years ago
Use the S.DISPLAY_VERSION column instead of VERSION. I don't know why KACE doesn't populate the VERSION column, but DISPLAY_VERSION normally works.
To create a report of machines that don't have it installed, I would recommend performing an advanced search in the inventory for computers where software titles does not include "Zscaler". Then under Choose Action, Create Report.