Rem  Lists all the monitoring templates that have customization specific
Rem  to "Generic Log File Monitoring".

select distinct template_name as "Template Name"
  from mgmt_templates t,
       mgmt_policy_assoc_cfg p
 where t.template_guid = p.object_guid
   and p.policy_guid in (select distinct metric_guid from mgmt_metrics 
                           where target_type = 'host' 
                             and metric_name = 'LogFileMonitoring' 
                             and metric_column = 'log_file_match_count')
   and p.key_value != ' ';