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) > Report displays data average after setting the function to Max

Report displays data average after setting the function to Max

Created by Adrian Cook, last modified by Caroline Juszczak on Jul 19, 2017

Views: 22 Votes: 0 Revisions: 6

Overview

The Max data is not generated after setting the function option to Max from Average in Report Writer:

 

The SQL query shows that both the average and max queries are the same:

Environment

All products running Orion Platform.

Cause 

A report with a function field that has initially been set to Average cannot be reset to Max.

Resolution

  1. Go to Start > All Programs > SolarWinds Orion > Alerting, Reporting, and Mapping > Report Writer.
  2. Open the report and copy the SQL query.
  3. Create a new Advanced SQL report.
  4. Paste the query in the SQL tab and modify to use MAX instead of AVERAGE.
  5. Save and run the new report.

 

Last modified
19:06, 18 Jul 2017

Tags

Classifications

Public