select * from hosts where status=3;
select hostid, host, name from hosts where status=3;
確認したいテンプレートのhostidが10105の場合
select * from items where hostid=10105
select itemid, name, key_, description from items where hostid=10105
select * from history_uint where itemid=27977;
select to_timestamp(1480575497);
- 無効ホストはhostsテーブルのstatusが1