CUCM Sql Query

CUCM Extension list and their call forwarding status using SQL Queries

Posted by Nithin Eluvathingal on

Tables

Queries are formed with the data in below tables

  • NumPlan – This table contains information about all patterns configured in CUCM.

 CUCM Data Dictionary

You can learn more about tables from CUCM Data Dictionary for respective versions. Latest version Data Dictionary is now available in developer.cisco.com. To make things easier ti have mentioned the link below.

https://developer.cisco.com/docs/axl/#!12-5-cucm-data-dictionary

List the Dn and their call forwarding status.

Here is a query that is designed to list call forwarding status of CUCM extensions.

run sql select n.dnorpattern, cfd.cfadestination, cfd.cfavoicemailenabled from numplan as n inner join callforwarddynamic as cfd on cfd.fknumplan=n.pkid order by n.dnorpattern

Output:-

Advertisement

Leave a Reply

Fill in your details below or click an icon to log in:

Gravatar
WordPress.com Logo

You are commenting using your WordPress.com account. ( Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. ( Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. ( Log Out /  Change )

Cancel

Connecting to %s