[cisco-voip] Locating devices with specific BLF numbers/destinations (CUCM 6.1)

[Ed Leatherman]

I was asked recently to figure out how to come up with a list of
phones that had a particular BLF on them. The dependency records in CM
don't appear to provide this type of information so I started plunking
around with some SQL statements to do this (see below). Figured it
might be useful for someone else, and also I'm curious if anyone knows
of a better way to find this information. In particular we would use
this information either to track these down for removal from a phone
or for updating labels. I will also be the first to admit that my SQL
skills are not the best.

For BLF's programmed using the simple destination field:

> run sql select fkdevice from blfSpeedDial where blf destination = "<number here>"
then for each pkid returned:
> run sql select name, description from Device where pkid = "<fkdevice from previous results>"

For the ones setup using the Directory Number find button instead, its
more onerous:
get pkid for partition > run sql select pkid from routepartition where
name ="<partition name>"
get pkid for the DN > run sql select pkid from numplan where
DnOrPattern="<DN Number>" and fkroutepartition="<pkid for partition>"
get BLFs now > run sql select fkdevice from blfSpeedDial where
fknumplan = "<pkid for DN>"
then as above to actually identify the device in some useful format >
run sql select name, description from Device where pkid = "<fkdevice>"

Any better way to go about this that i'm missing? The other solution I
guess is to go back to our internal customers and tell them to find
all the phones with the BLFs that they need changed. This generally
gets us incomplete information though.

--
Ed Leatherman