Submit a ticketCall us

Get a crash course on Network Monitoring delivered right to your inbox
This free 7-day email course provides a primer to the philosophy, theory, and fundamental concepts involved in IT monitoring. Lessons will explain not only how to perform various monitoring tasks, but why and when you should use them. Sign up now.

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