Is there a way to search programed BLF's

[jgerdes@ucmo.edu]

I'm on CUCM 12.5.1, getting ready to update to 14.0.1. but I'm needing to search the system for any BLF appearances with a EXT. I've looked at dependency records and I'm missing something. is there a way to look these items up?

[stuartschwarzman]

You can do an export of the phone's specific configuration.

1)Bulk Administration>Phones>Export Phones>All Details

2)Do your search from within the CSV files--- 

Thanks

[Roger Kallberg]

You could run these two queries to find BLF's that are created to monitor a specific DN,

select d.name, d.description, blf.blfindex, blf.label, blf.blfdestination
from blfspeeddial as blf
inner join device as d on blf.fkdevice=d.pkid where blfdestination like '<directory number>'

run sql select d.name, d.description, blf.blfindex, blf.label, blf.blfdestination from blfspeeddial as blf inner join device as d on blf.fkdevice=d.pkid where blfdestination like '<directory number>'


select name
from device
where pkid in (select fkdevice from blfspeeddial
where fknumplan=(select pkid from numplan
where dnorpattern='<directory number>'
and fkroutepartition=(select pkid from routepartition where name='<PT name>')))

run sql select name from device where pkid in (select fkdevice from blfspeeddial where fknumplan=(select pkid from numplan where dnorpattern='<directory number>' and fkroutepartition=(select pkid from routepartition where name='<PT name>')))

[jgerdes@ucmo.edu]

Is there a way for a minor admin to look for these items? They don't have access to the bulk admin section. I'm asking as I don't know and I've been asked.

[stuartschwarzman]

Permissions are set by the Administrator.  You'll need to ask that individual but yes it is possible.