Project

General

Profile

Idea #4622

Add a report for 'Devices exceeding MPCT'

Added by Randy Reitz about 6 years ago. Updated about 5 years ago.

Status:
Closed
Priority:
Normal
Start date:
09/06/2013
Due date:
% Done:

100%

Estimated time:
5.00 h
Spent time:
Duration:

Description

Something like:

select dn.fqdn, nd.last_poll_complete_timestamp from network_devices nd, device_names dn where dn.id=nd.device_name_id and nd.polling_disabled='F' and last_poll_complete_timestamp < now() - interval '15 minutes' order by nd.last_poll_complete_timestamp desc;

(but actually using MPCT).

History

#1 Updated by Lauri Carpenter about 5 years ago

  • Status changed from New to Closed
  • Assignee set to Lauri Carpenter
  • % Done changed from 0 to 100
  • Estimated time set to 5.00 h


Also available in: Atom PDF