CUCM Extension list and their call forwarding status using SQL Queries


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 To make things easier ti have mentioned the link below.!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



Leave a Reply

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

You are commenting using your 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 )

Connecting to %s