Introduction
This document covers the procedure for Identifying the IP Phones connected to Cisco Unified Communications Manager with DND Feature using CUCM SQL Query.
Requirement
On a large Enterprise network customer is trying to identify the IP Phones which are activated with DND Feature and write a CUCM SQL query to display all the phones with their name, description and DND status and want to understand how DND status is represented in the DB from a schema perspective.
Solution
![sql-1.png](/legacyfs/online/legacy/4/7/5/163574-sql-1.png)
admin:run sql select device.name, device.description, device.tkdndoption, device.tkringsetting_dnd, dnddynamic.dndstatus FROM device LEFT JOIN dnddynamic ON dnddynamic.fkdevice = device.pkid
For more information on CUCM Data Dictionary which has the list of tables inside for CUCM 8.6(1),
http://www.cisco.com/en/US/docs/voice_ip_comm/cucm/datadict/8_6_1/datadictionary_861.pdf
Related Information