Convert a single LDAP Synchronized User to Local User, use below command run sql update enduser set fkdirectorypluginconfig=NULL where userid= ‘<USER-ID>’ To convert all LDAP Synchronized User to Local User in bulk use below command run sql update enduser set fkdirectorypluginconfig=NULL where userid like ‘%’
Category: CUCM Sql Query
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…
CRAZY NETWORKING 