1.8.9 Acquiring event information in CSV format

This section explains the format of requests that are used to output event information in CSV format, and the contents to be specified for the request body.

Procedure

1. Issue a request in the following format:

   POST http://host:port/Analytics/version/services/Events/actions/getEventDataCSV/invoke

   The object to be specified as the member of parameters in the request body is as follows:

   Table 1‒10: Members that can be specified when acquiring the CSV file for the event information

   Member to change	Whether the change is required	Description
   hqlFilter	Optional	Specify the formula if you want to filter the event to be acquired. Describe the formula in the order of parameter + operator + value. The values that can be specified for the formula are shown in the following table. You can combine expressions with AND or OR.
   fqlSort	Optional	Specify this member to sort the events to be acquired.
   page	Optional	Specify the number of pages to be acquired.
   pageSize	Optional	Specify the number of items to be acquired for a single page.

   Table 1‒11: Parameters that can be specified for hqlFilter

   Parameters	Operators	Values
   status	eq, ne	NOTACK, ACK
   level	eq, ne	INFO, WARNING, CRITICAL
   category	eq, ne	PERFORMANCE, STATUS,EVENT, SETTING, CHANGE
   deviceName	eq, ne, starts, ends, contains	Any character string
   deviceType	eq, ne	Server, Storage, NetworkDevice, Collector
   componentName	eq, ne, starts, ends, contains	Any character string
   componentType	eq, ne	CPU,MEMORY, LAN_PORT, FC_HBA_PORT, [DISK_DRIVE, SCSI_DISK_DRIVE], [STORAGE_CONTROLLER, STORAGE_MPB], STORAGE_FC_PORT, STORAGE_POOL, STORAGE_VOLUME, STORAGE_CACHE, VIRTUAL_MACHINE, HYPERVISOR_CLUSTER, STORAGE_DP_POOL
   userName	eq, ne, starts, ends, contains	Any character string

To Page Top