(all hosts) |
df |
| attribute | host | id | status | text | tlast | tnext | tspan | value |
|---|---|---|---|---|---|---|---|---|
| / | bifrost.talisman.org | 299321359 | nominal | free MB 7886.6 | 12:24:52 | 12:34:52 | 600 | 0.11 |
| / | grok.talisman.org | 227194 | normal | free MB 8337.9 | 2019-06-23 20:17:20 | 2019-06-23 20:27:20 | 600 | 0.54 |
| / | hades.talisman.org | 297614089 | pristine | free MB 9278.9 | 2025-10-23 14:14:59 | 2025-10-23 14:24:59 | 600 | 0.02 |
| / | jotunheim.talisman.org | 214116507 | pristine | free MB 9373.8 | 2023-02-01 09:51:41 | 2023-02-01 10:01:41 | 600 | 0.02 |
| / | karazhan.talisman.org | 299321702 | normal | free MB 17483.1 | 12:29:00 | 12:39:00 | 600 | 0.54 |
| / | minx.talisman.org | 66725966 | normal | free MB 6728.7 | 2020-10-12 22:51:22 | 2020-10-12 23:01:22 | 600 | 0.26 |
| / | sphinx.talisman.org | 299321558 | normal | free MB 4540.5 | 12:27:14 | 12:37:14 | 600 | 0.52 |
| / | tanelorn.talisman.org | 214116716 | nominal | free MB 8115.4 | 2023-02-01 09:53:15 | 2023-02-01 10:03:15 | 600 | 0.15 |
| / | valhalla.talisman.org | 165822316 | pristine | free MB 9374.3 | 2022-03-10 01:14:06 | 2022-03-10 01:24:06 | 600 | 0.02 |
| / | voodoo.talisman.org | 553507 | nominal | free MB 63425.6 | 2019-06-24 23:43:20 | 2019-06-24 23:53:20 | 600 | 0.11 |
| / | warpgate.talisman.org | 299321513 | nominal | free MB 7758.0 | 12:26:56 | 12:36:56 | 600 | 0.12 |
| / | yggdrasil-old.talisman.org | 158829952 | normal | free MB 239576.5 | 2022-02-05 17:03:37 | 2022-02-05 17:13:37 | 600 | 0.4 |
| / | yggdrasil.talisman.org | 299321682 | nominal | free MB 262336.0 | 12:28:46 | 12:38:46 | 600 | 0.13 |
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 = '/'