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...