This article describes the issue when VNQM license shows a higher phone count than the actual number of phones in the environment.
This issue occurs when the Cisco Unified Communications Manager (CUCM) phone tables have duplicates, or if there are multiple CUCMs with existing phones.
There are two ways to resolve this issue:
Query to remove duplicates
BEGIN
CREATE TABLE CcmPhonesDupIDs
(
ID int,
nr int
)
INSERT INTO CcmPhonesDupIDs
SELECT
ID,
row_number() OVER (PARTITION BY VoipCCMMonitoringID, MAC_Address ORDER BY VoipCCMMonitoringID, MAC_Address) AS
nr
FROM VoipCCMPhones
DELETE FROM VoipCCMPhoneStats_Hourly WHERE VoipCCMPhonesID IN( SELECT ID FROM CcmPhonesDupIDs WHERE nr>1)
DELETE FROM VoipCCMPhoneStats_Daily WHERE VoipCCMPhonesID IN( SELECT ID FROM CcmPhonesDupIDs WHERE nr>1)
DELETE FROM VoipCCMPhoneStats_Detail WHERE VoipCCMPhonesID IN( SELECT ID FROM CcmPhonesDupIDs WHERE nr>1)
DELETE FROM VoipCCMPhonesCiscoData WHERE VoipCCMPhonesID IN( SELECT ID FROM CcmPhonesDupIDs WHERE nr>1)
DELETE FROM VoipCCMPhonesAvayaData WHERE VoipCCMPhonesID IN( SELECT ID FROM CcmPhonesDupIDs WHERE nr>1)
DELETE FROM VoipCCMPhones WHERE ID IN( SELECT ID FROM CcmPhonesDupIDs WHERE nr>1)
DROP TABLE CcmPhonesDupIDs
END
GO
Remove all phones