Submit a ticketCall us

Have You Auto Renewed? If not, you're missing out.
The SolarWinds Renewal Program comes with a host of benefits including the most recent product updates, 24/7 technical support, virtual instructor-led training and more. Experience all of this with the convenience of Auto Renewal, and never worry about missing any of these great benefits. Learn More.

Home > Success Center > VoIP & Network Quality Manager (VNQM) > VNQM license exceeded on the Customer Portal

VNQM license exceeded on the Customer Portal

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

Views: 27 Votes: 1 Revisions: 5

Overview

A VNQM License Exceeded message appears on the Customer Portal and on Web Console with Customer Portal Integration enabled.

However, the License Details on the Web Console do not indicate an issue.

 

exceeded.PNG

 

Environment

VNQM version 4.2.2

Cause 

This issue happens when some phones have moved from one call manager to another so they are registered on one and unregistered on the other.

Both the registered and unregistered appear as licensed in the database for the warning but they do not count towards your license and does not affect operation of the module.

Resolution

  1. Create a backup of VNQM.xml in C:\Program Files (x86)\SolarWinds\Orion\Modules\ to your local drive, in case you need to roll back later.
  2. Open the file VNQM.xml in a text editor.
  3. Find and Replace the following query

SELECT COUNT([ID]) AS [Phones] FROM Orion.IpSla.CCMPhones WHERE [Licensed] = 1

With the query below


SELECT COUNT(1) AS [Phones] 
FROM
(SELECT 
ph.Name, 
ph.MACAddress,
count(1) as ct
FROM 
Orion.IpSla.CCMPhones ph
INNER JOIN Orion.ipsla.ccmmonitoring ccm on ph.CCMMonitoringID = ccm.ID AND ccm.Deleted != 1 and [ph.Licensed]=1
group by ph.Name, ph.MACAddress)

  1. Restart Orion Services using the Orion Service Manager (Start > SolarWinds Orion > Advanced Features > Orion Service Manager).
Last modified

Tags

Classifications

Public