How to tell what phones a DN is programmed on?

[craig.pollitt]

Is there a dependency record or something that shows what phones a DN is programmed as a SD/BLF on? I can do this easily from an Ericsson MD110, however I haven't found an equivalency in CallManager for this.

Thanks.

[Kid Dynamite]

Try "Route Plan Report"

This should tell you. ; )

[craig.pollitt]

This shows what phones a number is programmed as a DN, however it doesn't list the phones that have it programmed as a SD/BLF (unless I'm still overlooking it).

Thanks.

[jake-savage]

What version of Callmanager? Could try using the dependency records.

[craig.pollitt]

CallManager 6.1.2.1000-13. I looked at what was listed in the dependency records and it only reflects those instruments that have the number assigned as a DN...it does not show phones that have that number as a SD or BLF. That's the info I'm after.

[craig.pollitt]

CallManager 6.1.2.1000-13. I looked at what was listed in the dependency records and it only reflects those instruments that have the number assigned as a DN...it does not show phones that have that number as a SD or BLF. That's the info I'm after.

[shabali52]

route...Route plan report should tell you that.

[Jaime Valencia]

that info is not reflected in any report, you would need to try looking with the data dictionary to create a query that could show you that, it does not show as any dependency record as you could only have a button template but no BLF configured

if you do not want to go with the QRY then look at the button template, use dependency records and look into any phone that has that template and do it manually

there is no easy way to get that info

HTH

java

if this helps, please rate

[craig.pollitt]

Ok, I'm looking at the data dictionary and have no idea what I'm supposed to do or where to do it. Let's say I actually right a structured query that finds what I'm looking for, where am I supposed to run the query? Does anyone have some insight they could share?

The closest thing I can come up with is that I'm looking for information contained in the blfspeeddial table (350), after that I'm completely lost.

Thanks.

[Jaime Valencia · Accepted solution]

as i mentioned, there is no easy way to try getting this information

you run qrys from CLI

run sql

http://www.cisco.com/en/US/docs/voice_ip_comm/cucm/cucos/6_1_1/cucos/iptpappa.html#wp1052698

run a qry on that table and see what info it contains, most probably it's the one and you will need to join it with the device table to get the info

HTH

java

if this helps, please rate

[craig.pollitt]

Here's how I resolved my issue--

Find the Unique Identifier for the DN you are looking up:

admin:run sql SELECT pkid FROM numplan WHERE dnorpattern = "xxxxx"

-returns the value-

[pkid_STRING]

Find the Devices that that DN is programmed on and other information:

run sql SELECT * FROM blfspeeddial WHERE fknumplan = "pkid_STRING"

-returns the values-

[OTHER_STRING],[LABEL],[DEVICE_STRING],[Button # is programmed on]

(-or if you just want a list of devices-

run sql SELECT fkdevice FROM blfspeeddial WHERE fknumplan = "pkid_STRING")

To find the phones the # is programmed on, using the Description field for the device:

run sql SELECT description FROM device WHERE pkid = "DEVICE_STRING"

-returns the value-

[DESCRIPTION] / or in our case, the phone that has the original # programmed on.

Thanks to java for pointing me down the right path.

Craig

[Jaime Valencia]

also thank you Craig, for posting out the way you figured out this and also the qrys you made for it, i'm pretty sure many will find them useful

+5 for you buddy

java

[Rob Huffman]

Hi Craig,

I agree with my friend Java! +5 points for this great info that will certainly help someone else in the future. Great work :)

Thanks again,

Rob