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

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

New Member

How to query the database on a CM 7.1.3

Hi,

     Until last week we were running CM 4.1. On that version we had full access to query the CM databases (i.e. CCM0301, CDR) using tools such as ms query analyzer.

Now that we're running CM 7.1.3 it seems is not as easy.

Does anybody know if is possible?

maybe by loading the required IBM Informix drivers and connecting to it?

Is there a service that needs to be activated? remote acces service?

if possible,
what tool would I use? Toad?

thanks

2 REPLIES

Re: How to query the database on a CM 7.1.3

Although I'm sure there must be slicker ways to do it, this document demonstrates how to run SQL queries from the CLI:

http://www.tek-tips.com/viewthread.cfm?qid=1524902&page=6

Make sure you keep the most recent table structure handy though:

http://www.cisco.com/en/US/docs/voice_ip_comm/cucm/datadict/7_1_3/datadictionary_713.pdf

Cisco Employee

Re: How to query the database on a CM 7.1.3

You can use AXL/XML as well

Cisco Unified Communications Manager  (CallManager)

Programming Guides

http://www.cisco.com/en/US/products/sw/voicesw/ps556/products_programming_reference_guides_list.html

HTH

java

If this helps, please rate

www.cisco.com/go/pdihelpdesk

HTH

java

if this helps, please rate

www.cisco.com/go/pdi
360
Views
0
Helpful
2
Replies