KACE Product Support

Hello,

I have been working on report in KACE to tell us which of our devices have crowdstrike installed and which do not. Here is what I have so far:

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 "%CrowdStrike%"

and MACHINE_SOFTWARE_JT.MACHINE_ID = M.ID

GROUP BY MACHINE_ID) AS "Titles"

FROM ORG1.MACHINE M

GROUP BY M.ID ORDER BY Titles desc

I want to break off into a new table once the Titles field is empty but I can't quite figure out how to do that. I can provide more info if needed, any help is appreciated!