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

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

New Member

query to find DNs not associated to a button

anyone know a sql query I could run on CUCM 6.1 to list DNs that aren't associated to a button? I'm trying to generate a list of phones that are using an incorrect button template.

3 REPLIES
Cisco Employee

Re: query to find DNs not associated to a button

Route Plan report already has an unassigned DNs option for this

HTH

java

If this helps, please rate

www.cisco.com/go/pdihelpdesk

HTH

java

if this helps, please rate

www.cisco.com/go/pdi
New Member

Re: query to find DNs not associated to a button

The unassigned DN doesn't give this information.  We did a bulk import and discovered several instances where the template was set incorrectly. The DN shows up on the devices as an "Unassigned Associated Item". If we change the phone button template, the DN is listed properly.

Re: query to find DNs not associated to a button

You can run the Route Plan Report for Unassigned DNs. In CUCM admin, go to Call Routing > Route Plan Report. Change Find to Unassigned DN and click Find.

Hope this helps.

Brandon

234
Views
0
Helpful
3
Replies