Submit a ticketCall us

Bridging the ITSM Divide
Integrated help desk and remote support software for faster resolution

Join us on Wednesday, November 29, 2017 at 11 a.m. CT, as we discuss the benefits of effectively integrating your help desk software with remote support solutions to help increase the efficiency of IT administration, improve communication, and decrease mean time to resolution (MTTR) for IT issues of all sizes. This directly impacts end-user satisfaction and your business’ bottom line. Register Now.

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