getCloudMssqlLogFileList

Article summary

Did you find this summary helpful?

Thank you for your feedback

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 regionCode can be obtained through the getRegionList action Default: Select the first Region of the getRegionList query result	-
cloudMssqlInstanceNo	String	Y	Cloud DB for MSSQL instance number to find log files cloudMssqlInstanceNo can be obtained through the getCloudMssqlInstanceList action	-
cloudMssqlServerInstanceNo	String	Y	Cloud DB for MSSQL server instance number to find log files cloudMssqlServerInstanceNo can be obtained through the getCloudMssqlInstanceList action	-
fileType	String	Y	Log file type e.g., errorLog, agentLog, traceLog, auditLog, xeBaselineLog	-
output	String	N	Respond result's format type Options: xml \| json Default: json	-

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>

Was this article helpful?

What's Next

getCloudMssqlFolderList

Table of contents

Commands
Response
Examples