Query sql statements, Interface uri, Access method – HP Intelligent Management Center Licenses User Manual
Page 175: Returned result, Interface uri access method returned result
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