Submit a ticketCall us

Announcing NCM 7.7
With NCM 7.7, you can examine the rules that make up an access control list for a Cisco ASA device. Then you can apply filters to display only rules that meet the specified criteria, order the rules by line number or by the hit count, and much more.
See new features and improvements.

Home > Success Center > VoIP & Network Quality Manager (VNQM) > Operations from a deleted IPSLA node are still in VNQM

Operations from a deleted IPSLA node are still in VNQM

Created by Brian O'Donovan, last modified by MindTouch on Jun 16, 2016

Views: 18 Votes: 0 Revisions: 3

Overview

Operations from a deleted IPSLA node are still in VNQM.

Environment

All IPSLAM / VNQM versions

Resolution

Note: Create a backup of your database before performing any modifications, in case you need to roll back later.

Run the following query against the database:

UPDATE VoipOperationInstances SET Deleted = 1 WHERE (SourceNodeID NOT IN (SELECT NodeID FROM Nodes)) OR (TargetNodeID IS NOT NULL AND TargetNodeID NOT IN (SELECT NodeID FROM Nodes))

Nightly maintenance will then remove the rows from the database the next time it is run.

 

Last modified
16:31, 16 Jun 2016

Tags

Classifications

Public