Interface Uptime or Downtime report for last month in percentage.

I want to create a custom report where it shows the interface uptime/downtime in percentage for specific interfaces for last month. Meaning, if I run the report in September, the report should show the data for entire August.

I want to see what was the uptime (in percentage) for particular interface for entire August month.

I am not very familiar with the SQL queries. Can someone please help? Where do you find the table and column names used to retrieve the data from database?

Thanks in advance.

Find more posts tagged with

custom_poller

npm - network performance monitor

report

Comments

daham_bm

Hi,

You can quickly get this report created via data picker.

In the report builder, Add content> custom table> Dynamic Query Builder > Basic Selector > I want to report on > Interface

Add the node caption , Interface caption and the Availability of the interface

In the report builder, you can select the time period as you require.