getCloudMysqlEventHistoryList

Prev Next

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 -
cloudMysqlServerName String Y Cloud DB for MySQL server name -
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>