05-03-2017 03:58 AM - edited 03-19-2019 12:24 PM
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?
Solved! Go to Solution.
05-09-2017 11:43 AM
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
05-09-2017 11:43 AM
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
06-19-2017 07:18 AM
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.
06-19-2017 09:30 AM
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
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide