Rem Lists all the host names which have custom thresholds corresponding
Rem to "Log File Matched Pattern Line Count" for "Generic Log File Monitoring". 


select distinct target_name as "Hosts with thresholds"
  from mgmt_targets t,
       mgmt_metric_thresholds th
 where th.metric_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 th.key_value != ' '
   and th.target_guid = t.target_guid
   and t.target_type = 'host';