How can we find on which devices a BLF is programmed

Unanswered Question
Apr 20th, 2010

Hi,

Is there a way to do a search in the CUCM version 7 to find a specific number programmed as a BLF on one or multiples devices.

For example :

I configured on one device SEP000111222333 the BLF 2000.  Few month later, I do not remember on which device I programmed the BLF but I need to find it and remove it.

I did not find any way to find BLF key programmed and be able to do a dependency records.

Thanks,

I have this problem too.
0 votes
  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 5 (1 ratings)
Loading.
htluo Tue, 04/20/2010 - 19:18

Not sure if it can be done by CCMAdmin web page.

I would just go to the CUCM CLI (command line) and run the following query:

run sql select name from device where pkid in (select fkdevice from blfspeeddial where blfdestination='2000')

Substitute 2000 with any DN you want.

Michael

http://htluo.blogspot.com

peyton.gwinn Tue, 08/21/2012 - 19:04

The above query work if you are looking for number in the destination field. If you are looking for ones assigned by the the find button use this query:

run sql select name from device where pkid in (select fkdevice from blfspeeddial where fknumplan=(select pkid from numplan where dnorpattern='XXXXX' and fkroutepartition=(select pkid from routepartition where name='SomePartionName')))

where XXXXX is the DN and SomePartitionName is the name of the partition the where DN is.

Give credit where credit is due. This post help me form the above query:

http://www.gossamer-threads.com/lists/cisco/voip/126103

Actions

This Discussion