cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Announcements

158
Views
5
Helpful
2
Replies
Highlighted
Beginner

CUCM SQL Query

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.

Everyone's tags (2)
1 ACCEPTED SOLUTION

Accepted Solutions
Cisco Employee

Re: CUCM SQL Query

hi,

 

did you try this?

 

run sql select * from alternatenumber

 

thanks,

Ishan

2 REPLIES 2
Cisco Employee

Re: CUCM SQL Query

hi,

 

did you try this?

 

run sql select * from alternatenumber

 

thanks,

Ishan

Beginner

Re: CUCM SQL Query

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.
CreatePlease to create content
Content for Community-Ad
August's Community Spotlight Awards