(all hosts) |
df |
| attribute | host | id | status | text | tlast | tnext | tspan | value |
|---|---|---|---|---|---|---|---|---|
| /home | bifrost.talisman.org | 299319625 | pristine | free MB 35437.0 | 12:04:52 | 12:14:52 | 600 | 0.01 |
| /home | grok.talisman.org | 227199 | normal | free MB 20321.5 | 2019-06-23 20:17:20 | 2019-06-23 20:27:20 | 600 | 0.92 |
| /home | hades.talisman.org | 78444569 | pristine | free MB 91037.4 | 2020-12-11 15:22:20 | 2020-12-11 15:32:20 | 600 | 0.01 |
| /home | karazhan.talisman.org | 299319543 | nominal | free MB 84748.3 | 12:04:00 | 12:14:00 | 600 | 0.12 |
| /home | tanelorn.talisman.org | 131905599 | nominal | free MB 85551.1 | 2021-10-11 13:13:51 | 2021-10-11 13:23:51 | 600 | 0.11 |
| /home | warpgate.talisman.org | 299319791 | pristine | free MB 35437.2 | 12:06:56 | 12:16:56 | 600 | 0.01 |
| /home | yggdrasil-old.talisman.org | 1708010 | pristine | free MB 8953.2 | 2019-06-29 02:13:37 | 2019-06-29 02:23:37 | 600 | 0.01 |
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 = '/home'