Available in VPC
Get the list of server specification codes provided by Cloud DB for MSSQL.
Syntax
The getCloudMssqlProductList syntax is as follows:
./ncloud vmssql getCloudMssqlProductList \
--cloudMssqlImageProductCode <image-product-code> \
[--zoneCode <zone-code>] \
[--productCode <product-code>] \
[--exclusionProductCode <exclusion-product-code>] \
[--regionCode <KR|SGN|JPN>] \
[--output <json|xml>]
Options
This section describes the options available when running getCloudMssqlProductList.
Required options
The following options are required for getCloudMssqlProductList.
| Options | Type | Required | Description |
|---|---|---|---|
--cloudMssqlImageProductCode |
String | Required | Cloud DB for MSSQL image product code |
Optional options
These are the optional options for getCloudMssqlProductList. Options that are not specified will use their default values.
| Options | Type | Required | Description |
|---|---|---|---|
--zoneCode |
String | Optional | Zone code
|
--productCode |
String | Optional | Cloud DB for MSSQL server spec code to view |
--exclusionProductCode |
String | Optional | Cloud DB for MSSQL server spec code to exclude |
Common options
For information about the options common to all vmssql subcommands, see Cloud DB for MSSQL (VPC) options.
Examples
If the request to retrieve the list of Cloud DB for MSSQL server products is successful, the identification information and specifications for each product are returned.
Command
The command example is as follows:
./ncloud vmssql getCloudMssqlProductList \
--cloudMssqlImageProductCode SW.VMSSL.OS.WND64.WINNT.SVR2016.MSSQL.15044401.SE.B100 \
--exclusionProductCode SVR.VMSSL.STAND.C024.M128.NET.HDD.B100.G002 \
--zoneCode KR-1 \
--regionCode KR \
--output json
Output
The output example is as follows:
{
"getCloudMssqlProductListResponse": {
"totalRows": 13,
"productList": [
{
"productCode": "SVR.VMSSL.HICPU.C002.M004.NET.HDD.B100.G002",
"productName": "vCPU 2EA, Memory 4GB",
"productType": {
"code": "HICPU",
"codeName": "High CPU"
},
"productDescription": "2 vCPUs, 4 GB memory",
"infraResourceType": {
"code": "VMSSL",
"codeName": "Cloud DB For MSSQL (VPC)"
},
"infraResourceDetailType": {
"code": "DBSVR",
"codeName": "DB Server"
},
"cpuCount": 2,
"memorySize": 4294967296,
"diskType": {
"code": "NET",
"codeName": "Network storage"
}
},
{
"productCode": "SVR.VMSSL.HICPU.C004.M008.NET.HDD.B100.G002",
"productName": "vCPU 4EA, Memory 8GB",
"productType": {
"code": "HICPU",
"codeName": "High CPU"
},
"productDescription": "4 vCPUs, 8 GB memory",
"infraResourceType": {
"code": "VMSSL",
"codeName": "Cloud DB For MSSQL (VPC)"
},
"infraResourceDetailType": {
"code": "DBSVR",
"codeName": "DB Server"
},
"cpuCount": 4,
"memorySize": 8589934592,
"diskType": {
"code": "NET",
"codeName": "Network storage"
}
},
{
"productCode": "SVR.VMSSL.STAND.C002.M008.NET.HDD.B100.G002",
"productName": "vCPU 2EA, Memory 8GB",
"productType": {
"code": "STAND",
"codeName": "Standard"
},
"productDescription": "2 vCPUs, 8 GB memory",
"infraResourceType": {
"code": "VMSSL",
"codeName": "Cloud DB For MSSQL (VPC)"
},
"infraResourceDetailType": {
"code": "DBSVR",
"codeName": "DB Server"
},
"cpuCount": 2,
"memorySize": 8589934592,
"diskType": {
"code": "NET",
"codeName": "Network storage"
}
},
{
"productCode": "SVR.VMSSL.HICPU.C008.M016.NET.HDD.B100.G002",
"productName": "vCPU 8EA, Memory 16GB",
"productType": {
"code": "HICPU",
"codeName": "High CPU"
},
"productDescription": "8 vCPUs, 16 GB memory",
"infraResourceType": {
"code": "VMSSL",
"codeName": "Cloud DB For MSSQL (VPC)"
},
"infraResourceDetailType": {
"code": "DBSVR",
"codeName": "DB Server"
},
"cpuCount": 8,
"memorySize": 17179869184,
"diskType": {
"code": "NET",
"codeName": "Network storage"
}
},
{
"productCode": "SVR.VMSSL.HIMEM.C002.M016.NET.HDD.B100.G002",
"productName": "vCPU 2EA, Memory 16GB",
"productType": {
"code": "HIMEM",
"codeName": "High Memory"
},
"productDescription": "2 vCPUs, 16 GB memory",
"infraResourceType": {
"code": "VMSSL",
"codeName": "Cloud DB For MSSQL (VPC)"
},
"infraResourceDetailType": {
"code": "DBSVR",
"codeName": "DB Server"
},
"cpuCount": 2,
"memorySize": 17179869184,
"diskType": {
"code": "NET",
"codeName": "Network storage"
}
},
{
"productCode": "SVR.VMSSL.STAND.C004.M016.NET.HDD.B100.G002",
"productName": "vCPU 4EA, Memory 16GB",
"productType": {
"code": "STAND",
"codeName": "Standard"
},
"productDescription": "4 vCPUs, 16 GB memory",
"infraResourceType": {
"code": "VMSSL",
"codeName": "Cloud DB For MSSQL (VPC)"
},
"infraResourceDetailType": {
"code": "DBSVR",
"codeName": "DB Server"
},
"cpuCount": 4,
"memorySize": 17179869184,
"diskType": {
"code": "NET",
"codeName": "Network storage"
}
},
{
"productCode": "SVR.VMSSL.HICPU.C016.M032.NET.HDD.B100.G002",
"productName": "vCPU 16EA, Memory 32GB",
"productType": {
"code": "HICPU",
"codeName": "High CPU"
},
"productDescription": "16 vCPUs, 32 GB memory",
"infraResourceType": {
"code": "VMSSL",
"codeName": "Cloud DB For MSSQL (VPC)"
},
"infraResourceDetailType": {
"code": "DBSVR",
"codeName": "DB Server"
},
"cpuCount": 16,
"memorySize": 34359738368,
"diskType": {
"code": "NET",
"codeName": "Network storage"
}
},
{
"productCode": "SVR.VMSSL.HIMEM.C004.M032.NET.HDD.B100.G002",
"productName": "vCPU 4EA, Memory 32GB",
"productType": {
"code": "HIMEM",
"codeName": "High Memory"
},
"productDescription": "4 vCPUs, 32 GB memory",
"infraResourceType": {
"code": "VMSSL",
"codeName": "Cloud DB For MSSQL (VPC)"
},
"infraResourceDetailType": {
"code": "DBSVR",
"codeName": "DB Server"
},
"cpuCount": 4,
"memorySize": 34359738368,
"diskType": {
"code": "NET",
"codeName": "Network storage"
}
},
{
"productCode": "SVR.VMSSL.STAND.C008.M032.NET.HDD.B100.G002",
"productName": "vCPU 8EA, Memory 32GB",
"productType": {
"code": "STAND",
"codeName": "Standard"
},
"productDescription": "8 vCPUs, 32 GB memory",
"infraResourceType": {
"code": "VMSSL",
"codeName": "Cloud DB For MSSQL (VPC)"
},
"infraResourceDetailType": {
"code": "DBSVR",
"codeName": "DB Server"
},
"cpuCount": 8,
"memorySize": 34359738368,
"diskType": {
"code": "NET",
"codeName": "Network storage"
}
},
{
"productCode": "SVR.VMSSL.HICPU.C024.M064.NET.HDD.B100.G002",
"productName": "vCPU 24EA, Memory 64GB",
"productType": {
"code": "HICPU",
"codeName": "High CPU"
},
"productDescription": "24 vCPUs, 64 GB memory",
"infraResourceType": {
"code": "VMSSL",
"codeName": "Cloud DB For MSSQL (VPC)"
},
"infraResourceDetailType": {
"code": "DBSVR",
"codeName": "DB Server"
},
"cpuCount": 24,
"memorySize": 68719476736,
"diskType": {
"code": "NET",
"codeName": "Network storage"
}
},
{
"productCode": "SVR.VMSSL.HIMEM.C008.M064.NET.HDD.B100.G002",
"productName": "vCPU 8EA, Memory 64GB",
"productType": {
"code": "HIMEM",
"codeName": "High Memory"
},
"productDescription": "8 vCPUs, 64 GB memory",
"infraResourceType": {
"code": "VMSSL",
"codeName": "Cloud DB For MSSQL (VPC)"
},
"infraResourceDetailType": {
"code": "DBSVR",
"codeName": "DB Server"
},
"cpuCount": 8,
"memorySize": 68719476736,
"diskType": {
"code": "NET",
"codeName": "Network storage"
}
},
{
"productCode": "SVR.VMSSL.STAND.C016.M064.NET.HDD.B100.G002",
"productName": "vCPU 16EA, Memory 64GB",
"productType": {
"code": "STAND",
"codeName": "Standard"
},
"productDescription": "16 vCPUs, 64 GB memory",
"infraResourceType": {
"code": "VMSSL",
"codeName": "Cloud DB For MSSQL (VPC)"
},
"infraResourceDetailType": {
"code": "DBSVR",
"codeName": "DB Server"
},
"cpuCount": 16,
"memorySize": 68719476736,
"diskType": {
"code": "NET",
"codeName": "Network storage"
}
},
{
"productCode": "SVR.VMSSL.HIMEM.C016.M128.NET.HDD.B100.G002",
"productName": "vCPU 16EA, Memory 128GB",
"productType": {
"code": "HIMEM",
"codeName": "High Memory"
},
"productDescription": "16 vCPUs, 128 GB memory",
"infraResourceType": {
"code": "VMSSL",
"codeName": "Cloud DB For MSSQL (VPC)"
},
"infraResourceDetailType": {
"code": "DBSVR",
"codeName": "DB Server"
},
"cpuCount": 16,
"memorySize": 137438953472,
"diskType": {
"code": "NET",
"codeName": "Network storage"
}
}
],
"requestId": "b2c3d4e5-f6a7-8901-bcde-f23456789012",
"returnCode": "0",
"returnMessage": "success"
}
}