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.

CUCM 6 databse master table

Hi team,

Just trying to find out some stuff to access and run SQL commands on CUCM 6 (i think its running on IBM Informix database).

Whats the master table name in CUCM 6 so that I can find other tables from there?

do you have some links where I can find more about connecting to CUCM6 Database via ODBC or JDBC?

Thank you

Sanjeev

1 ACCEPTED SOLUTION

Accepted Solutions

Re: CUCM 6 databse master table

Informix: yes

The answer do your question on "master table".

admin:run sql select tabname from systables

This command will give you all tables in the database. If you want to see more than just the table name, then you can select "*".

I recommend also downloading the data dictionary: http://www.cisco.com/en/US/docs/voice_ip_comm/cucm/datadict/6_1_1/dd_611.pdf

I also recommend reading up on the Administrative XML API (http://developer.cisco.com/)

If interested, I wrote up a 3 part blog series on this topic (more or less) here:

http://www.netcraftsmen.net/resources/blogs/running-sql-queries-on-cucm-6x7x-using-axl-soap-toolkit-part-1.html

Part 1 goes into table structures

Part 2 explains the AXL Query toolkit

Part 3 provides an example on using the toolkit to modify the database

FYI, you cannot access the database directly therefore ODBC/JDBC is not supported. You must use the AXL/SOAP interface to do your thing.

HTH.

Regards,

Bill

Please remember to rate helpful posts...

HTH -Bill (b) http://ucguerrilla.com (t) @ucguerrilla

Please remember to rate helpful responses and identify

2 REPLIES

Re: CUCM 6 databse master table

Informix: yes

The answer do your question on "master table".

admin:run sql select tabname from systables

This command will give you all tables in the database. If you want to see more than just the table name, then you can select "*".

I recommend also downloading the data dictionary: http://www.cisco.com/en/US/docs/voice_ip_comm/cucm/datadict/6_1_1/dd_611.pdf

I also recommend reading up on the Administrative XML API (http://developer.cisco.com/)

If interested, I wrote up a 3 part blog series on this topic (more or less) here:

http://www.netcraftsmen.net/resources/blogs/running-sql-queries-on-cucm-6x7x-using-axl-soap-toolkit-part-1.html

Part 1 goes into table structures

Part 2 explains the AXL Query toolkit

Part 3 provides an example on using the toolkit to modify the database

FYI, you cannot access the database directly therefore ODBC/JDBC is not supported. You must use the AXL/SOAP interface to do your thing.

HTH.

Regards,

Bill

Please remember to rate helpful posts...

HTH -Bill (b) http://ucguerrilla.com (t) @ucguerrilla

Please remember to rate helpful responses and identify

Re: CUCM 6 databse master table

Thanks Bill.

597
Views
5
Helpful
2
Replies
CreatePlease to create content