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