---
title: "getCloudMssqlTargetSubnetList"
slug: "cli-vmssql-getcloudmssqltargetsubnetlist"
updated: 2026-09-17T10:08:42Z
published: 2026-09-17T10:08:42Z
canonical: "cli.ncloud-docs.com/cli-vmssql-getcloudmssqltargetsubnetlist"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://cli.ncloud-docs.com/llms.txt
> Use this file to discover all available pages before exploring further.

# 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](/docs/en/cli-vmssql-getcloudmssqltargetvpclist). |
| `--cloudMssqlImageProductCode` | String | Required | Cloud DB for MSSQL image product code - See [getCloudMssqlImageProductList](/docs/en/cli-vmssql-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](/docs/en/cli-vmssql#%EC%98%B5%EC%85%98).

## 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"
  }
}
```