https://znil.net/index.php?action=history&feed=atom&title=Zabbix_fertige_Datenbank_abfragenZabbix fertige Datenbank abfragen - Versionsgeschichte2026-05-07T22:54:47ZVersionsgeschichte dieser Seite in znilwikiMediaWiki 1.43.8https://znil.net/index.php?title=Zabbix_fertige_Datenbank_abfragen&diff=10338&oldid=prevBLinz: /* Events eines Host */2017-12-12T13:19:37Z<p><span class="autocomment">Events eines Host</span></p>
<p><b>Neue Seite</b></p><div>==Events eines Host==<br />
Die Events selbst:<br />
SELECT * FROM events JOIN triggers ON events.objectid = triggers.triggerid JOIN functions ON functions.triggerid = triggers.triggerid JOIN items ON items.itemid = functions.itemid JOIN hosts ON items.hostid = hosts.hostid WHERE events.source = 0 AND LOWER(hosts.host) like 'lin-eu-dmstst04' AND events.clock>=unix_timestamp('2017-12-01 00:00:00') AND events.clock<=unix_timestamp('2018-12-12 16:00:00') ORDER BY events.clock DESC;<br />
<br />
Nur die Anzahl:<br />
SELECT COUNT(*) FROM events JOIN triggers ON events.objectid = triggers.triggerid JOIN functions ON functions.triggerid = triggers.triggerid JOIN items ON items.itemid = functions.itemid JOIN hosts ON items.hostid = hosts.hostid WHERE events.source = 0 AND LOWER(hosts.host) like 'lin-eu-dmstst04' AND events.clock>=unix_timestamp('2017-12-01 00:00:00') AND events.clock<=unix_timestamp('2018-12-12 16:00:00') ORDER BY events.clock DESC;<br />
<br />
Als Bash-Abfrage, ohne Header, nur die nackte Zahl:<br />
mysql -sN -uzabbix -pzabbix zabbix -e "SELECT COUNT(*) FROM events JOIN triggers ON events.objectid = triggers.triggerid JOIN functions ON functions.triggerid = triggers.triggerid JOIN items ON items.itemid = functions.itemid JOIN hosts ON items.hostid = hosts.hostid WHERE events.source = 0 AND LOWER(hosts.host) like 'lin-eu-dmstst04' AND events.clock>=unix_timestamp('2017-12-01 00:00:00') AND events.clock<=unix_timestamp('2018-12-12 16:00:00') ORDER BY events.clock DESC;"</div>BLinz