Submit a ticketCall us

Systems Monitoring for Dummies
Our new eBook will teach you the fundamentals and help you create monitors and alerts that are effective, meaningful, and actionable. Monitoring is more than a checkbox on your to-do list. This free eBook will give you practical advice to help you succeed in all aspects of monitoring – discovery, alerting, remediation, and troubleshooting. Don’t miss out on this indispensable resource for newbies, experienced IT pros, and everyone in between. Register Now.

Home > Success Center > Archive > 2017December12 - Deletes > 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 Kevin.Swinson on Dec 12, 2017

Views: 23 Votes: 0 Revisions: 4

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

Tags

Classifications

Public