ā09-21-2017 04:07 PM
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.
ā09-22-2017 03:26 AM
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 ...
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide