computers with InSync Mac installed but not running.sql

SELECT M.ID, M.NAME, M.LAST_INVENTORY, M.OS_NAME,
GROUP_CONCAT(DISTINCT SOFTWARE.DISPLAY_NAME SEPARATOR '\n') AS "Software Name",
GROUP_CONCAT(DISTINCT SOFTWARE.DISPLAY_VERSION SEPARATOR '\n') AS "Version",
(select PROCESS.NAME FROM PROCESS JOIN MACHINE_PROCESS_JT on MACHINE_PROCESS_JT.PROCESS_ID = PROCESS.ID WHERE PROCESS.NAME = "inSync" and MACHINE_PROCESS_JT.MACHINE_ID = M.ID) as inSyncProcess


FROM ORG1.MACHINE M
LEFT JOIN MACHINE_SOFTWARE_JT ON (MACHINE_SOFTWARE_JT.MACHINE_ID = M.ID) 
LEFT JOIN SOFTWARE ON (SOFTWARE.ID = MACHINE_SOFTWARE_JT.SOFTWARE_ID) 
WHERE (SOFTWARE.DISPLAY_NAME like 'InSync%')
and OS_NAME like "Mac%"

GROUP BY M.ID 
HAVING inSyncProcess is null
ORDER BY M.NAME