/bundles/itninjaweb/img/Breadcrumb_cap_w.png
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   [ - ] Hide Comments

Comments

Please log in to comment

There are no answers at this time
Answer this question or Comment on this question for clarity

Answers

Share