(all hosts) |
net |
| attribute | host | id | status | tlast | tnext | tspan | value |
|---|---|---|---|---|---|---|---|
| macvtap0/r-bytes | karazhan.talisman.org | 87267296 | pristine | 2021-04-08 08:01:31 | 2021-04-08 08:03:31 | 120 | 236 |
| macvtap0/r-bytes | sphinx.talisman.org | 79388841 | pristine | 2021-03-05 05:42:30 | 2021-03-05 05:44:30 | 120 | 260 |
| macvtap0/r-bytes | tanelorn.talisman.org | 87580367 | pristine | 2021-04-09 22:36:43 | 2021-04-09 22:38:43 | 120 | 164 |
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 = 'macvtap0/r-bytes'