Submit a ticketCall us

ebook60.pngHow to be a Cisco® ASA ace

Our eBook, Thou Shalt Not Pass…I Think?! can help you overcome the challenges of monitoring and managing Cisco ASA firewalls. This eBook is a great read if you’ve been frustrated with monitoring firewalls, managing ACL configs, and troubleshooting VPN connections.

Get your free eBook.

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


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.


NPM 12


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.


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


Last modified