SOAPUI AXL toolkit 11.5 showing calls made and received

[softwareguy]

Hi all,

I would like get the details from CUCM page using SOAPUI about a given persons call history using AXLtoolkit SOAP API 11.5 I would like to be able to retrieve calls made and received.

Can anyone please suggest or even better show an example of what request using the 11.5 toolkit I should use to load a given users call history. 

thank you in advance for any help, it is much appreciated. 

[softwareguy]

I would like get the details from CUCM page using SOAPUI about a given persons call history using AXLtoolkit SOAP API 11.5 I would like to be able to retrieve calls made and received.

Can anyone please suggest or even better show an example of what request using the 11.5 toolkit I should use to load a given users call history. 

thank you in advance for any help, it is much appreciated. 

[OSPMMeyer]

I'm note sure if you can do that over the AXL API.

But you can do it with a SSH connection on your cucm server.

Example (on cucm terminal):

run sql car select callingpartynumber, lastredirectdn, destdevicename, datetimestampconnect, datetimestampdisconnect, datetimestamporigination, originalcalledpartypattern from tbl_billing_data where (lastredirectdn like '%PHONENUMBER' or callingpartynumber like '%PHONENUMBER') 

Gives you all ingoing / outgoing calls for a specific phone number. note that the CAR database only saves the call data for 3 months.

[softwareguy]

Thank you for the reply OSPMMeyer, could I do this via the toolkit using executeSQLQuery?

such as this:

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns="http://www.cisco.com/AXL/API/11.5"> 
  <soapnv:Header/>
  <soapnv:Body>
    <ns:executeSQLQuery>
      <sql>
        SELECT
                    callingpartynumber, 
                    lastredirectdn,
                    destdevicename,
                    datetimestampconnect,
                    datetimestampdisconnect,                                                                                                    
                    datetimestamporigination, 
                    originalcalledpartypattern
        FROM
                    tbl_billing_data
        WHERE
                    %PHONENUMBER
      </sql>
    </ns:executeSQLQuery>
  </soap:Body>
</soap:Envelope>

As i jsut tried above and could not get it to work in soapui, sorry i am restricted at the moment to SOAPUI

thank you for replies. 

[softwareguy]

Sorry for the shameless bump but can anyone help at all?