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

CUCM SQL Query

kumar4321
Level 1
Level 1

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.