query to find DNs not associated to a button

Unanswered Question
Dec 16th, 2009

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.

I have this problem too.
0 votes
  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Loading.
chris.warren Wed, 12/16/2009 - 07:21

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.

Brandon Buffin Wed, 12/16/2009 - 07:18

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

Actions

This Discussion