SQl Query to pull Device Owner

The below SQL Query can be used to pull the details of Owner-Id assigned to the phones. Tables used.  Device – This table contains device-level information like IP Phones and gateways. Enduser – This table contains information about all Enduser in CUCM. Sql Query. SQL query to List the complete devices and the Owner status. Devices with…

Sql Query to pull unassigned DNS

The below SQL Query can be used to pull the details of Unassigned Dn’s Tables used.  NumPlan – This table contains information about all patterns configured in CUCM. Sql Query. run sql select dnorpattern from numplan where iscallable = ‘f’ Note:-unassociated DN IsCallable to False

SQL Query to pull devices not assigned with DN’s

The below SQL Query’s can be used to pull the devices which are not assigned with a DN Tables used.  Device – This table contains device-level information like IP Phones and gateways. DeviceNumPlanMap – This table contains the mapping between data in Device table and NumPlan table. If no DN’s are assigned, Device PKID wont be available…

SQL Query to list the Enduser, Controlled Devices,Extension Number & the device Type

The below SQL Query can be used to pull the details of Enduser-ID, controlled devices , their DN and the device Type. Tables used.  Device – This table contains device-level information like IP Phones and gateways. NumPlan – This table contains information about all patterns configured in CUCM. DeviceNumPlanMap – This table contains the mapping between data in…

SQL Query to list Enduser and controlled devices

Use below SQL query to List User-ID and controlled devices. Tables used. Device – This table contains device-level information like IP Phones and gateways.Enduser – This table contains information about all Enduser in CUCM.Enduserdevicemap – This table contains the mapping between data in Enduser table and Device table. Sql Queries. run sql select enduser.userid, device.name from enduser, enduserdevicemap,device…

SQL Query to Pull device model and Firmware load from CUCM

In this blog I share two SQL queries. The first one to pull the device MAC address with Dn and the device type . Second one to pull the device Mac address with DN , active load and inactive load. Tables used. Device – This table contains device-level information like IP Phones and gateways. NumPlan – This…

SQL Query to pull device details with CSS from CUCM

The beauty of sql query is that you can pull custom information from CUCM. Which is useful when preparing document and sharing details with your customer. In this blog I share Three SQL queries. The first one to pull the device MAC address with Dn in the order of DN. Second one to pull the…

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…