How to get DeviceName from Directory Number with AXL API

Version 1
    This document was generated from CDN thread

    Created by: Matthias FUZEAU on 19-09-2008 09:01:08 AM
    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.

    Subject: Re: How to get DeviceName from Directory Number with AXL API
    Replied by: Matthias FUZEAU on 23-09-2008 01:51:39 PM
    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%'