SQL Query to find DN and phone Load

[Aman Soi]

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

[Carlo Poggiarelli]

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

[Aman Soi]

Hi Carlo,

thanks for the reply.

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

regds,

aman

[Aman Soi]

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

[Carlo Poggiarelli · Accepted solution]

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

[Aman Soi]

Sure Carlo.

I would try this as well and update u.

regds,

aman

[Carlo Poggiarelli]

Thanks Aman.

...and +5 to my friend Rob!

Long time :)

Cheers

Carlo

[Aman Soi]

thanks to dear Rob and Carlo.

regds,

aman

[Rob Huffman · Accepted solution]

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

[Aman Soi]

Sure Rob..

I will check on Monday and update u.

regds,

aman