Administration XML Developer Forums

« Back to Administration XML Questions

How to get DeviceName from Directory Number with AXL API

Combination View Flat View Tree View
Threads [ Previous | Next ]
How to get DeviceName from Directory Number with AXL API
Answer
9/19/08 2:01 PM
Hello

I need to be able to get the DeviceName of a phone (SEP prefix followed by the MAC Address) from the Directory Number. And I also need to do this by using the AXL API and SOAP protocol.

I have access to all the functions provided by AXL but I can't find the one I need.

Can anyone give me the correct function if it exists or give me the equivalent SQL query ?

Thanks you in advance

Best regards.
Flag

Re: How to get DeviceName from Directory Number with AXL API
Answer
9/23/08 6:51 PM as a reply to Matthias FUZEAU.
OK, I found the answer in another thread.

Here's the SQL query to use with the ExecuteSQLQuery function :

SELECT D.Name FROM NumPlan NP , DeviceNumPlanMap DNPMap, Device D WHERE NP.DNorPattern = 'myTelephoneNumber' AND DNPMap.fkNumPlan = NP.pkid AND D.pkid = DNPMap.fkDevice and D.Name like '%SEP%'
Flag