SELECT
host
FROM
hosts
WHERE
STATUS <> 3 AND
flags <> 2
ORDER BY
name;
SELECT h.host, h.name, i.key_, i.delay, i.history, i.trends, ELT(i.value_type+1,'Double','Str','Log','Uint','Text') type, i.units , ifnull(ap.name,'[Undefined]') application_name, i.name item_name, Replace(Replace( i.description , Char(13), ""),Char(10), "") AS description FROM items i join hosts h on h.hostid = i.hostid left join items_applications ia on i.itemid=ia.itemid left join applications ap on h.hostid=ap.hostid and ia.applicationid=ap.applicationid WHERE h.host in ( SELECT host FROM hosts WHERE STATUS <> 3 AND flags <> 2 ORDER BY name ) AND i.status = 0 AND i.flags <> 1 AND i.flags <> 2 ORDER BY ap.name, i.name, i.key_;
select h.host AS HOST, h.name AS HOST_NAME, i.name AS ITEM_NAME, i.key_ as ITEM_KEY, FROM_UNIXTIME (ELT(i.value_type+1, hy1.clock, hy3.clock, hy2.clock, hy5.clock, hy4.clock)) AS clock , Replace(Replace(ELT(i.value_type+1, hy1.value, hy3.value, hy2.value, hy5.value, hy4.value) , Char(13), ""),Char(10), "") AS value from items i join hosts h on h.hostid = i.hostid left join history hy1 on hy1.itemid = i.itemid and hy1.clock = (select max(hy12.clock) from history hy12 where hy12.itemid = i.itemid) left join history_log hy2 on hy2.itemid = i.itemid and hy2.clock = (select max(hy22.clock) from history_log hy22 where hy22.itemid = i.itemid) left join history_str hy3 on hy3.itemid = i.itemid and hy3.clock = (select max(hy32.clock) from history_str hy32 where hy32.itemid = i.itemid) left join history_text hy4 on hy4.itemid = i.itemid and hy4.clock = (select max(hy42.clock) from history_text hy42 where hy42.itemid = i.itemid) left join history_uint hy5 on hy5.itemid = i.itemid and hy5.clock = (select max(hy52.clock) from history_uint hy52 where hy52.itemid = i.itemid) where h.host in (SELECT host FROM hosts WHERE STATUS <> 3 AND flags <> 2 order by name) and i.status = 0 and i.name like '%' and i.flags <> 1 and i.flags <> 2 and i.key_ like '%';
select h.host AS HOST, h.name AS HOST_NAME, i.name AS ITEM_NAME, i.key_ as ITEM_KEY, FROM_UNIXTIME(ELT(i.value_type+1, hy1.clock, hy3.clock, hy2.clock, hy5.clock, hy4.clock)) AS clock , Replace(Replace( ELT(i.value_type+1, hy1.value, hy3.value, hy2.value, hy5.value, hy4.value) , Char(13), ""),Char(10), "") AS value from items i join hosts h on h.hostid = i.hostid left join history hy1 on hy1.itemid = i.itemid left join history_log hy2 on hy2.itemid = i.itemid left join history_str hy3 on hy3.itemid = i.itemid left join history_text hy4 on hy4.itemid = i.itemid left join history_uint hy5 on hy5.itemid = i.itemid where h.host in (SELECT host FROM hosts WHERE STATUS <> 3 AND flags <> 2 order by name) and i.status = 0 and i.name like '%' and i.key_ like 'system.cpu.load[percpu,avg1]%';
| カテゴリ | 入手元 | 情報区別 | 取得形式 | URL |
|---|---|---|---|---|
| 脆弱性情報 | JPCERT/CC | 注意喚起 | RDF | https://www.jpcert.or.jp/rss/jpcert.rdf |
| 脆弱性関連情報 | RDF | http://jvn.jp/rss/jvn.rdf | ||
| JVN iPedia | JVN iPediaで注目されている脆弱性 | RDF | http://jvndb.jvn.jp/ja/rss/jvndb.rdf | |
| 通信回線故障情報 | NTTCOM | Arcstar Universal One ベストエフォート | RDF | http://support.ntt.com/maintenance/service/rss/242 |
| Group-VPN 光サービス(F) | RDF | http://support.ntt.com/maintenance/service/rss/252 | ||
| Group-VPN 「Bフレッツ」プラン | RDF | http://support.ntt.com/maintenance/service/rss/262 | ||
| Group-Etherサービス | RDF | http://support.ntt.com/maintenance/service/rss/267 | ||
| Group-Etherサービス フレッツ別契約型 | RDF | http://support.ntt.com/maintenance/service/rss/495 | ||
| Group-Ether/e-VLAN接続 | RDF | http://support.ntt.com/maintenance/service/rss/496 | ||
| KDDI | KDDI Wide Area Virtual Switch | RDF | http://www.notice.kddi.com/news/mainte/content/info/k/widearea.xml | |
| KDDI Powered Ethernet | - | 情報なし | ||
| SOFTBANK | - | - | RSS配信なし、（WEBによる閲覧のみ） | |
| NTT東日本 | - | - | 全体周知用のRSS配信はない | |
| NTT西日本 | - | - | http://www.info-construction.ntt-west.co.jp/info-report/ku010/kU010200/ | |
| 携帯電話故障情報 | docomo | 重要なお知らせ（通信障害等） | RDF | https://www.nttdocomo.co.jp/info/rss/network.rdf |
| au | スマートフォン・携帯電話に関するおしらせ | RDF | http://www.notice.kddi.com/news/mainte/content/info/k/au_information.xml | |
| SOFTBANK | - | - | RSS配信なし、（WEBによる閲覧のみ） | |
| Willcom | - | - | RSS配信なし、（WEBによる閲覧のみ） | |
| 災害情報 | 気象庁 | 気象庁防災情報XML | ATOM | 登録制による配信 |
| 日本気象協会 | 地震情報 | RSS | http://feed.tenki.jp/component/static_api/rss/earthquake/recent_entries.xml | |
| サービス故障情報 | AWS(Asia Pacific(Tokyo)) | Amazon CloudWatch | RSS | http://status.aws.amazon.com/rss/cloudwatch-ap-northeast-1.rss |
| Amazon Elastic Compute Cloud | RSS | http://status.aws.amazon.com/rss/ec2-ap-northeast-1.rss | ||
| Amazon Elastic Load Balancing | RSS | http://status.aws.amazon.com/rss/elb-ap-northeast-1.rss | ||
| Amazon Redshift | RSS | http://status.aws.amazon.com/rss/redshift-ap-northeast-1.rss | ||
| Amazon Relational Database Service | RSS | http://status.aws.amazon.com/rss/rds-ap-northeast-1.rss | ||
| Amazon Route 53 | RSS | http://status.aws.amazon.com/rss/route53.rss | ||
| Amazon Simple Storage Service | RSS | http://status.aws.amazon.com/rss/s3-ap-northeast-1.rss | ||
| Amazon SimpleDB | RSS | http://status.aws.amazon.com/rss/simpledb-ap-northeast-1.rss | ||
| Amazon Virtual Private Cloud | RSS | http://status.aws.amazon.com/rss/vpc-ap-northeast-1.rss | ||
| AWS Direct Connect | RSS | http://status.aws.amazon.com/rss/directconnect-ap-northeast-1.rss | ||
| AWS Storage Gateway | RSS | http://status.aws.amazon.com/rss/storagegateway-ap-northeast-1.rss | ||
| Azure(Region:Japan) | Compute_East | RSS | http://www.windowsazurestatus.com/Rss/WACEJ | |
| Compute_West | RSS | http://www.windowsazurestatus.com/Rss/WACWJ | ||
| Compute (Service Management)_East | RSS | http://www.windowsazurestatus.com/Rss/CSMNEJ | ||
| Compute (Service Management)_West | RSS | http://www.windowsazurestatus.com/Rss/CSMNWJ | ||
| Management Portal | RSS | http://www.windowsazurestatus.com/Rss/WAPortalWW | ||
| Networks_East | RSS | http://www.windowsazurestatus.com/Rss/NETEJ | ||
| Networks_West | RSS | http://www.windowsazurestatus.com/Rss/NETWJ | ||
| Service Management | RSS | http://www.windowsazurestatus.com/Rss/WASvcMgmtWW | ||
| SQL Databases_East | RSS | http://www.windowsazurestatus.com/Rss/SAEJ | ||
| SQL Databases_West | RSS | http://www.windowsazurestatus.com/Rss/SAWJ | ||
| Storage_East | RSS | http://www.windowsazurestatus.com/Rss/WASEJ | ||
| Storage_West | RSS | http://www.windowsazurestatus.com/Rss/WASWJ | ||
| windowsazure.com | RSS | http://www.windowsazurestatus.com/Rss/WAProductWW | ||
| NTTCOMクラウド | Biz ホスティング Enterprise Cloud | RSS | http://support.ntt.com/maintenance/service/206 | |
| Twilio Voice システム稼働状況（米国） | Account Portal | RSS | http://status.twilio.com/rss?services=account-portal | |
| REST API | RSS | http://status.twilio.com/rss?services=rest-api | ||
| Voice - Incoming Phone Calls | RSS | http://status.twilio.com/rss?services=incoming-phone-calls | ||
| Voice - Incoming SIP Calls | RSS | http://status.twilio.com/rss?services=incoming-sip-calls | ||
| Voice - Outgoing Phone Calls | RSS | http://status.twilio.com/rss?services=outgoing-phone-calls | ||
| Voice - Outgoing SIP Calls | RSS | http://status.twilio.com/rss?services=outgoing-sip-calls | ||
| Voice - Queues | RSS | http://status.twilio.com/rss?services=voice---queues |
