sphinx.talisman.org |
db |
| attribute | id | status | text | tlast | tnext | tspan | value |
|---|---|---|---|---|---|---|---|
| 332763720 | nominal | PostgreSQL | 11:21:25 | 11:31:25 | 600 | 2 | |
| PostgreSQL | 332763719 | nominal | mole roundcubemail | 11:21:25 | 11:31:25 | 600 | 2 |
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 = 'sphinx.talisman.org'