Submit a ticketCall us

Webinar: Web Help Desk for HR, Facilities and Accounting Departments
This webinar will focus on use cases for HR, Facilities and Accounting.

Having a unified ticketing and asset management system for all the departments in your company can provide end-users with a seamless experience and make things easier for your IT team. Yet, with different business tasks and objectives, many departments don’t fully understand the capabilities of Web Help Desk and how the software can be customized for effective use in their departments.
Register Now.

Home > Success Center > Network Performance Monitor (NPM) > Create a Monthly Average Utilization report for all devices

Create a Monthly Average Utilization report for all devices

Table of contents

Updated March 11th, 2016

Overview

This article provides steps to generate a monthly average utilization report for all devices on a network that only shows data for peak business hours, for example, 8:00 AM to 7:00 PM. Using Report Writer, first create a monthly average utilization report for your designated peak business hours, and then modify your generated report to summarize all usage into one network-wide value, see Generate a monthly average utilization report for peak business hours for more information. 

Environment

All NPM versions

Steps

 

To create a monthly average utilization report for designated hours:

  1. Click Start > All Programs > SolarWinds Orion > Report Writer.
  2. In the left pane, click Historical Traffic Reports > Total Bytes Transferred by Interface - Last Month.
  3. On the General tab, edit the Report Title and the Description as appropriate.
  4. On the Select Fields tab, check Select the following fields, and then clear all other fields except Node Name and Interface Name.
  5. Click Browse (...), and then click Add a new field.
  6. Click the Field asterisk (*), and then select Historical Interface Traffic > Transmit+Receive Data Combined > Circuit Utilization (Avg     of Recv,Xmit).
  7. On the Filter Results tab, click Browse (...), and then select Add a new elementary condition.
  8. Click the first asterisk (*), and then select Date/Time (Traffic Filtering Only) > Time of Day (24 hour format).
  9. Click is equal to, and then select greater or equal.
  10. Click the second asterisk (*), and then enter the start time of your peak business hours in 24-hour hh:mm format (e.g. 08:00).
  11. Click Browse (...), and then select Add a new elementary condition.
  12. Click the first asterisk (*), and then select Date/Time (Traffic Filtering Only) > Time of Day (24 hour format).
  13. Click is equal to, and then select less or equal.
  14. Click the second asterisk (*), and then enter the end time of your peak business hours in 24-hour hh:mm format (e.g. 19:00).
  15. Click Preview on the right of the Report Designer pane.

The report currently displays the average circuit utilization of each interface for the month. Further summarization is required to create a single line report of average utilization of the entire network, as shown in the following steps.

 

To create a report of the average utilization of your entire network:

  1. Click Design in the Report Writer toolbar.
  2. Click Report > Show SQL to open the SQL tab and display the report query.
  3. Copy the entire query (select all and then Ctrl + C).
  4. Click File > New Report.
  5. Select Advanced SQL, and then click OK.
  6. On the General tab, edit the Report Title and the Description as appropriate.
  7. On the SQL tab, paste the SQL query from your first report into the empty field (Ctrl + V).
  8. Complete the following edits on the SQL query.
    1. In the GROUP BY clause, remove Nodes.Caption and Interfaces.InterfaceName.
    2. Delete the ORDER BY clause.
    3. Edit the SELECT clause to read as "SELECT 'Average % Utilization of all interfaces' AS AVERAGE_of_CircuitUtil_AvgRecvXmit,".

 

 

Last modified
15:16, 14 Feb 2017

Tags

Classifications

Public