getCloudMssqlLogFileList
- Print
- PDF
getCloudMssqlLogFileList
- Print
- PDF
Article Summary
Share feedback
Thanks for sharing your feedback!
Available in VPC
Views a list of cloud DB for MSSQL log files.
Commands
The text of the command is as follows:
ncloud vmssql getCloudMssqlLogFileList [regionCode] [cloudMssqlInstanceNo] [cloudMssqlServerInstanceNo] [fileType] [output]
Parameter
The following is a description on parameters.
| Parameter | Type | Required | Description | Restrictions |
|---|---|---|---|---|
| regionCode | String | N | - regionCode can be obtained via the getRegionList action - default: Selects the first region of the getRegionList query results | - |
| cloudMssqlInstanceNo | String | Y | Cloud DB for MSSQL instance number for finding log files - cloudMssqlInstanceNo can be obtained via the getCloudMssqlInstanceList action | - |
| cloudMssqlServerInstanceNo | String | Y | Cloud DB for MSSQL server instance number for finding log files - cloudMssqlServerInstanceNo can be obtained via the getCloudMssqlInstanceList action | - |
| fileType | String | Y | Log file type - example: errorLog, agentLog, traceLog, auditLog | - |
| output | String | N | Format type of the response - options: xml | json - default: json | - |
Responses
Response data type
- CloudMssqlLogFileList type
| CloudMssqlLogFileList extends CommonResponse | Description |
|---|---|
| private Integer totalRows; | Total number of items viewed |
| 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 edited |
Examples
Describes examples of recalls and responses.
Recall examples
The following are examples of recalls.
ncloud vmssql getCloudMssqlLogFileList --regionCode KR --cloudMssqlInstanceNo ******2 --cloudMssqlServerInstanceNo *******3 --fileType errorLog
Response examples
The following are examples of responses.
If the response shows that 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"
}
]
}
}
If the response shows that 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>
Was this article helpful?