getCloudMysqlEventHistoryList

The latest service changes have not yet been reflected in this content. We will update the content as soon as possible. Please refer to the Korean version for information on the latest updates.

Available in VPC

Get the event history list for a Cloud DB for MySQL instance.

Commands

The command statement is as follows.

ncloud vmysql getCloudMysqlEventHistoryList [regionCode] [cloudMysqlServerName] [startDate] [endDate] [pageNo] [pageSize] [output]

Parameter

The following describes the parameters.

Parameter	Type	Required	Description	Restrictions
regionCode	String	N	Region code where the Cloud DB for MySQL instance exists IIt can be obtained through the getRegionList action Default: Select the first Region of the getRegionList query result	-
cloudMysqlServerName	String	Y	Cloud DB for MySQL server name It can be obtained through the getCloudMysqlInstanceList action	-
startDate	String	Y	Query start date Query start date format: yyyy-MM-dd HH:mm:ss <e.g.> `2024-01-01 00:00:00`	-
endDate	String	Y	Query end date Query end date format: yyyy-MM-dd HH:mm:ss <e.g.> `2024-12-31 23:59:59`	-
pageNo	Integer	N	Page numbers in paged results Page the result values using `pageNo` and `pageSize` 0 (default)	Min: 0
pageSize	Integer	N	Number of results to display on a page Page the result values using `pageNo` and `pageSize` 20 (default)	Min: 1
output	String	N	Respond result's format type Options: xml \| json Default: json	-

Response

Response data type

The response data types for command calls are as follows.

CloudMysqlEventHistoryList type

CloudMysqlEventHistoryList extends CommonResponse	Description
private Integer totalRows;	Total number of lists searched
private List<CloudMysqlEventHistory> cloudMysqlEventHistoryList = new ArrayList<>();

CloudMysqlEventHistory type

CloudMysqlEventHistory	Description
private String cloudMysqlInstanceNo;	Cloud DB for MySQL instance number
private String cloudMysqlServerInstanceNo;	Cloud DB for MySQL server instance number
private String cloudMysqlServerName;	Cloud DB for MySQL server name
private String eventTime;	Time when event occurred
private String eventType;	Event type
private String eventName;	Event name
private String eventContent;	Event content
private String clientIp;	Access IP

Examples

It describes call and response examples.

Call examples

The following is a call example.

ncloud vmysql getCloudMysqlEventHistoryList --regionCode KR --cloudMysqlServerName abcd --startDate '2024-08-13 17:00:00' --endDate '2024-08-13 17:00:00' --pageNo 0 --pageSize 10

Response example

The following is a sample response.

When the response result format type (output) is JSON

{
  "getCloudMysqlEventHistoryListResponse": {
    "totalRows": 2,
    "cloudMysqlEventHistoryList": [
      {
        "cloudMysqlInstanceNo": "****890",
        "cloudMysqlServerInstanceNo": "****891",
        "cloudMysqlServerName": "abcd-001-****",
        "eventTime": "2024-08-13 17:10:00",
        "eventType": "DB Server",
        "eventName": "DB",
        "eventContent": "DB start",
        "clientIp": "10.x.x.x"
      },
      {
        "cloudMysqlInstanceNo": "****890",
        "cloudMysqlServerInstanceNo": "****891",
        "cloudMysqlServerName": "abcd-001-****",
        "eventTime": "2024-08-13 17:20:00",
        "eventType": "DB Server",
        "eventName": "DB",
        "eventContent": "Change Spec MySQL Completed",
        "clientIp": "10.x.x.x"
      }
    ],
    "requestId": "36cc2f85-****-****-****-5d2511df4e45",
    "returnCode": "0",
    "returnMessage": "success"
  }
}

When the response result format type (output) is XML

<?xml version="1.0" encoding="UTF-8"?>
<cloudMysqlEventHistoryList>
    <requestId>36cc2f85-****-****-****-5d2511df4e45</requestId>
    <returnCode>0</returnCode>
    <returnMessage>success</returnMessage>
    <totalRows>2</totalRows>
    <cloudMysqlEventHistoryList>
        <CloudMysqlEventHistory>
            <cloudMysqlInstanceNo>****890</cloudMysqlInstanceNo>
            <cloudMysqlServerInstanceNo>****891</cloudMysqlServerInstanceNo>
            <cloudMysqlServerName>abcd-001-****</cloudMysqlServerName>
            <eventTime>2024-08-13 17:10:00</eventTime>
            <eventType>DB Server</eventType>
            <eventName>DB</eventName>
            <eventContent>DB start</eventContent>
            <clientIp>10.x.x.x</clientIp>
        </CloudMysqlEventHistory>
        <CloudMysqlEventHistory>
            <cloudMysqlInstanceNo>****890</cloudMysqlInstanceNo>
            <cloudMysqlServerInstanceNo>****891</cloudMysqlServerInstanceNo>
            <cloudMysqlServerName>abcd-001-****</cloudMysqlServerName>
            <eventTime>2024-08-13 17:10:00</eventTime>
            <eventType>DB Server</eventType>
            <eventName>DB</eventName>
            <eventContent>Change Spec MySQL Completed</eventContent>
            <clientIp>10.x.x.x</clientIp>
        </CloudMysqlEventHistory>
    </cloudMysqlEventHistoryList>
</cloudMysqlEventHistoryList>

Documentation Index