cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Announcements

Cisco Community Designated VIP Class of 2020

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

1465
Views
0
Helpful
1
Comments

 

 

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
Explorer

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

CreatePlease to create content
Content for Community-Ad
FusionCharts will render here