How can I discover which lines are set for recording via AXL?

[markelb]

I'm trying to generate a report of phones setup for recording.  In the admin pages I can navigate to a Recording Profile and click Dependency Records.  This output shows me all the directory numbers using this recording profile.

Can I retrieve this information with an AXL request?  Alternatively, something that would give me a list of directory numbers that have "recordingFlag" set to something other than "Call Recording Disabled" would do.

Running a getPhone query will output information about a particular phone, including the line's recording option setting.

Sample output edited for brevity:

<?xml version='1.0' encoding='UTF-8'?>

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">

    <soapenv:Body>

        <ns:getPhoneResponse xmlns:ns="http://www.cisco.com/AXL/API/11.5">

            <return>

                <phone ctiid="8" uuid="{F111FEFB-483B-8E76-149F-EC750FDC9B71}">

                    <name>SEP7081050CAAAA</name>

                    <description>test phone</description>

                    <product>Cisco 8941</product>

....

                    <lines>

                        <line uuid="{33EB3561-8CFD-973D-4FA4-0C0F1FF9B125}">

                            <index>1</index>

                            <label>Brad 88045</label>

                            <display>Brad</display>

....

                            <recordingProfileName uuid="b9e70b75-6f35-661f-390b-691b92ad3894">RecordingProfile-markelb</recordingProfileName>

                            <monitoringCssName/>

                            <recordingFlag>Call Recording Disabled</recordingFlag>

                        </line>

                    </lines>

                </phone>

            </return>

        </ns:getPhoneResponse>

    </soapenv:Body>

</soapenv:Envelope>

Obviously running a getPhone query on every phone in the cluster isn't ideal.  Using listLine won't give me the detail I'm looking for.  Does anyone have a suggestion?

If I can't get anywhere with a specific AXL request I'll work towards crafting a SQL query.

[Vladislav Vyakin]

I think yuo need something like that

SELECT np.dnorpattern,trf.name rname,rp.name pname FROM  NumPlan np

LEFT JOIN DeviceNumPlanMap dnpm ON np.pkid=dnpm.fknumplan

LEFT JOIN recordingdynamic rd ON rd.fkdevicenumplanmap=dnpm.pkid

LEFT JOIN typerecordingflag trf ON trf.enum=rd.tkrecordingflag

LEFT JOIN recordingprofile rp ON rp.pkid=dnpm.fkrecordingprofile

WHERE NOT (rp.name IS NULL)

You can ran it as AXL or just from ssh console run sql ...