Submit a ticketCall us

Training ClassSign up for Network Performance Monitor (NPM) and Scalability instructor-led classes

Attend our instructor-led classes, provided by SolarWinds® Academy, to discuss the more advanced monitoring mechanisms available in NPM as well as how to tune your equipment to optimize its polling capabilities. NPM classes offered:
NPM Custom Monitoring and Polling
Orion Platform Scalability

Reserve your seat.

Home > Success Center > Network Performance Monitor (NPM) > NPM - Knowledgebase Articles > Data is not available for custom SQL or SWQL charts after upgrading to NPM 12

Data is not available for custom SQL or SWQL charts after upgrading to NPM 12

Updated December 10, 2018

Overview

This article addresses an issue where your custom reports do not return data after upgrading to NPM 12.0.
When editing the report, an error related to data grouping is displayed. The chart does not return any data when data grouping for values is set.

Environment

  • NPM 12.0

Cause 

The behavior of the Data Grouping option responsible for customizing group data into a chart series changed in NPM 12.0.

In earlier NPM versions, you could display a chart per object where you had a SQL or SWQL query in the data source that returned data for several objects. You had to specify the column name to group the chart data by, such as NodeID. and to group the chart data by NoteID, you set the legend to Node Name and selected the Caption column.

To do this in NPM 12.0, you need to specify the grouping when creating a report with a custom chart widget and SQL data source.

Resolution

  1. Add a dummy column to return the same value for all rows.
  2. Select the column in the Data Grouping option.

See Add content to a web-based report for more information.

 

Last modified

Tags

Classifications

Public