HP Intelligent Management Center Extended API User Guide

Query SQL Statements
Query database based on component ID and SQL statement.
Interface URI
/sql
Access Method
HTTP
GET
Parameters
Query parameter
Component ID.componentId
String type. Required. No default value.
Query SQL statements.sql
String type. Required. No default value.
Returned Result
Status codes
• 200 (OK): Success.
Message header
HTTP/1.1 200 OK
Total: 7
Message body
<sqlResult total="1000">
<record type="string">
<value>1.0.8802.1.1.2.0.6.1</value>
<value>1.0.8802.1.1.2.0</value>
<value>6</value>
<value>1</value>
<value>Neighbor information has changed.</value>
<value>0</value>
<value>4</value>
<value>0</value>
<value>0</value>
<value>1</value>
<value />
<value>Neighbor information has changed. </value>
<value />
<value>0</value>
<value>0</value>
<value />
<value>Status of the neighboring device changed, such as link up, link down, or port change.</value>
</record>
...
</sqlResult>
Query SQL Statements 175