yggdrasil.talisman.org |
db |
| attribute | id | status | text | tlast | tnext | tspan | value |
|---|---|---|---|---|---|---|---|
| 299302198 | mon-na | 08:43:45 | 08:53:45 | 600 | |||
| PostgreSQL | 221413569 | pristine | mole | 2023-04-14 06:56:10 | 2023-04-14 07:06:10 | 600 | 1 |
Query was:
SELECT eventslast.id, 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 hosts.name = 'yggdrasil.talisman.org'