[cisco-voip] getting a list of assigned numbers out of CCM

[dschulz]

Hi Tim - 
 
The Route Plan Report will provide you with all the configured DNs, route
pattern, translation patterns, etc.... all configured numbers that
CallManager looks through as part of the Digit Analysis process.  You can
export this to an Excel spreadsheet and create a .csv file.  I am not sure
if this is what you were looking for.  HTH,
 
Dave Schulz
dschulz at skyline-ats.com
 
 

  _____  

From: cisco-voip-bounces at puck.nether.net
[mailto:cisco-voip-bounces at puck.nether.net] On Behalf Of Tim Reimers
Sent: Monday, November 19, 2007 9:08 AM
To: Cisco Voip Mailing list
Subject: [cisco-voip] getting a list of assigned numbers out of CCM



Hi folks-

 

Quick question -

 

The Route Plan Report-

 

Does anyone have any idea what that actually does in terms of SQL?

 

I'd like to write a SQL query somehow that can return simply extensions that
are assigned-

including phones, CTE route points, etc - anything that would have a number
assigned.

 

Right at the moment, I just need a listing of _all_ of the extension numbers
that are assigned to -anything-

 

And I don't really want it in the form of a webpage - csv that could be
imported would be _really really_ nice.

Hence my desire to do something other than just run the RPR.

 

This is related to a speed dial button configuration I have to do, so I
might be coming back with some ?? related to that later on.

 

Thanks, Tim

-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://puck.nether.net/pipermail/cisco-voip/attachments/20071119/ebb890b3/attachment.html