Precursor: I am running 8.6(2) in a lab environment although the question can be applicable to UCM 6 and 7 as well)
Question for DLU assignment in UCM 8.6(2).
I have written some SQL queries against the UCM 8.6(2) Data Dictionary to understand DLU licensing assignments for registered devices.
run sql SELECT d.Name, d.Description, tc.name AS class, tm.name AS model, tu.units AS dlu
FROM Device AS d
JOIN typeclass AS tc ON d.tkclass = tc.enum
JOIN typemodel AS tm ON d.tkmodel = tm.enum
JOIN typelicenseunit AS tu ON tm.name = tu.name
WHERE tc.name IN ('Phone','Device Profile')
name description class model dlu
========================== ====================== ============ ============= ===
SEP0015C69F2838 CS Test Phone Phone Cisco 7940 4
SEP00152BA22966 SEP00152BA22966 Phone Cisco 7940 4
SEP000CCE73FF41 SEP000CCE73FF41 Phone Cisco 7940 4
SEPAB39EBF9DB00 SEPAB39EBF9DB00 Phone Cisco 7905 2
CIPC3 Agent5 Phone Cisco IP Communicator 3
CIPCDGAUTHIER-DP DP fo EM for CIPCDGAUTHIER Device Profile Cisco IPCommunicator 3
EM User Extension Mobility User Device Profile Cisco IP Communicator 3
CIPCDGAUTHIER CIPC for DGauthier Phone Cisco IP Communicator 3
SEP000C295F2938 Phone Cisco IP Communicator 3
As you can see above, the Device Profile for EM (Extension Mobility) appears to have 3 DLUs assigned...keep in mind that I have removed some of the entries to simplify my response. But, between Phones and Device Profiles allocated...I get a total of 78 license when I query via CLI.
When I go to the UCM, System, Licensing, License Unit Report, I only get 72 licenses allocated. Will state that the 78 vs 72 licenses have not association with Node licenses for Pub and Sub(s).
Can somebody add insight? It seems like an inconsistency the was UCM GUI reports on DLUs vs CLI license reporting...
Please advise...thx!
