4 Replies Latest reply on Feb 13, 2018 6:18 AM by rajasekar

    Report Writer report to display down nodes (or interface) AND event time


      I would like to create a report that displays current down nodes/interfaces with a column that also displays the latest event time stamp. The down node reports do not contain event options. The event reports pull event times for a period of time (all events in the time period - which means multiple event time for a node that has gone up and down in the period) not current status for down nodes only.


      I currently have a custom report that our helpdesk uses to watch all down devices. The current report does not have a "timestamp" next to the down node, therefore, the helpdesk is not able to determine what is new vs. old down events.


      I assume there is a way to use a custom SQL report to accomplish or (hopefully) a out-of-box report showing current down nodes / interfaces and a timestamp for when the event last occured.