CUCM SQL Queries: Listing Call Forward All Settings

In this week's installment of my Cisco Unified Communications Manager (CUCM) SQL Queries series I wanted to dive into the call forward all (CFA) configurations in a production environment. This seems to be a "favorite" for folks who follow my NetCraftsmen blog.

I have found that being able to see where phones are forwarded is a common need. I have seen the question come up often in the Cisco support forums and I need to query CFA status on a pretty regular basis in my own job.

CUCM SQL Query Series: List Calling Search Spaces

In last week's installment of my series on CUCM SQL queries we did a quick dip in the CDR pool. This week we are going to meander our way back to some basic configuration gathering. Specifically, we are going to run a basic query that dumps a list of calling search spaces with associated partitions.

CUCM SQL Queries: CDR Analysis (CAR)

In this week's installment of my series on CUCM SQL queries we are going to switch gears a little. Thus far, we have been exploring configuration data in the Cisco Unified Communications Manager (CUCM) Informix database. This week, we are going to take a look at another table: The billing data table in the CAR database (tbl_billing_data).

CUCM SQL Queries: NumPlan Partition Allocation

The fourth query in my series on CUCM SQL queries provides another example of using the count() function to get a view of the number of patterns allocated to each partition provisioned in CUCM.

CUCM SQL Queries: Supplemental - Informix System Catalogs

I recently fielded a request on Twitter (@ucguerrilla) for Cisco documentation that covers the database schema and structure. This request is the inspiration for this supplemental entry to my series on CUCM SQL queries. In this supplement we are going to expand on the initial primer and demonstrate ways to use SQL queries to explore the system tables of the Informix database. When I have a need to get at data in Cisco Unified Communications Manager (CUCM) I leverage the Cisco's data dictionary along with some "exploration" of the Informix system tables. 

CUCM SQL Queries: List Phones and Line Appearances

The third query in my series on CUCM SQL queries provides a simple but effective query that dumps a list of devices and the directory numbers assigned to those devices. This is probably one of the first queries I learned (other than the basic "hello world-ish" queries). 

CUCM SQL Queries: Device Pool Allocations

I was talking to a colleague of mine about hosting a blog series which focused on providing SQL queries that I use when I need to get data from the CUCM server. The second query in this series is a simple one: displaying the number of devices allocated per device pool.

CUCM SQL Queries: A Series

A couple of years ago I started a blog series on the AXL SOAP Toolkit that Cisco provides with Unified Communications Manager (CUCM). Recently, I was talking to a colleague of mine about starting a new series that simply focused on providing SQL queries that I use when I need to get data from the CUCM server. I figure, why not? So, I am going to go for a query a week. Let's see how it goes.