[cisco-voip] External Phone Number Mask

[Nate VanMaren]

Ssh to the publisher

Then type
run sql select dnorpattern, e164mask, tkpatternusage from devicenumplanmap  inner join numplan on fknumplan=numplan.pkid where e164mask <> "YOUNUMBER here"

you might want to add an "and tkpatternusage = "2"" at the end to only get numbers that are assigned to devices.


admin:run sql select * from typepatternusage
enum name                               moniker
==== ================================== ==========================================
0    CallPark                           PATTERN_CALL_PARK
1    Conference                         PATTERN_CONF
2    Device                             PATTERN_DEVICE
3    Translation                        PATTERN_TRANSLATION
4    Call Pick Up Group                 PATTERN_CALL_PICK_UP_GROUP
5    Route                              PATTERN_ROUTE
6    Message Waiting                    PATTERN_MESSAGE_WAITING
7    Hunt Pilot                         PATTERN_HUNT_PILOT
8    Voice Mail Port                    PATTERN_VOICE_MAIL_PORT
9    Domain Routing                     PATTERN_ROUTE_DOMAIN
10   IPAddress Routing                  PATTERN_ROUTE_IPNET
11   Device template                    PATTERN_DEVICE_TEMPLATE
12   Directed Call Park                 PATTERN_DIRECTED_CALL_PARK
13   Device Intercom                    PATTERN_DEVICE_INTERCOM
14   Translation Intercom               PATTERN_TRANSLATION_INTERCOM
15   Translation Calling Party Number   PATTERN_TRANSLATION_CALLING_PARTY_NUMBER
16   Mobility Handoff                   PATTERN_MOBILITY_HANDOFF
17   Mobility DTMF                      PATTERN_MOBILITY_DTMF
18   Mobility IVR                       PATTERN_MOBILITY_IVR
19   Device Intercom Template           PATTERN_DEVICE_INTERCOM_TEMPLATE
20   Called Party Number Transformation PATTERN_TRANSFORMATION_CALLED_PARTY_NUMBER


From: cisco-voip-bounces at puck.nether.net [mailto:cisco-voip-bounces at puck.nether.net] On Behalf Of Haas, Neal
Sent: Thursday, November 04, 2010 3:28 PM
To: 'Dennis Heim'; 'cisco-voip at puck.nether.net'
Subject: Re: [cisco-voip] External Phone Number Mask

Any link on how I can do that, I am not sure of how to connect to the call manager to do that, I have seen some command line information but I would really love to complete a query from my desktop.

Thanks

Neal

From: Dennis Heim [mailto:Dennis.Heim at cdw.com]
Sent: Tuesday, November 02, 2010 4:20 PM
To: Haas, Neal; 'cisco-voip at puck.nether.net'
Subject: RE: External Phone Number Mask

External phone mask should be the e164mask field in the devicenumplanmap table.

Dennis Heim
Network Voice Engineer
CDW  Advanced Technology Services
11711 N. Meridian Street, Suite 225
Carmel, IN  46032

317.569.4255 Office/Home Office
317.569.4201 Fax
317.694.6070 Cell
dennis.heim at cdw.com<mailto:dennis.heim at cdw.com>
cdw.com/content/solutions/unified-communications/<http://www.cdw.com/content/solutions/unified-communications/>

From: cisco-voip-bounces at puck.nether.net [mailto:cisco-voip-bounces at puck.nether.net] On Behalf Of Haas, Neal
Sent: Tuesday, November 02, 2010 7:11 PM
To: 'cisco-voip at puck.nether.net'
Subject: [cisco-voip] External Phone Number Mask

I need to find which phone has the wrong external MASK. I have 1 phone out of 1000 with the wrong external Mask. I don't want to go through every phone.

Do I need to do a SQL query? If so how do I accomplish this, I am on 7.1.3.10000-11 Linux!

Thanks



Neal


 NOTICE: This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message.


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20101104/dc2f0f43/attachment.html>