Ever keep track of your DIDs in a spreadsheet? Not sure if that pesky help desk marked one as being used? Here\’s a helpful command to see if one has been put in the \”External Phone Number Mask\” field on a device in CUCM.
SSH to the publisher and run this command:
run sql select * from devicenumplanmap where e164mask like \”1112223333\”
where 1112223333 is the DID you\’re searching for.
The output will look like this:
admin:run sql select * from devicenumplanmap where e164mask like \”1112223333\”
pkid fkdevice numplanindex label fknumplan display tkringsetting ctiid e164mask dialplanwizardgenid tkmwlpolicy tkringsetting_consecutive maxnumcalls busytrigger callinfodisplaymask labelascii displayascii tkringsetting_activepickupalert tkringsetting_idlepickupalert tkpartitionusage speeddial fkrecordingprofile fkcallingsearchspace_monitoring tkstatus_audiblemwi logmissedcalls
==================================== ==================================== ============ ========== ==================================== ========== ============= ===== ========== =================== =========== ========================= =========== =========== =================== ========== ============ =============================== ============================= ================ ========= ================== =============================== =================== ==============
fe9f18dc-bb32-304b-a848-187c865c48b2 b434cc19-a4db-da30-a26c-525d240882ae 1 Clark Kent 099e2fe6-dbc2-7214-7a88-6a5526cfd2d9 Clark Kent 0 1 1112223333 NULL 0 0 4 2 9 Clark Kent Clark Kent 0 0 99 NULL NULL NULL 2 t
The output is a bit jumbled but you can see that Clark Kent has been assigned the DID 1112223333.
I used SQL command this morning to solve tough question. Thanks for posting this!