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) > 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: 16 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

Tags

Classifications

Public