Submit a ticketCall us

Looking to compare latest NPM features with previous versions of NPM?
The NPM new feature summary offers a comparison of new features and improvements offered with this release.

 

 

 

 

Home > Success Center > Network Performance Monitor (NPM) > SQL filters are not working after upgrading to NPM 11.5

SQL filters are not working after upgrading to NPM 11.5

Created by Gary O'Donovan, last modified by MindTouch on Jun 23, 2016

Views: 783 Votes: 0 Revisions: 3

Overview

SQL filters are no longer working after upgrading to NPM 11.5.

For example, Filter Nodes (SQL).

Environment

NPM v11.5

Cause 

Certain database tables were changed between NPM 11.0.1 and 11.5.

Resolution

 

The following tables have changed, and the SQL query needs to be updated..

AllEngines 

Engines 

The AllEngines table has replaced the Engines table and has an Engines view

NodesCustomProperties

Nodes

The Nodes table has been split into the highlighted tables

NodesData 

Nodes

 

NodesStatistics 

Nodes

 

tablename_date

History

The History table has been split into individual tables+the date.

 

Last modified
23:38, 22 Jun 2016

Tags

Classifications

Public