Show all open incidents related to file system capacity

alter session set nls_date_format='dd/mm/rrrr hh:mi:ss'
 
  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