05-11-2006 06:51 AM - edited 03-13-2019 01:15 PM
I am looking for the SQL database that holds the setting for the Directry number configuration. What I am trying to figure out is which phone has which DID number assigned. We have around 250 did numbers and I do not know which users have which DID numbers. In callmanager under translation patterns a wild card was used i.e 569xxxx
If someone has a better suggestion to find out which users have which DID's I am open.
05-11-2006 10:12 AM
What does the translation pattern translate the incoming number to? For example, if the Called Party Transform Mask is XXXX, then the last 4 digits of the number will indicate the DN that will receive the call. Assuming you know your range of DIDs, you can figure out the DNs that they translate to.
Hope this helps. If so, please rate the post.
Brandon
05-11-2006 11:37 AM
I found two ways to do waht what I was looking for..
1.) The BAT tool. If you go in to BAT then choose configure then phones there is an option to export in the upper right hand side. When you choose export you are taken to a screen where you can select the detail of information you want and the types of phones. I chose this method to determin what exts were associated with waht outside DID.
2.) From SQL use the Num Plan table. This table holds all the settings for the device and line.
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide