Submit a ticketCall us

Get a crash course on Network Monitoring delivered right to your inbox
This free 7-day email course provides a primer to the philosophy, theory, and fundamental concepts involved in IT monitoring. Lessons will explain not only how to perform various monitoring tasks, but why and when you should use them. Sign up 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: 17 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