cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
9612
Views
4
Helpful
3
Replies

Caller ID Phone number Mask, 911 calls

courtnash
Level 1
Level 1

    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 Accepted Solution

Accepted Solutions

dakeller
Cisco Employee
Cisco Employee

Courtney,

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.

Thanks,

Dan Keller

Technical Marketing Engineer

View solution in original post

3 Replies 3

dakeller
Cisco Employee
Cisco Employee

Courtney,

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.

Thanks,

Dan Keller

Technical Marketing Engineer

Nuno Melo
Level 4
Level 4

Greetings,

In regards to a report there isn't really one, however you can export a text file witch contain all the device configuration parameters for all the endpoints that are configured in Call Manager witch you can then  filter on Excel by external phone number mask and check how many devices you have without it.

On Gui do the following:

1 - Go to Bulk Administration > Phones > Export Phones > All Details

2 - Type a file name I.E Phones_Export and on job information Select Run Immediateley

3 - Go to Bulk Administration > Upload Download Files and download the generated text file

4 - Once downloaded rename the file termination from .txt to .csv and open in excel where you can find the external phone number mask filed and apply the filtering according to your needs.

Courtney,

The method you describe above is also valid.  But be aware that when you do a full phone export, the line information will be concatenated to the device entry.  Meaning if you have a phone with 6 lines, all 6 lines will be concatenated onto the same line.  I have found the length of the line to be problematic when bulk administrating phones. 

Thanks,

Dan Keller

Technical Marketing Engineer

Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: