{"id":70,"date":"2017-08-13T22:52:00","date_gmt":"2017-08-13T22:52:00","guid":{"rendered":"http:\/\/www.mrmarkyoung.com\/oracle\/?p=70"},"modified":"2017-08-13T22:52:00","modified_gmt":"2017-08-13T22:52:00","slug":"show-all-open-incidents-related-to-file-system-capacity","status":"publish","type":"post","link":"http:\/\/www.mrmarkyoung.com\/oracle\/2017\/08\/13\/show-all-open-incidents-related-to-file-system-capacity\/","title":{"rendered":"Show all open incidents related to file system capacity"},"content":{"rendered":"\n<pre class=\"lang:default decode:true \" >alter session set nls_date_format='dd\/mm\/rrrr hh:mi:ss'\r\n \r\n  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<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>alter session set nls_date_format=&#8217;dd\/mm\/rrrr hh:mi:ss&#8217; SELECT a.incident_id, b.creation_date, b.last_updated_date, b.ticket_id, b.summary_msg, c.target_name, DECODE (a.open_status, &#8216;1&#8217;, &#8216;Open&#8217;, &#8216;Closed&#8217;) 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 &#8216;%filesystem%&#8217; AND c.target_type = &#8216;host&#8217; AND a.open_status = 1 ORDER BY b.last_updated_date DESC<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[13],"class_list":["post-70","post","type-post","status-publish","format-standard","hentry","category-enterprise-manager","tag-capacity"],"_links":{"self":[{"href":"http:\/\/www.mrmarkyoung.com\/oracle\/wp-json\/wp\/v2\/posts\/70","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=70"}],"version-history":[{"count":1,"href":"http:\/\/www.mrmarkyoung.com\/oracle\/wp-json\/wp\/v2\/posts\/70\/revisions"}],"predecessor-version":[{"id":71,"href":"http:\/\/www.mrmarkyoung.com\/oracle\/wp-json\/wp\/v2\/posts\/70\/revisions\/71"}],"wp:attachment":[{"href":"http:\/\/www.mrmarkyoung.com\/oracle\/wp-json\/wp\/v2\/media?parent=70"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.mrmarkyoung.com\/oracle\/wp-json\/wp\/v2\/categories?post=70"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.mrmarkyoung.com\/oracle\/wp-json\/wp\/v2\/tags?post=70"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}