Submit a ticketCall us

Don’t fall victim to a ransomware attack
Backups are helpful, but sometimes that’s not enough to protect your business against ransomware. At our live webcast we will discuss how to protect against ransomware attacks with SolarWinds® Patch Manager and how to leverage log data to detect ransomware. Register now for our live webcast.

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