1 Reply Latest reply: May 9, 2017 11:43 AM by dakeller RSS

Caller ID Phone number Mask, 911 calls


    We are in the process of correcting E911 for all the floors in our buildings. We have over 1500 phones and some of the phone numbers don't have the Phone number mask area blank. When a user dial 911, they don't received the true extension of the caller. It's almost impossible to locate them. Does anyone know of a way to generate a report to find the extension that the  Phone Number Mask has not been completed? If there's no report can I run a command within the CUCM to gather the information?

  • 1. Re: Caller ID Phone number Mask, 911 calls


    What you asking for is not a common request, so there is no report or tool you can run in the UCM GUI to get the information.  But that does not mean you cannot get the information.  One thing I want to point out is that the e.164 mask is set on a per device instance.  So 2 devices with the same DN can have different masks.   So when you address this problem in your environment, you may need to make the update on different devices (or use the 'update shared device settings')

    I was able to create an SQL query that returns a list of the external mask per DN per phone.  If you telnet to the your publisher UCM and run the following command:

    run sql select d.name, d.description, n.dnorpattern, dnpm.e164mask from devicenumplanmap dnpm inner join device d on d.pkid = dnpm.fkdevice left outer join numplan n on n.pkid = dnpm.fknumplan


    This will show ALL your DN's and their external masks, but you should be able to capture the output and sort to find which DN's on which devices need to be updated.


    Please respond to let me know if this provides the information you are looking for.



    Dan Keller

    Technical Marketing Engineer