How to query the database on a CM 7.1.3

[Voiceops SSC]

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

[philip.e.denton]

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

[Jaime Valencia]

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