/build/static/layout/Breadcrumb_cap_w.png

KACE Product Support Question


Name of field in database for marked as not allowed

01/04/2018 680 views
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

Comments


Be the first to answer this question

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ