getCloudMssqlTargetSubnetList

Available in VPC

Get the list of subnets available to use in Cloud DB for MSSQL.

Syntax

The getCloudMssqlTargetSubnetList syntax is as follows:

./ncloud vmssql getCloudMssqlTargetSubnetList \
    --vpcNo <vpc-no> \
    --cloudMssqlImageProductCode <image-product-code> \
    [--isPublic <true|false>] \
    [--regionCode <KR|SGN|JPN>] \
    [--output <json|xml>]

Options

This section describes the options available when running getCloudMssqlTargetSubnetList.

Required options

The following options are required for getCloudMssqlTargetSubnetList.

Options	Type	Required	Description
`--vpcNo`	String	Required	VPC number See getCloudMssqlTargetVpcList.
`--cloudMssqlImageProductCode`	String	Required	Cloud DB for MSSQL image product code See getCloudMssqlImageProductList.

Optional options

These are the optional options for getCloudMssqlTargetSubnetList. Options that are not specified will use their default values.

Options	Type	Required	Description
`--isPublic`	Boolean	Optional	Whether it is a public subnet `true` \| `false` If not specified, return all subnets. `true`: Only query public subnets. `false`: Only query private subnets.

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 Cloud DB for MSSQL subnet list is successful, the number, name, and IP range for each subnet are returned.

Command

The command example is as follows:

./ncloud vmssql getCloudMssqlTargetSubnetList \
    --vpcNo 12345678 \
    --cloudMssqlImageProductCode SW.VMSSL.OS.WND64.WINNT.SVR2016.MSSQL.15044401.SE.B100 \
    --isPublic false \
    --regionCode KR \
    --output json

Output

The output example is as follows:

{
  "getCloudMssqlTargetSubnetListResponse": {
    "totalRows": 1,
    "targetSubnetList": [
      {
        "subnetNo": "23456789",
        "subnetName": "private-subnet",
        "vpcNo": "12345678",
        "vpcName": "vpc-01",
        "zoneCode": "KR-1",
        "subnet": "10.0.0.0/24",
        "isPublic": false,
        "createdDate": "2026-04-28T13:00:34+0900"
      }
    ],
    "requestId": "d4e5f6a7-b8c9-0123-defa-456789012345",
    "returnCode": "0",
    "returnMessage": "success"
  }
}