CUCM SQL Query – 2

In the Last blog we learned about select method and some basic SQl queries on CUCM. Today will learn Join and Where Clause. JOIN JOIN is a query clause that can be used with the SELECT, UPDATE, and DELETEdata query statements to simultaneously affect rows from multiple tables. Thereare several distinct types of JOIN statements…

Basic CUCM SQL Queries-1

Lets learn some basics of SQl Queries and try it on CUCM. What SQL? SQL is used to communicate with a database. According to ANSI (American National Standards Institute), it is the standard language for relational database management systems. SQL statements are used to perform tasks such as update data on a database, or retrieve…

CUCM Extension list and their call forwarding status using SQL Queries

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…

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…