Viewing VPC CDB-MSSQL server list
- Print
- PDF
Viewing VPC CDB-MSSQL server list
- Print
- PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
The latest service changes have not yet been reflected in this content. We will update the content as soon as possible. Please refer to the Korean version for information on the latest updates.
View the server list that can be checked in the Cloud Log Analytics service.
Viewing VPC CDB-MSSQL server list
View the list of CDB-MSSQL server instances (VM) on the VPC platform. Paging processing is available.
Request URL
GET https://cloudloganalytics.apigw.ntruss.com/api/{regionCode}-v1/vpc/servers/mssql
Request headers
| Header name | Description |
|---|---|
| x-ncp-apigw-timestamp | Time elapsed in milliseconds since January 1, 1970, 00:00:00 UTC The request is considered invalid if the time difference compared to the API Gateway server is more than 5 minutes x-ncp-apigw-timestamp:{Timestamp} |
| x-ncp-apigw-api-key | Key value issued by APIGWx-ncp-apigw-api-key:{API Gateway API Key} |
| x-ncp-iam-access-key | Access Key ID value issued from NAVER Cloud Platform portalx-ncp-iam-access-key:{Account Access Key} |
| x-ncp-apigw-signature-v2 | Signature encrypted with the Access Key ID value and Secret Keyx-ncp-apigw-signature-v2:{API Gateway Signature} |
| Content-Type | Specifies the request body content type as application/jsonContent-Type: application/json |
Request parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
| pageNo | Integer | N | Page number ex) 1, 2 |
| pageSize | Integer | N | Page size ex) 10, 20 |
Request examples
GET https://cloudloganalytics.apigw.ntruss.com/api/{regionCode}-v1/vpc/servers/mssql?pageNo=1&pageSize=10
HOST: cloudloganalytics.apigw.ntruss.com
Content-Type: application/json
x-ncp-apigw-signature-v2: FJSBB4K3XnaGAvVe0Hzj3/2hfNWvgLHR1rQHW2Et2Rs=
x-ncp-apigw-timestamp: 1593848345548
x-ncp-iam-access-key: 11IKBWgQegM4DwiJL4mo
curl -X GET "https://cloudloganalytics.apigw.ntruss.com/api/{regionCode}-v1/vpc/servers/mssql?pageNo=1&pageSize=10"
-H "accept: application/json"
-H "x-ncp-iam-access-key: 11IKBWgQegM4DwiJL4mo"
-H "x-ncp-apigw-timestamp: 1593849262194"
-H "x-ncp-apigw-signature-v2: m/hJOfg92TqzOGyHJ++4vkimGT7un1/4+zLrLTvaVT4="
Response examples
{
"code": 0,
"message": "Your request has been processed normally",
"result": {
"pageSize": 10,
"currentPage": 1,
"totalPage": 1,
"totalCount": 1,
"isPaged": true,
"dbServers": [
{
"standbyMasterServerName": "test-cla",
"dbServerName": "test-cla",
"databaseProductCode": "SW.VDBAS.DBAAS.LNX64.CNTOS.0703.MSSQL.5729.B050",
"db_svr_rank": 0,
"cloudDbServiceName": "test-cla",
"dataStorageTypeCode": "SSD",
"dataStorageSize": 10,
"dataStorageSizeStr": "10GB",
"dbInstanceNo": 1265456,
"memorySize": "8GB",
"dbStatusName": "running",
"serverInstanceNo": 1265457,
"dbServerIpAddress": "123.123.213.123",
"cpuCount": 2,
"dbServerRoleCode": "M",
"dbServerType": "2vCPU, 8GB Mem",
"usedDataStorageSize": 0,
"uuid": "1265456-test-cla",
"dbStatusNameValue": "Running",
"dbStatusNameColor": "green",
"dbServerRoleValue": "Master",
"zoneNo": "2",
"zoneName": null
}
]
}
}
Was this article helpful?