Alternate Contact Number in the Unity Database

Unanswered Question
Aug 19th, 2008
User Badges:


I have a client that would like us to pre-load approximately 700 cell phone #s as alternate contacts for their users. I can see how I can use the sp_ModifyMenuEntry procedure to assign the action to the 1 key, but I haven't been able to find where in the database the alternate contact number is stored.

Can anyone tell me how to find this or is this particular value not available via the stored procedures/views?



  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
milucero Wed, 08/20/2008 - 11:07
User Badges:


What version of Unity are you using?

Normaly all extensions are store in the DTMFAccessId table.

You may aslo be able to use the bulk edit tool to accomplish this.


paulw.wilkinson Wed, 08/20/2008 - 13:27
User Badges:


It is Unity 5. I will have another look at that table, but I don't think it is there.

From the web interface you can select "call alternate number" from the menu configuration options and then enter the number in a text field directly below this option.

Ginger Dillon Wed, 08/20/2008 - 16:18
User Badges:
  • Blue, 1500 points or more

Hi -

Have you considered Bulk Edit using a CSV file that selects the subscribers to edit?


eschulz Wed, 08/20/2008 - 16:32
User Badges:
  • Cisco Employee,

BulkEdit sounds like a much better way to go. But if you must know, the Alt Contact Number is stored in the ReferralExtension column of the Subscriber table.



This Discussion