All pastes #587980 Raw Edit

Mine

public text v1 · immutable
#587980 ·published 2007-06-25 08:38 UTC
rendered paste body
Service is down

 select * from outages where serviceid=837 AND nodeid=199;
 outageid | svclosteventid | svcregainedeventid | nodeid |    ipaddr     | serviceid |    iflostservice    |  ifregainedservice  | suppresstime | suppressedby | ifserviceid
----------+----------------+--------------------+--------+---------------+-----------+---------------------+---------------------+--------------+--------------+-------------
     1306 |           4172 |                    |    199 | 192.168.2.251 |       837 | 2007-06-21 13:21:35 |     |              |              |        2232
      980 |           3675 |               3917 |    199 | 192.168.2.251 |       837 | 2007-06-18 10:23:59 | 2007-06-19 13:08:23 |              |              |        2232
(2 rows)


when service is upp


opennms=# select * from outages where serviceid=837 AND nodeid=199;
 outageid | svclosteventid | svcregainedeventid | nodeid |    ipaddr     | serviceid |    iflostservice    |  ifregainedservice  | suppresstime | suppressedby | ifserviceid
----------+----------------+--------------------+--------+---------------+-----------+---------------------+---------------------+--------------+--------------+-------------
     1306 |           4172 |               4670 |    199 | 192.168.2.251 |       837 | 2007-06-21 13:21:35 | 2007-06-25 13:29:22 |              |              |        2232
      980 |           3675 |               3917 |    199 | 192.168.2.251 |       837 | 2007-06-18 10:23:59 | 2007-06-19 13:08:23 |              |              |        2232
(2 rows)