Side Note: The above query can also be expressed as: select t.tabname, c.colname from systables t, syscolumns c where c.tabid=t.tabid order by t.tabname. So, if you wanted to see a list of tables and their associated columns, you could use this query:ДЇrom systables as t inner join syscolumns as c on c.tabid=t.tabid The systablesВ and syscolumnsВ table are linked by a foreign key known as tabidВ (which is the primary key for systables). The syscolumnsВ table identifies all columns associated with a table. In Informix, the first new table added to the database after the database is created will start with the ID of 100. If you are only interested in tables that were created by Cisco then you can use the following query: The above will list all of the table names within the database, including systables. A simple query can be used to dump all of the system tables: The systablesВ table contains some very basic information about all of the tables in the Informix database. We will be using the systablesВ and syscolumnsВ catalogs. Without going too deep into this, the system catalogs can be thought of as metadata for the database. We are going to be working with the Informix system catalogs to get at the information we need. Let's walk through our recent installment of this series: Displaying Devices and Assigned DNs. If we want to keep this blog from meandering on forever, we need an example to walk through. This is definitely more efficient when I am trying to find the exact column name in a table (or set of tables) that I already have some familiarity. However, I find it is often quicker (for me anyway) to query system tables directly from the CLI. This resource is handy when you are looking to build a query involving tables you haven't much familiarity with. Cisco provides a Data Dictionary that anyone can download. Output from the above query on my CUCM 8.5(1)SU3 system:ДЇor this week's post I wanted to introduce some tools that may come in handy when trying to put together a query on the system. So, in the spirit of that goal we will look at our first query: how can you tell which version of the Informix IDS is running on your CUCM? This week's query (or query set?) focuses on exploring the Informix database structure via the system tables. A great place for support info is provided by IBM at the Informix IDS 11.5 Information Center. The current Informix version used by CUCM 8.x is 11.5. That's OK, I still find the resource helpful.

I started with this tutorialВ which is based on Informix IDS version 10.0 (which was EOL in 2010). However, you do need to understand some basics around SQL and, as you try to perform some advanced queries, you will need to learn a little about the specific syntax expected by this RDBMS. You don't need to know anything about Informix to get started with exploring the CUCM database. Informix is the relationship database management system (RDBMS) used on the Cisco UCM appliance (as well as many other Cisco UC apps).

Cisco cucm 8.6 database schema