Question about Kace reporting
Hi there,
I am new to this product and I am wondering if anybody can give me some advice on the the below:
Just to give you some insight into what I am looking for we are running 2 types of encryption software, Checkpoint and Truecrypt.
I am looking to run a report on machines (LAPTOPS ONLY) that dont have either encryption software installed.
0 Comments
[ + ] Show comments
Answers (1)
Answer Summary:
Please log in to answer
Posted by:
ms01ak
12 years ago
Hi,
Try this report it should give all laptops that don't have checkpoint and truecrypt. I'm not running either of those products so I can't validate the report but give it a shot.
SELECT SC.CONNECT_TIME,SC.DISCONNECT_TIME,CLIENT_VERSION,SC.SMMP_VERSION,MACHINE.DOMAIN,IP,MACHINE.KUID,GROUP_CONCAT(DISTINCT LABEL.NAME SEPARATOR '\n') AS LABEL_NAME_GROUPED,LAST_SYNC,MAC,SC.CLIENT_CONNECTED,MANUAL_ENTRY,SYSTEM_DESCRIPTION,MACHINE.NAME AS SYSTEM_NAME,MACHINE.NOTES AS MACHINE_NOTES,PRINTERS,GROUP_CONCAT(DISTINCT SOFTWARE.PUBLISHER SEPARATOR '\n') AS SOFTWARE_PUBLISHER_GROUPED,GROUP_CONCAT(DISTINCT SOFTWARE.DISPLAY_NAME SEPARATOR '\n') AS SOFTWARE_DISPLAY_NAME_GROUPED FROM MACHINE LEFT JOIN KBSYS.SMMP_CONNECTION SC ON MACHINE.KUID = SC.KUID LEFT JOIN MACHINE_LABEL_JT ON (MACHINE_LABEL_JT.MACHINE_ID = MACHINE.ID) LEFT JOIN LABEL ON (LABEL.ID = MACHINE_LABEL_JT.LABEL_ID AND LABEL.TYPE <> 'hidden') LEFT JOIN MACHINE_SOFTWARE_JT ON (MACHINE_SOFTWARE_JT.MACHINE_ID = MACHINE.ID) LEFT JOIN SOFTWARE ON (SOFTWARE.ID = MACHINE_SOFTWARE_JT.SOFTWARE_ID) WHERE ((CHASSIS_TYPE = 'laptop') AND (SOFTWARE.DISPLAY_NAME not like '%Truecrypt%') AND (SOFTWARE.DISPLAY_NAME not like '%Checkpoint%')) GROUP BY MACHINE.ID ORDER BY SYSTEM_NAME
Cheers,
M
Comments:
-
SELECT SC.CONNECT_TIME,SC.DISCONNECT_TIME,CLIENT_VERSION,SC.SMMP_VERSION,MACHINE.DOMAIN,IP,MACHINE.KUID,GROUP_CONCAT(DISTINCT LABEL.NAME SEPARATOR '\n') AS LABEL_NAME_GROUPED,LAST_SYNC,MAC,SC.CLIENT_CONNECTED,MANUAL_ENTRY,SYSTEM_DESCRIPTION,MACHINE.NAME AS SYSTEM_NAME,MACHINE.NOTES AS MACHINE_NOTES,PRINTERS,GROUP_CONCAT(DISTINCT SOFTWARE.PUBLISHER SEPARATOR '\n') AS SOFTWARE_PUBLISHER_GROUPED,GROUP_CONCAT(DISTINCT SOFTWARE.DISPLAY_NAME SEPARATOR '\n') AS SOFTWARE_DISPLAY_NAME_GROUPED FROM MACHINE LEFT JOIN KBSYS.SMMP_CONNECTION SC ON MACHINE.KUID = SC.KUID LEFT JOIN MACHINE_LABEL_JT ON (MACHINE_LABEL_JT.MACHINE_ID = MACHINE.ID) LEFT JOIN LABEL ON (LABEL.ID = MACHINE_LABEL_JT.LABEL_ID AND LABEL.TYPE <> 'hidden') LEFT JOIN MACHINE_SOFTWARE_JT ON (MACHINE_SOFTWARE_JT.MACHINE_ID = MACHINE.ID) LEFT JOIN SOFTWARE ON (SOFTWARE.ID = MACHINE_SOFTWARE_JT.SOFTWARE_ID) WHERE ((CHASSIS_TYPE = 'laptop') AND (SOFTWARE.DISPLAY_NAME not like '%Truecrypt%') AND (SOFTWARE.DISPLAY_NAME not like '%Checkpoint%')) GROUP BY MACHINE.ID ORDER BY SYSTEM_NAME - ms01ak 12 years ago
