getCloudMysqlEventHistoryList

Article summary

Did you find this summary helpful?

Thank you for your feedback

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>

Was this article helpful?

What's Next

getCloudMysqlImageProductList

Table of contents

Commands
Response
Examples