(all hosts) |
db |
| attribute | host | id | status | text | tlast | tnext | tspan | value |
|---|---|---|---|---|---|---|---|---|
| PostgreSQL | karazhan.talisman.org | 306402767 | nominal | mole roundcubemail | 15:41:34 | 15:51:34 | 600 | 2 |
| PostgreSQL | minx.talisman.org | 66725974 | pristine | mole | 2020-10-12 22:51:22 | 2020-10-12 23:01:22 | 600 | 1 |
| PostgreSQL | sphinx.talisman.org | 306403090 | nominal | mole roundcubemail | 15:44:36 | 15:54:36 | 600 | 2 |
| PostgreSQL | yggdrasil.talisman.org | 221413569 | pristine | mole | 2023-04-14 06:56:10 | 2023-04-14 07:06:10 | 600 | 1 |
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 = 'db' AND eventslast.attribute = 'PostgreSQL'