Advertisement
Guest User

Untitled

a guest
May 26th, 2015
233
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.98 KB | None | 0 0
  1. select (CASE WHEN end_time < NOW() - interval '1 hour' THEN 'unresponsive'
  2. WHEN noop = true THEN 'noop'
  3. ELSE status
  4. END) as latest_report_status,
  5. certname,
  6. end_time from
  7. (SELECT end_time,status,reports.certname,noop from certnames inner join reports on certnames.latest_report_id = reports.id inner join report_statuses on report_statuses.id=reports.status_id) foo;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement