Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
New Member

Possible to get phone from the DN assigned thru AXL?

Wanting to be able to get the phone(s) that a DN is assigned to via AXL. From looking over the schema, I can't see a way of doing this. Anyone got any ideas?

TIA

3 REPLIES
New Member

Re: Possible to get phone from the DN assigned thru AXL?

use the executeSQLQuery AXL method to submit the following SQL query:

select a.name from device a, numplan b, devicenumplanmap c

where c.fkdevice = a.pkid

and c.fknumplan = b.pkid

and b.dnorpattern = '30001'

replace 30001 with the DN you are interested in.

C

New Member

Re: Possible to get phone from the DN assigned thru AXL?

Great. Thanks for the info. I'll give it a go tomorrow.

cheers

New Member

Re: Possible to get phone from the DN assigned thru AXL?

There are a few other ways:

AXL Serviceability API has it

SNMP has it

And http://ciscoipphoneIP/CGI/LineInfo

173
Views
5
Helpful
3
Replies
CreatePlease to create content