CUCM Extension and CSS list using SQL Query

From Cli we can query CUCM Database directly. I would like to give a brief idea about the query which I use to pull extension and their calling search space from CUCM CLI.

Tables

Queries are formed with the data in below tables

  • NumPlan – This table contains information about all patterns configured in CUCM.
  • CallingSearchSpace: This table contains information about list of CSS configurations on the system

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

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

List the Dn, Alerting Name and the CSS.

Here is a query that is designed to list all the dn, alerting name their calling search space.

run sql select dnorpattern,alertingname,name from numplan n, callingsearchspace c where n.fkcallingsearchspace_sharedlineappear = c.pkid

Output:-

Leave a Reply

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

WordPress.com Logo

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

Google photo

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