How to Identify devices with DND status using CUCM SQL Query?

[Muthurani Lavanya Paneerselvam]

• Introduction
• Requirement
• Solution
• Related Information

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

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

• CUCM 8.6(1) Database Dictionary

[ccg-collab1]

Hi all,

How can we identify if who are the users/phones that has an activated DND? is it on the dndstatus, if the value is true?

From the sample query i got. The tkdndoption is 2, tkringsetting_dnd is null, and dndstatus is t

Appreciate if you can help us on properly interpret this values so that we can discuss/relay it to the customer who is asking the information. 

Thank you so much,

Kier