Submit a ticketCall us

Training Class Getting Started with SolarWinds Backup - February 28

This course offers customers an introduction to SolarWinds Backup, focusing on configuring the backup technology, taking backups, data restoration and data security. It is a great primer and will get you up to speed quickly on SolarWinds Backup.
Register for class.

Home > Success Center > Network Performance Monitor (NPM) > 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 June 16, 2017

Overview

This article describes an issue where a number of custom reports do not return data after upgrading to NPM 12.
An error related to data grouping is displayed when editing the report. The chart does not return any data when data grouping for values is set.

Environment

NPM 12

Cause 

The Data Grouping option is available in NPM 11.5 and earlier versions and is responsible for customizing group data into a chart series.
For example, an SQL or SWQL query in the data source returns historical data for several objects and you want to display the chart per object. In this case, you need to specify the column name to group the chart data (such as NodeID). If you need to group the chart data by NodeID, set the legend to Node Name and select the Caption column if it exists. 

This is also available in NPM 12 but you will need to specify the grouping to be able to create a report with a custom chart resource and SQL data source.

Resolution

Add a dummy column to return the same value for all rows and then select the column in the Data Grouping option.

 

Last modified

Tags

Classifications

Public