Submit a ticketCall us

Welcome to the NEW Success Center. Search all resources (documentation, videos, training, knowledge base articles) or browse resources by product. If you are unable to find what you are looking for, please contact us at customersuccess@solarwinds.com

 

 

 

 

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