Enterprise Manager

Show open incidents related to filesystem capacity Enterprise Manager

  SELECT a.incident_id,
         b.creation_date,
         b.last_updated_date,
         b.ticket_id,
         b.summary_msg,
         c.target_name,
         DECODE (a.open_status, '1', 'Open', 'Closed')
    FROM mgmt$INCIDENT_TARGET a, mgmt$incidents b, mgmt$target c
   WHERE     a.incident_id = b.incident_id
         AND a.target_guid = b.target_guid
         AND a.target_guid = c.target_guid
         AND LOWER (b.SUMMARY_MSG) LIKE '%filesystem%'
         AND c.target_type = 'host'
         AND a.open_status = 1
ORDER BY b.last_updated_date DESC
Print Friendly, PDF & Email

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.