HP Intelligent Management Center Licenses - Manual (Page 176)

Element description
sqlResult sub-elements and attributes
Total records. @total
Long integer type.
Result records. record
Element type.
Field type. record/@type
String type. The value can only be string.
Field value. record/value
String type.
Example
Query the component iMC-NME-FAULT and SQL statement SELECT * FROM tbl_trap_conf in the
database.
Request
GET http://localhost:8080/imcrs/sql?componentId=iMC-NME-FAULT&sql=SELECT * FROM tbl_trap_conf
accept: application/xml
...
Response
HTTP/1.1 200 OK
Content-Type: application/xml
...
<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 changed</value>
<value>0</value>
<value>4</value>
<value>0</value>
<value>0</value>
<value>1</value>
<value />
<value>Neighbor information changed </value>
<value />
<value>0</value>
<value>0</value>
<value />
<value>Status of the neighbor changed, such as link up, link down, or port change.</value>
</record>
...
</sqlResult>
176 Network Resource Management