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) > Generate a monthly average utilization report for peak business hours

Generate a monthly average utilization report for peak business hours

Table of contents

Overview

This article describes how to generate a monthly average utilization report for all devices on a network that only shows data for peak business hours, such as 8:00 AM to 7:00 PM.

Environment

All NPM versions

Steps

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. 
  5. Clear all other fields except Node Name and Interface Name.
  6. Click Browse and then click Add a new field.
  7. Click the Field asterisk (*), and then select Historical Interface Traffic > Transmit+Receive Data Combined > Circuit Utilization (Avg of Recv,Xmit).
  8. On the Filter Results tab, click Browse and then select Add a new elementary condition.
  9. Click the first asterisk (*), and then select Date/Time (Traffic Filtering Only) > Time of Day (24 hour format).
  10. Click is equal to, and then select greater or equal.
  11. Click the second asterisk (*), and then enter the start time of your peak business hours in 24-hour hh:mm format (For example, 08:00).
  12. Click Browse and then select Add a new elementary condition.
  13. Click the first asterisk (*), and then select Date/Time (Traffic Filtering Only) > Time of Day (24 hour format).
  14. Click is equal to, and then select less or equal.
  15. Click the second asterisk (*), and then enter the end time of your peak business hours in 24-hour hh:mm format (For example, 19:00).
  16. 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.

 

Create a report of the average utilization of your entire network:

  1. In the Report Writer toolbar, click Design.
  2. Click Report > Show SQL to open the SQL tab and display the report query.
  3. Copy the entire query.
  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 .
  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
22:23, 22 Jun 2016

Tags

Classifications

Public