(all hosts) |
swap |
| host | id | status | tlast | tnext | tspan | value |
|---|---|---|---|---|---|---|
| bifrost.talisman.org | 299301414 | pristine | 08:34:41 | 08:44:41 | 600 | 0 |
| grok.talisman.org | 227081 | pristine | 2019-06-23 20:16:50 | 2019-06-23 20:26:50 | 600 | 0 |
| hades.talisman.org | 297614442 | pristine | 2025-10-23 14:18:44 | 2025-10-23 14:28:44 | 600 | 0 |
| jotunheim.talisman.org | 214116484 | pristine | 2023-02-01 09:51:36 | 2023-02-01 10:01:36 | 600 | 0 |
| karazhan.talisman.org | 299301322 | pristine | 08:33:34 | 08:43:34 | 600 | 0 |
| minx.talisman.org | 66726023 | normal | 2020-10-12 22:51:47 | 2020-10-12 23:01:47 | 600 | 0.37 |
| sphinx.talisman.org | 299301374 | pristine | 08:34:11 | 08:44:11 | 600 | 0.01 |
| tanelorn.talisman.org | 214116534 | pristine | 2023-02-01 09:52:00 | 2023-02-01 10:02:00 | 600 | 0 |
| valhalla.talisman.org | 165822189 | pristine | 2022-03-10 01:13:06 | 2022-03-10 01:23:06 | 600 | 0 |
| voodoo.talisman.org | 553455 | pristine | 2019-06-24 23:43:09 | 2019-06-24 23:53:09 | 600 | 0.02 |
| warpgate.talisman.org | 299301588 | pristine | 08:36:29 | 08:46:29 | 600 | 0 |
| yggdrasil-old.talisman.org | 158829806 | pristine | 2022-02-05 17:02:47 | 2022-02-05 17:12:47 | 600 | 0 |
| yggdrasil.talisman.org | 299301299 | pristine | 08:33:20 | 08:43:20 | 600 | 0 |
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 = 'swap'