Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
VIP Purple

SQL Query to find DN and phone Load

Hi All,

We are using Call Manager 8.6 [one PUB and 4 SUBs] and have different IP phone models .

IP phone model have different LOAD working with them like few 3905 have cmterm-3905.9-2-2-0 while some have cmterm-3905.9-2-2ES7 .

Is there any way/SQL Query  to find out what all phone model with DN are running 3905.9-2-2.0 LOAD?

regds,

aman

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
Hall of Fame Super Red

Hey Aman, Hope all is well my

Hey Aman,

 

Hope all is well my friend!

 

Just to add a note to my friend Carlo's good info here (+5!)

 

Try;

 

Device> Device Settings> Firmware Load Information>Device Not Using Default Load

 

This will show you any phones that deviate from the "device defaults" Fimware And if you click

on any device listed here it will show the actual Firmware that is being used on the specified device.

 

Cheers!

Rob

Hi Aman.you can also try run

Hi Aman.

you can also try run sql select d.name, d.specialloadinformation, d.description, n.dnorpattern as DN from device as d,numplan as n, devicenumplanmap as dnpm where dnpm.fkdevice = d.pkid and dnpm.fknumplan = n.pkid and d.tkclass = 1 and d.specialloadinformation != '' and d.tkmodel = '592'

which means, give me all 3905 which has "Load Information" field NOT empty and tell me what is written there :)

 

 

HTH

 

Regards

 

Carlo

Please rate all helpful posts "The more you help the more you learn"
9 REPLIES

Hi Aman.Because cmterm-3905.9

Hi Aman.

Because cmterm-3905.9-2-2-0 is the default load, other phone running different load should have "Load Information" field filled out on phone configuration page.

With the below query, we get all 3905 phones with that field blank (the db field is specialloadinformation)

 

Try this query

run sql select d.name, d.description, n.dnorpattern as DN from device as d,numplan as n, devicenumplanmap as dnpm where dnpm.fkdevice = d.pkid and dnpm.fknumplan = n.pkid and d.tkclass = 1 and d.specialloadinformation = '' and d.tkmodel = '592'

 

 

HTH

 

Regards

 

Carlo

Please rate all helpful posts "The more you help the more you learn"
VIP Purple

Hi Carlo, thanks for the

Hi Carlo,

 

thanks for the reply.

 

Let me check tomorrow.I will get back to you.

 

regds,

aman

VIP Purple

Hi Carlo, [+5] I checked the

Hi Carlo, 

[+5] 

I checked the same.

 

But my query was to find out different loads being used by same IP phone model.when I run the query , entering load I get no output related to 3905 Specific LOAD

run sql select d.name, d.description, n.dnorpattern as DN from device as d,numplan as n, devicenumplanmap as dnpm where dnpm.fkdevice = d.pkid and dnpm.fknumplan = n.pkid and d.tkclass = 1 and d.specialloadinformation = 'CP3905.9-2-2-0' and d.tkmodel = '592'

 

or 

 

run sql select d.name, d.description, n.dnorpattern as DN from device as d,numplan as n, devicenumplanmap as dnpm where dnpm.fkdevice = d.pkid and dnpm.fknumplan = n.pkid and d.tkclass = 1 and d.specialloadinformation = 'CP3905.9-2-2ES7' and d.tkmodel = '592'

 

If I leave the specialloadinformation as blank, I get all 3905 IP phones.

Please advise how can I get this info.

regds,

aman

Hi Aman.you can also try run

Hi Aman.

you can also try run sql select d.name, d.specialloadinformation, d.description, n.dnorpattern as DN from device as d,numplan as n, devicenumplanmap as dnpm where dnpm.fkdevice = d.pkid and dnpm.fknumplan = n.pkid and d.tkclass = 1 and d.specialloadinformation != '' and d.tkmodel = '592'

which means, give me all 3905 which has "Load Information" field NOT empty and tell me what is written there :)

 

 

HTH

 

Regards

 

Carlo

Please rate all helpful posts "The more you help the more you learn"
VIP Purple

Sure Carlo. I would try this

Sure Carlo.

 

I would try this as well and update u.

 

regds,

aman

Thanks Aman....and +5 to my

Thanks Aman.

...and +5 to my friend Rob!

Long time :)

 

Cheers

Carlo

Please rate all helpful posts "The more you help the more you learn"
VIP Purple

thanks to dear Rob and Carlo.

thanks to dear Rob and Carlo.

 

regds,

aman

Hall of Fame Super Red

Hey Aman, Hope all is well my

Hey Aman,

 

Hope all is well my friend!

 

Just to add a note to my friend Carlo's good info here (+5!)

 

Try;

 

Device> Device Settings> Firmware Load Information>Device Not Using Default Load

 

This will show you any phones that deviate from the "device defaults" Fimware And if you click

on any device listed here it will show the actual Firmware that is being used on the specified device.

 

Cheers!

Rob

VIP Purple

Sure Rob.. I will check on

Sure Rob..

 

I will check on Monday and update u.

 

regds,

aman

350
Views
20
Helpful
9
Replies
CreatePlease to create content