Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
New Member

Call Manager 6.1 database

Does anybody know if there is a way to run queries against the Call Manager databases? I want to look at the data in the database for some things like caller ID and route patterns but I cannot figure out how to actually access the database to run queries against it. I'm trying to put together documentation regarding how our route patterns are setup but don't really know where to look. In Call Manager 4 I could use SQL management to look at the data but with Call Manager 6.1 I don't think I can use that. Any assistance would be appreciated.

4 REPLIES
Cisco Employee

Re: Call Manager 6.1 database

yes, look at the data dictionary for reference of the DB layout (very similar to previous versions) and you can run qrys from CLI

run sql

http://www.cisco.com/en/US/docs/voice_ip_comm/cucm/cucos/6_1_1/cucos/iptpappa.html#wp1052698

HTH

java

if this helps, please rate

HTH

java

if this helps, please rate

www.cisco.com/go/pdi
New Member

Re: Call Manager 6.1 database

Thank you for the information, that is exactly the kind of thing I was looking for.

Bronze

Re: Call Manager 6.1 database

Hi, you can use the commnands: run sql sql_statement

Ex: run sql select name from device

Hope this help

David

New Member

Re: Call Manager 6.1 database

Thanks for the information and help, now I just need to work on my sql skills again. I appreciate the input.

252
Views
10
Helpful
4
Replies
CreatePlease to create content