(all hosts) |
net |
| attribute | host | id | status | tlast | tnext | tspan | value |
|---|---|---|---|---|---|---|---|
| eth1/r-bytes | voodoo.talisman.org | 124780 | pristine | 2019-06-23 11:02:04 | 2019-06-23 11:04:04 | 120 | 444 |
| eth1/r-bytes | warpgate.talisman.org | 306403045 | nominal | 15:44:14 | 15:46:14 | 120 | 590284 |
| eth1/r-bytes | yggdrasil.talisman.org | 306403117 | pristine | 15:44:51 | 15:46:51 | 120 | 0 |
Query was:
SELECT eventslast.id, hosts.name as host, eventslast.attribute, eventslast.value, eventslast.valtext, eventslast.text, eventslast.tspan, extract(epoch from eventslast.t) as tlast, extract(epoch from eventslast.t)+eventslast.tspan as tnext,statuses.name as status FROM eventslast, hosts, monitors, statuses WHERE eventslast.host = hosts.id AND eventslast.monitor = monitors.id AND eventslast.status = statuses.id AND monitors.name = 'net' AND eventslast.attribute = 'eth1/r-bytes'