Endpoint Protection

People,

In SEPM 12.1.6 how can I generate the report which computer / Server is not running PTP/NTP components ?

I usually using this SQL script below but it would be great if anyone can assist to modify it to show th components:

SELECT i.computer_name, 
       agent_version, 
       pat.version   AS AV_REVISION, 
       Dateadd(s, CONVERT(BIGINT, last_update_time) / 1000, 
       '01-01-1970 00:00:00') 
                     LASTUPDATETIME, 
       g.NAME        AS GROUP_NAME, 
       i.operation_system, 
       i.current_login_user, 
       i.mac_addr1   "MAC Address", 
       ip_addr1_text "IP Address", 
       i.deleted     "Marked for deletion" 
FROM   sem_agent AS sa WITH (nolock) 
       LEFT OUTER JOIN pattern pat 
                    ON sa.pattern_idx = pat.pattern_idx 
       INNER JOIN v_sem_computer i 
               ON i.computer_id = sa.computer_id 
       INNER JOIN identity_map g 
               ON g.id = sa.group_id 
       INNER JOIN identity_map p 
               ON p.id = sa.last_server_id 
       INNER JOIN identity_map s 
               ON s.id = sa.domain_id 
       INNER JOIN identity_map q 
               ON q.id = sa.last_site_id 
WHERE  ( sa.agent_type = '105' 
          OR sa.agent_type = '151' ) 
       AND sa.deleted = '0' 
       AND I.deleted = 0 
ORDER  BY group_name, 
          operation_system, 
          i.computer_name 

Thanks.

You'll need to go through the DB scheme:

Symantec Endpoint Protection 12.1.6 database schema