Submit a ticketCall us

AnnouncementsWeb Help Desk Integrations eCourse

Looking to reduce response times? Sign up for our eCourse to learn how integrating Web Help Desk with Dameware Remote Support, Network Configuration Manager, Network Performance Monitor, and Server & Application Monitor can improve communication efficiencies.

Register for your free eCourse.

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 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