IBM Tivoli Monitoring > Version 6.3 Fix Pack 2 > Administrator's Guide > Agent-based services > Agent Service Interface > Agent Service Interface - Service Interface Request

IBM Tivoli Monitoring, Version 6.3 Fix Pack 2

---

Agent Service Interface request - History report

Create a service interface <HISTREAD> request to start, stop, or recycle a private situation on the monitoring agent.

Historical data from Tivoli Enterprise Monitoring Agents is displayed in the Tivoli Enterprise Portal when you select a time span for a table view or other query-based view. Outside the portal, you can see historical data from an enterprise monitoring agent or private history data from an enterprise monitoring agent or system monitor agent by getting a History report from the Agent Service Interface or by creating a HISTREAD service interface request.

Request input

Agent Service Interface <HISTREAD> request.

Tag	Description
<HISTREAD>	Retrieve history table data
<SQLTABLE>	Identify SQL table definition set.
<TABLENAME>	Defines table name bracketed by begin and end tags. Maximum table name consists of 10 characters.
<PVTHIST>	Optional. Specify reading private history. No direct agent to read enterprise short term history
<OUTPUT>	Optional. Define output table column selection.
<COLUMN>	Optional. Define selected column name bracketed by begin and end tags.
<FILTER>	Optional. Define output data rows filter criteria bracketed by begin and end tags. See Private Situation <CRITERIA> specification for details. Use from and to WRITETIME column to specify history data read range. Use ORIGINNODE column to select specific MSN history data
<OUTLIMIT>	Optional. Define the output record limit bracketed by begin and end OUTLIMIT tags to safeguard against to much output volume.

Sample request 1: Get Windows OS agent Process history data using filter and column selections

<HISTREAD>
 <SQLTABLE>
  <TABLENAME>NTPROCESS</TABLENAME>
 <OUTPUT>
  <COLUMN>ORIGINNODE</COLUMN>
  <COLUMN>TIMESTAMP</COLUMN>
  <COLUMN>INSTCNAME</COLUMN>
  <COLUMN>IDPROCESS</COLUMN>
  <COLUMN>PCTPRCSTME</COLUMN>
  <COLUMN>THREADCNT</COLUMN>
  <COLUMN>WRKINGSET</COLUMN>
 </OUTPUT>
 <FILTER>
  <![CDATA[ *VALUE ORIGINNODE *EQ Primary:DYANG3:NT  *AND
   *VALUE WRITETIME  *GE 1090408224500000  *AND 
   *VALUE WRITETIME  *LE 1090408234500000]]>
 </FILTER>
 <OUTLIMIT>5000</OUTLIMIT>
 </SQLTABLE>
</HISTREAD>

Report output

Agent Service Interface <HISTREAD> request output.

Output tag	Description
<HISTREADDATA>	Identify output report data set.
<STATUS>	Return status code bracketed by begin and end tag
<ROWCOUNT>	Output table row count
<ROW>	Identify an output row data
<NAME>	Define output column name enclosed by begin and end tags.
<DATA>	Specify output column data value enclosed by begin and end tags.

Sample output 1: The Windows OS agent returns Process history data for the seven specified attributes on April 8 from 10:45 PM to 11:45 PM

<HISTREADDATA>
 <SQLTABLE>
   <TABLENAME>NTPROCESS</TABLENAME> 
   <ROWCOUNT>212</ROWCOUNT> 
  <ROW>
   <COLUMN>
    <NAME>ORIGINNODE</NAME> 
    <DATA><![CDATA[Primary:DYANG3:NT]]></DATA>
   </COLUMN>
   <COLUMN>
    <NAME>TIMESTAMP</NAME> 
    <DATA><![CDATA[1090408224551430]]></DATA>
   </COLUMN>
   <COLUMN>
    <NAME>INSTCNAME</NAME> 
    <DATA>![CDATA[Idle]]> </DATA>
    </COLUMN>
   <COLUMN>
    <NAME>IDPROCESS</NAME> 
    <DATA>0</DATA> 
   </COLUMN>
   <COLUMN>
    <NAME>PCTPRCSTME</NAME> 
    <DATA>74</DATA> 
    </COLUMN>
   <COLUMN>
    <NAME>THREADCNT</NAME> 
    <DATA>1</DATA> 
   </COLUMN>
   <COLUMN>
    <NAME>WRKINGSET</NAME> 
    <DATA>16384</DATA> 
   </COLUMN>
  </ROW>
  ... 
  ...
 </SQLTABLE>
</HISTREADDATA>

Parent topic:

Agent Service Interface - Service Interface Request

---

+

Search Tips   |   Advanced Search