cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
676
Views
5
Helpful
2
Replies

CUCM SQL Query

kumar4321
Beginner
Beginner

I need to extract and then update the Enterprise Alternate Number for a large number of DNs. Can I request some help to know in which SQL table is the Enterprise Alternate Number stored. I thought it will be in table numplan but I could not find it there.

2 Accepted Solutions

Accepted Solutions

Ishan Zutshi
Cisco Employee
Cisco Employee

hi,

 

did you try this?

 

run sql select * from alternatenumber

 

thanks,

Ishan

View solution in original post

thanks, there are two columns dnormask and dnderived where the alternate number seems to be stored. In my CUCM, both contain the same value. Not sure if I have to update the new alternate number in one or both columns. But I can do trial and error to figure that. Many thanks for your help.

View solution in original post

2 Replies 2

Ishan Zutshi
Cisco Employee
Cisco Employee

hi,

 

did you try this?

 

run sql select * from alternatenumber

 

thanks,

Ishan

thanks, there are two columns dnormask and dnderived where the alternate number seems to be stored. In my CUCM, both contain the same value. Not sure if I have to update the new alternate number in one or both columns. But I can do trial and error to figure that. Many thanks for your help.
Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community:

Recognize Your Peers