Hi,
Kindly use AXL to fetch the Device names associated to a particular DN.
Using the ExecuteSQLQuery Thin API.
Sending message...
-----
<!-- edited with XMLSPY v5 rel. 4 U (
http://www.xmlspy.com) by Jerry Vander Voord (Cisco Systems) -->
<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/">
<SOAP-ENV:Body>
<axlapi:executeSQLQuery sequence="1" xmlns:axlapi="http://www.cisco.com/AXL/API/7.0" xmlns:axl="http://www.cisco.com/AXL/7.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.cisco.com/AXL/API/7.0 axlsoap.xsd">
<sql>SELECT D.Name || '=' || DNPMap.BusyTrigger FROM NumPlan NP , DeviceNumPlanMap DNPMap , Device D WHERE NP.DNorPattern = '197999' AND DNPMap.fkNumPlan = NP.pkid AND D.pkid = DNPMap.fkDevice</sql>
<!--<sql>Select device.name as phonename,devicepool.name as devicepoolname from device,devicepool where device.fkdevicepool=devicepool.pkid and device.tkclass=1</sql>-->
</axlapi:executeSQLQuery>
</SOAP-ENV:Body>
</SOAP-ENV:Envelope>
-----
Added SSL_PROVIDER com.sun.net.ssl.internal.ssl.Provider
Positive response received.
-----
<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/"><SOAP-ENV:Header/><SOAP-ENV:Body><axl:executeSQLQueryResponse xmlns:axl="http://www.cisco.com/AXL/API/6.1" xmlns:xsi="http://www.cisco.com/AXL/API/6.1" sequence="1"><return><row><expression>SEP333333333333=2</expression></row><row><expression>SEP666666666666=2</expression></row></return></axl:executeSQLQueryResponse></SOAP-ENV:Body></SOAP-ENV:Envelope>
HTH
Thanks and Regards,
Madhukar