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
FROM SOFTWARE
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?
0 Comments
[ + ] Show comments
Answers (0)
Please log in to answer
Be the first to answer this question
