{"id":611,"date":"2019-02-28T07:03:37","date_gmt":"2019-02-28T07:03:37","guid":{"rendered":"https:\/\/monyog.jp\/?p=611"},"modified":"2019-03-07T02:14:33","modified_gmt":"2019-03-07T02:14:33","slug":"%e6%96%b0%e3%81%97%e3%81%84cso%e3%81%a8csc","status":"publish","type":"post","link":"https:\/\/smart-style.main.jp\/monyogjp\/static\/document\/611\/index.html","title":{"rendered":"\u65b0\u3057\u3044CSO\u3068CSC"},"content":{"rendered":"<h2>CSO\u306f\u3001\u4f55\u3067\u4f5c\u6210\u3057\u307e\u3059\u304b\uff1f<\/h2>\n<p>\u30c9\u30ed\u30c3\u30d7\u30c0\u30a6\u30f3\u304b\u3089Manage CSO\u3092\u9078\u629e\u3057\u307e\u3059\u3002\u3053\u308c\u3067\u3001\u4ee5\u4e0b\u306e\u8a73\u7d30\u60c5\u5831\u3092\u8f09\u305b\u305f\u30da\u30fc\u30b8\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002<\/p>\n<ul>\n<li><strong>SQL\uff1a<\/strong>\u7d50\u679c\u30bb\u30c3\u30c8\u3092\u8fd4\u3059SQL\u3092\u5b9a\u7fa9\u3057\u305f\u30e6\u30fc\u30b6\u30fc\u3002<\/li>\n<li><strong>Key Columns\uff08\u30ad\u30fc\u5217\uff09\uff1a<\/strong>CSO\u306f\u3001\u4e00\u610f\u306e\u884c\u304c\u3042\u308b\u7d50\u679c\u30bb\u30c3\u30c8\u3092\u51e6\u7406\u3057\u307e\u3059\u30021\u5217\u4ee5\u4e0a\u306e\u7d50\u679c\u30bb\u30c3\u30c8\u3092\u7d44\u307f\u5408\u308f\u305b\u305f\u5217\u304c\u3001\u7d50\u679c\u30bb\u30c3\u30c8\u306e\u4e00\u610f\u306e\u884c\u3092\u8b58\u5225\u3057\u3066\u3044\u308b\u9650\u308a\u3001\u30ad\u30fc\u5217\u3068\u3057\u3066\u4f7f\u7528\u3067\u304d\u307e\u3059\u3002<\/li>\n<li><strong>Server(s)\uff08\u30b5\u30fc\u30d0\u30fc\uff09:<\/strong> \u53ce\u96c6\u9593\u9694\u3054\u3068\u306b\u3053\u306eSQL\u3092\u7167\u4f1a\u3059\u308b\u5bfe\u8c61\u3068\u306a\u308b\u30b5\u30fc\u30d0\u30fc\u306e\u30b3\u30f3\u30de\u533a\u5207\u308a\u540d\u3002<\/li>\n<li><strong>Data Collection Interval\uff08\u30c7\u30fc\u30bf\u53ce\u96c6\u9593\u9694\uff09:<\/strong> \u3053\u306eSQL\u3092\u5b9a\u671f\u7684\u306b\u7167\u4f1a\u3059\u308b\u9593\u9694\u3002\u30c7\u30d5\u30a9\u30eb\u30c8\u5024\u3067\u3042\u308b5\u5206\u3092\u63a8\u5968\u3057\u307e\u3059\u3002<\/li>\n<li><strong>Purging Interval\uff08\u30d1\u30fc\u30b8\u9593\u9694\uff09:<\/strong> \u30c7\u30fc\u30bf\u3092\u4fdd\u6301\u3059\u308b\u6642\u9593\u3067\u3059\u30027\u65e5\u9593\u3092\u63a8\u5968\u3057\u307e\u3059\u3002<\/li>\n<\/ul>\n<p><img loading=\"lazy\" class=\"alignnone size-full wp-image-613\" src=\"https:\/\/monyog.jp\/wp-content\/uploads\/2019\/02\/37-1.png\" alt=\"\" width=\"576\" height=\"615\" srcset=\"https:\/\/smart-style.main.jp\/monyogjp\/static\/wp-content\/uploads\/2019\/02\/37-1.png 576w, https:\/\/smart-style.main.jp\/monyogjp\/static\/wp-content\/uploads\/2019\/02\/37-1-281x300.png 281w\" sizes=\"(max-width: 576px) 100vw, 576px\" \/><\/p>\n<h2>\u305d\u306eCSC\u306e\u4f5c\u6210\uff1a<\/h2>\n<p>\u4ed6\u306e\u30e2\u30cb\u30bf\u30fc\u3068\u540c\u69d8\u306bCSC\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002\u30e2\u30cb\u30bf\u30fc\u30da\u30fc\u30b8\u306b\u79fb\u52d5\u3057\u3001\u30c9\u30ed\u30c3\u30d7\u30c0\u30a6\u30f3\u304b\u3089\u2018Add new monitor\uff08\u65b0\u3057\u3044\u30e2\u30cb\u30bf\u30fc\u3092\u8ffd\u52a0\uff09\u2019\u3092\u9078\u629e\u3057\u307e\u3059\u3002<\/p>\n<ul>\n<li>\u8ffd\u52a0\u3059\u308b\u30ab\u30a6\u30f3\u30bf\u30fc\u306e\u540d\u524d\u3092\u5165\u529b\u3057\u307e\u3059\u3002<\/li>\n<li>\u3053\u306e\u30ab\u30a6\u30f3\u30bf\u30fc\u3092\u8ffd\u52a0\u3059\u308b\u30b0\u30eb\u30fc\u30d7\u306e\u540d\u524d\u3092\u5165\u529b\u3057\u307e\u3059\u3002<\/li>\n<li>\u30ab\u30b9\u30bf\u30e0SQL\u3068\u3057\u3066\u30ab\u30a6\u30f3\u30bf\u30fc\u306e\u30bf\u30a4\u30d7\u3092\u9078\u629e\u3057\u307e\u3059\u3002<\/li>\n<li><strong>Formula\uff08\u5f0f\uff09\uff1a<\/strong>\u3053\u306e\u30ab\u30a6\u30f3\u30bf\u30fc\u306e\u5024\u3092\u8a08\u7b97\u3059\u308b\u306e\u306b\u5fc5\u8981\u306aMySQL\u30b5\u30fc\u30d0\u30fc\u30d1\u30e9\u30e1\u30fc\u30bf\u30fc\u3067\u3059\u3002<\/li>\n<li><strong>Value\uff08\u5024\uff09\uff1a<\/strong>\u5024\u3092\u8a08\u7b97\u3059\u308b\u95a2\u6570\u3092\u5b9a\u7fa9\u3057\u307e\u3059\u3002\u4ee5\u4e0b\u306b\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u3092\u793a\u3057\u307e\u3059\u3002\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">function() {\r\n   var sqlObject = MONyog.UserObject('&lt;Name of your Custom SQL Object&gt;');\r\n   if (!sqlObject || !sqlObject.isEnabled() || !MONyog.MySQL.Custom.Available)\r\n      return '(n\/a)';\r\n   \/* You will have to call select here to fetch the resultset. *\/\r\n   var resultSet = sqlObject.select();\r\n   var results = ''; \/* results holds the resultset in the form of array of row(s).*\/\r\n   \/*Get column(s) for each row from the result set *\/\r\n   for (i in resultSet) {\r\n      if (resultSet.length &gt; 0)\r\n         results += '\r\n';\r\n      results += resultSet[i].&lt;Column name in resultset&gt; +\r\n         '.' + resultSet[i].&lt;Column name in resultset&gt;;\r\n      }\r\n   if (results.length == 0)\r\n         results = 'None';\r\n   return results;\r\n}\r\n<\/pre>\n<\/li>\n<li><strong>Description\uff1a<\/strong>\u30e2\u30cb\u30bf\u30fc\uff0f\u30a2\u30c9\u30d0\u30a4\u30b6\u30fc\u306e\u8aac\u660e\u3002<\/li>\n<li><strong>Advice Text\uff1a<\/strong>\u8ffd\u52a0\u3055\u308c\u308b\u30e2\u30cb\u30bf\u30fc\uff0f\u30a2\u30c9\u30d0\u30a4\u30b6\u30fc\u3078\u306e\u30a2\u30c9\u30d0\u30a4\u30b9\u30c6\u30ad\u30b9\u30c8<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>CSO\u306f\u3001\u4f55\u3067\u4f5c\u6210\u3057\u307e\u3059\u304b\uff1f \u30c9\u30ed\u30c3\u30d7\u30c0\u30a6\u30f3\u304b\u3089Manage CSO&#8230; <\/p>\n<div class=\"readmore\"><a href=\"https:\/\/smart-style.main.jp\/monyogjp\/static\/document\/611\/index.html\">Read more<\/a><\/div>\n","protected":false},"author":2,"featured_media":893,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[3,8,11],"tags":[],"_links":{"self":[{"href":"https:\/\/smart-style.main.jp\/monyogjp\/static\/wp-json\/wp\/v2\/posts\/611"}],"collection":[{"href":"https:\/\/smart-style.main.jp\/monyogjp\/static\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/smart-style.main.jp\/monyogjp\/static\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/smart-style.main.jp\/monyogjp\/static\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/smart-style.main.jp\/monyogjp\/static\/wp-json\/wp\/v2\/comments?post=611"}],"version-history":[{"count":0,"href":"https:\/\/smart-style.main.jp\/monyogjp\/static\/wp-json\/wp\/v2\/posts\/611\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/smart-style.main.jp\/monyogjp\/static\/wp-json\/wp\/v2\/media\/893"}],"wp:attachment":[{"href":"https:\/\/smart-style.main.jp\/monyogjp\/static\/wp-json\/wp\/v2\/media?parent=611"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/smart-style.main.jp\/monyogjp\/static\/wp-json\/wp\/v2\/categories?post=611"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/smart-style.main.jp\/monyogjp\/static\/wp-json\/wp\/v2\/tags?post=611"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}