Available in VPC
Get the list of Cloud DB for MSSQL log files.
Commands
The command statement is as follows.
ncloud vmssql getCloudMssqlLogFileList [regionCode] [cloudMssqlInstanceNo] [cloudMssqlServerInstanceNo] [fileType] [output]
Parameter
The following describes the parameters.
Parameter | Type | Required | Description | Restrictions |
---|---|---|---|---|
regionCode | String | N | Region code
|
- |
cloudMssqlInstanceNo | String | Y | Cloud DB for MSSQL instance number to find log files
|
- |
cloudMssqlServerInstanceNo | String | Y | Cloud DB for MSSQL server instance number to find log files
|
- |
fileType | String | Y | Log file type
|
- |
output | String | N | Respond result's format type
|
- |
Response
Response data type
- CloudMssqlLogFileList type
CloudMssqlLogFileList extends CommonResponse | Description |
---|---|
private Integer totalRows; | Total number of lists searched |
private List<CloudMssqlLogFile> cloudMssqlLogFileList = new ArrayList<>(); | Cloud DB for MSSQL log file list |
- CloudMssqlLogFile type
CloudMssqlLogFile | Description |
---|---|
private String fileName; | Database server log file name |
private Long fileSize; | Database server log file size |
private Date fileDate; | Date and time when database server log file was modified |
Examples
It describes call and response examples.
Call examples
The following is a call example.
ncloud vmssql getCloudMssqlLogFileList --regionCode KR --cloudMssqlInstanceNo ******2 --cloudMssqlServerInstanceNo *******3 --fileType errorLog
Response example
The following is a sample response.
When the response result format type (output) is JSON
{
"getCloudMssqlLogFileListResponse": {
"requestId": "d5e980a0-15b5-4c77-8b12-a70b8673142c",
"returnCode": 0,
"returnMessage": "success",
"totalRows": 1,
"cloudMssqlLogFileList": [
{
"fileName": "ERRORLOG",
"fileSize": 100000,
"fileDate": "2022-12-11T06:30:09+0900"
}
]
}
}
When the response result format type (responseFormatType) is XML
<getCloudMssqlLogFileListResponse>
<requestId>d5e980a0-15b5-4c77-8b12-a70b8673142c</requestId>
<returnCode>0</returnCode>
<returnMessage>success</returnMessage>
<totalRows>1</totalRows>
<cloudMssqlLogFileList>
<cloudMssqlLogFile>
<fileName>ERRORLOG</fileName>
<fileSize>100000</fileSize>
<fileDate>2022-12-11T06:30:09+0900</fileDate>
</cloudMssqlLogFile>
</cloudMssqlLogFileList>
</getCloudMssqlLogFileListResponse>