CUCM SQL Query

[kumar4321]

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.

[Ishan Zutshi · Accepted solution]

hi,

did you try this?

run sql select * from alternatenumber

thanks,

Ishan

[kumar4321 · Accepted solution]

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.