/build/static/layout/Breadcrumb_cap_w.png
08/18/2017 707 views
Hi,

(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?

Thanks
0 Comments   [ + ] Show comments

Comments


All Answers

0
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.

Answered 08/21/2017 by: chucksteel
Red Belt