(all hosts) |
net |
| attribute | host | id | status | tlast | tnext | tspan | value |
|---|---|---|---|---|---|---|---|
| enp1s0/t-bytes | jotunheim.talisman.org | 13306966 | pristine | 2019-08-04 19:20:30 | 2019-08-04 19:22:30 | 120 | 403 |
| enp1s0/t-bytes | karazhan.talisman.org | 78444582 | nominal | 2020-12-11 15:22:27 | 2020-12-11 15:24:27 | 120 | 5468 |
| enp1s0/t-bytes | yggdrasil.talisman.org | 41844362 | nominal | 2020-05-27 07:55:01 | 2020-05-27 07:57:01 | 120 | 3188 |
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 = 'enp1s0/t-bytes'