{"id":408,"date":"2021-02-26T08:19:43","date_gmt":"2021-02-25T22:19:43","guid":{"rendered":"http:\/\/www.mrmarkyoung.com\/oracle\/?p=408"},"modified":"2021-02-26T08:19:43","modified_gmt":"2021-02-25T22:19:43","slug":"show-open-incidents-related-to-filesystem-capacity-enterprise-manager","status":"publish","type":"post","link":"http:\/\/www.mrmarkyoung.com\/oracle\/2021\/02\/26\/show-open-incidents-related-to-filesystem-capacity-enterprise-manager\/","title":{"rendered":"Show open incidents related to filesystem capacity Enterprise Manager"},"content":{"rendered":"\n<pre class=\"wp-block-code\"><code>  SELECT a.incident_id,\r\n         b.creation_date,\r\n         b.last_updated_date,\r\n         b.ticket_id,\r\n         b.summary_msg,\r\n         c.target_name,\r\n         DECODE (a.open_status, '1', 'Open', 'Closed')\r\n    FROM mgmt$INCIDENT_TARGET a, mgmt$incidents b, mgmt$target c\r\n   WHERE     a.incident_id = b.incident_id\r\n         AND a.target_guid = b.target_guid\r\n         AND a.target_guid = c.target_guid\r\n         AND LOWER (b.SUMMARY_MSG) LIKE '%filesystem%'\r\n         AND c.target_type = 'host'\r\n         AND a.open_status = 1\r\nORDER BY b.last_updated_date DESC<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[],"class_list":["post-408","post","type-post","status-publish","format-standard","hentry","category-enterprise-manager"],"_links":{"self":[{"href":"http:\/\/www.mrmarkyoung.com\/oracle\/wp-json\/wp\/v2\/posts\/408","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.mrmarkyoung.com\/oracle\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.mrmarkyoung.com\/oracle\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.mrmarkyoung.com\/oracle\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.mrmarkyoung.com\/oracle\/wp-json\/wp\/v2\/comments?post=408"}],"version-history":[{"count":1,"href":"http:\/\/www.mrmarkyoung.com\/oracle\/wp-json\/wp\/v2\/posts\/408\/revisions"}],"predecessor-version":[{"id":409,"href":"http:\/\/www.mrmarkyoung.com\/oracle\/wp-json\/wp\/v2\/posts\/408\/revisions\/409"}],"wp:attachment":[{"href":"http:\/\/www.mrmarkyoung.com\/oracle\/wp-json\/wp\/v2\/media?parent=408"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.mrmarkyoung.com\/oracle\/wp-json\/wp\/v2\/categories?post=408"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.mrmarkyoung.com\/oracle\/wp-json\/wp\/v2\/tags?post=408"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}