Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 

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

 

 

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

 

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

 

Comments
New Member

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

755
Views
0
Helpful
1
Comments