(all hosts) |
df |
| attribute | host | id | status | text | tlast | tnext | tspan | value |
|---|---|---|---|---|---|---|---|---|
| /fs/d2 | jotunheim.talisman.org | 13306803 | pristine | free MB 445297.0 | 2019-08-04 19:20:00 | 2019-08-04 19:30:00 | 600 | 0.01 |
| /fs/d2 | karazhan.talisman.org | 30420842 | normal | free MB 167255.6 | 2019-10-23 00:17:35 | 2019-10-23 00:27:35 | 600 | 0.63 |
| /fs/d2 | sphinx.talisman.org | 78444255 | normal | free MB 2607942.2 | 2020-12-11 15:19:30 | 2020-12-11 15:29:30 | 600 | 0.34 |
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 = 'df' AND eventslast.attribute = '/fs/d2'