SQL request for Cisco Callmanager 11.5 which gives result with next rows Device Name, Description, Device Type, Device Protocol, Statusand IPv4 Address

[softserveinc]

Hello,

I need sql request for Cisco Callmanager 11.5 which gives result with next rows Device Name, Description, Device Type, Device Protocol, Statusand IPv4 Address similar like Device -> Phone on Callmanager's web page.

Maybe somebody has the same task and help me with it?

Thank you in advance.

[Rajan]

YOu could try "show risdb query phone" and save the output as a csv file.

HTH

Rajan

[softserveinc]

Rajan,

I need to do sql request via axl.

For example

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns="http://www.cisco.com/AXL/API/11.5">
  <soapenv:Header/>
  <soapenv:Body>
    <ns:executeSQLQuery sequence="?">
       <sql>select * from device</sql>
    </ns:executeSQLQuery>
  </soapenv:Body>
</soapenv:Envelope>`

Thank you.