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.

 

Answer Summary:
Cancel
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Answers

2

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

Answered 06/27/2012 by: ms01ak
Tenth Degree Black Belt

  • 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
Please log in to comment
Answer this question or Comment on this question for clarity