Name of field in database for marked as not allowed
I am trying to create a report that shows any software installed on a computer that we have marked in KACE as not allowed. Unfortunately, I still cannot get MySQL Workbench or HeidiSQL to connect so I cannot wite the SQL statement to pull what I want. I do eventually hope to be able to complete this type of task on my own but can't yet.
I found this statement at http://www.itninja.com/question/kace-report-for-computers-with-specific-software-installed-to-also-display-that-software-title
SELECT M.ID, M.NAME, M.LAST_INVENTORY, M.OS_NAME,
(SELECT GROUP_CONCAT(CONCAT(DISPLAY_NAME, " (", DISPLAY_VERSION, ")")) as Titles
JOIN MACHINE_SOFTWARE_JT on MACHINE_SOFTWARE_JT.SOFTWARE_ID = SOFTWARE.ID
WHERE PUBLISHER like "%Adobe%"
and MACHINE_SOFTWARE_JT.MACHINE_ID = M.ID
GROUP BY MACHINE_ID) AS "Titles"
FROM ORG1.MACHINE M
GROUP BY M.ID ORDER BY M.NAME
We want to find all computers that have software marked as not allowed. So I have marked all software in the discovered and not discovered as not allowed. Now I need a report that will find any not allowed software on any KACE managed computer. I would like to replace the where statement for the Not Allowed filed.
Does anyone happen to have the name of that column in the database?
There are no answers at this time