04-20-2010 05:49 PM - edited 03-15-2019 10:22 PM
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,
04-20-2010 07:18 PM
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
06-03-2011 05:20 AM
Hi
I run this commend but it did not seem to work ?
08-21-2012 07:04 PM
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:
05-24-2019 10:29 AM
Don't know how I missed the post before but thanks! Performing bulk lookups/updates for speed dials and SD-BLFs is an incredible burden. I have seen various other posts suggesting bulk export/import or other SQL or AXL commands but none of those are practical for a low-level telephone admin.
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide