Submit a ticketCall us

Looking to compare latest NPM features with previous versions of NPM?
The NPM new feature summary offers a comparison of new features and improvements offered with this release.

 

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: 9 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
04:34, 23 Jun 2016

Tags

Classifications

Public