Caller ID Question

[AdmanOK]

I currently have the outbound caller id set on my CallManager system by putting my main number into the Route List configuration. This means that any call going out that gateway will use the number that I have provided. I would now like to change to having each phone's DID displayed on outbound calls, but cannot make use of a mask as I have multiple DID ranges with different office codes going through the same trunk. I know that I can resolve this by not putting a number into the route list configuration and specifying a "External Phone Number Mask" on each line of every phone. With over 150 phones and up to 10 lines per phone this is a daunting task. I have investigated and found the that External Phone Number Mask entry is stored in a field called e164mask in the DeviceNumPlanMap table of the CCM database. I have written a VBScript that will compute the correct number for each line and update the database and run it on a backup copy of the database running on a seperate SQL server, but before I run it on a real CallManager I wanted to see if anyone had any experience with making manual changes to the DB. Is there anything I should watch out for?

 

[jerake75]

Don't know what kind of setup you have as far as gateways, but we use a 6608 T1 with six ISDN PRI's, so to make it pass the DID numbers through the PSTN, I have a mask of 847555XXXX set up in the Caller ID DN field on each of our six gateways. That field is under the Call Routing Information - Outbound Calls section under the Gateway Configuration page for each gateway. It's quick and dirty, but it's highly effective.

Hope this helps -

jerake