Display All External Phone Number Mask

[ctalavat]

How am I able to see every single external phone number mask on CUCM?

[Roger Kallberg]

You would have to export all of the directory numbers for that and then open the CSV file in Excel.

[ctalavat]

How would I go about doing that?

[Roger Kallberg]

In the Bulk Administration menu.

[ctalavat]

I see a lot of different options now under Bulk Administration menu.  I'm not familiar with these options. 

[Roger Kallberg]

I’m sure that with a minimum amount of effort on your end you can figure it out. You’ll not learn anything if you get it served up on a platter. If you get stuck please get back to the post and we’ll point you in the right direction 

[Nithin Eluvathingal]

you can run the SQl command i shared from CLI and you get the Mask configured with extensions.

2.12.0.0

[Nithin Eluvathingal]

Try the below from cli

run sql select dnorpattern, d.description, e164mask, tkpatternusage from devicenumplanmap  inner join numplan on fknumplan=numplan.pkid  join device d on fkdevice = d.pkid

[ctalavat]

Can I do this on the GUI?

[Nithin Eluvathingal]

Ssh to CUCM IP, Login using  os admin password and run the command. Copy that to text and import to excel.

2.12.0.0

[Roger Kallberg]

Go to Bulk Administration > Import/Export > Export, then select Phone.

[ctalavat]

Thanks for the guidance.