getCloudMssqlTargetSubnetList

Prev Next

Available in VPC

View the list of subnets available.

Commands

The text of the command is as follows:

ncloud vmssql getCloudMssqlTargetSubnetList [regionCode] [vpcNo] [cloudMssqlImageProductCode] [isPublic] [output]

Parameter

The following is a description on parameters.

Parameter Type Requirement status Description Restrictions
regionCode String N Region code
- regionCode can be obtained via the getRegionList action
- Default: selects the first region of the getRegionList search results		 -
vpcNo String Y VPC number
- vpcNo can be obtained via the getCloudMssqlTargetVpcList action		 -
cloudMssqlImageProductCode String Y Cloud DB for MSSQL image product code
- cloudMssqlImageProductCode can be obtained via the getCloudMssqlImageProductList action's productCode		 -
isPublic Boolean N Public subnet search status -
output String N Format type of the response result
- options: xml | json
- default: json		 -

Responses

Response data type

  • TargetSubnetList type

    TargetSubnetList extends CommonResponse Description
    private Integer totalRows; Total number of items viewed
    private List<TargetSubnet> targetSubnetList = new ArrayList<>(); Subnet list

  • TargetSubnet type

    TargetSubnet Description
    private String subnetNo; Subnet number
    private String subnetName; Subnet name
    private String vpcNo; VPC number
    private String vpcName; VPC name
    private String zoneCode; Zone code
    private String subnet; IP address range
    private Boolean isPublic; Public Subnet status
    private Date createdDate; Creation date

Examples

Describes examples of recalls and responses.

Recall examples

The following are examples of recalls.

ncloud vmssql getCloudMssqlTargetSubnetList --regionCode KR --vpcNo **65 --cloudMssqlImageProductCode SW.VMSSL.OS.WND64.WINNT.SVR2016.MSSQL.15020005.SE.B100

Response examples

The following are examples of responses.

If the response shows that format type (output) is json

The following is when the response shows that format type (output) is json.

{
  "getCloudMssqlTargetSubnetListResponse": {
    "requestId": "415050c7-bda1-43b6-9af1-f5ade127ad82",
    "returnCode": 0,
    "returnMessage": "success",
    "totalRows": 2,
    "targetSubnetList": [
      {
        "subnetNo": "37****",
        "subnetName": "test-****-private-kr1",
        "vpcNo": "**65",
        "vpcName": "test-****",
        "zoneCode": "KR-1",
        "subnet": "192.168.0.0/24",
        "isPublic": false,
        "createdDate": "2022-03-24T18:00:00+0900"
      },
      {
        "subnetNo": "37****",
        "subnetName": "test-****-public-kr1",
        "vpcNo": "**65",
        "vpcName": "test-****",
        "zoneCode": "KR-1",
        "subnet": "192.168.1.0/24",
        "isPublic": true,
        "createdDate": "2022-03-24T18:00:00+0900"
      }
    ]
  }
}

If the response shows that format type (responseFormatType) is xml

The following is when the response shows that format type (responseFormatType) is xml:

<getCloudMssqlTargetSubnetListResponse>
    <requestId>415050c7-bda1-43b6-9af1-f5ade127ad82</requestId>
    <returnCode>0</returnCode>
    <returnMessage>success</returnMessage>
    <totalRows>2</totalRows>
    <targetSubnetList>
        <targetSubnet>
            <subnetNo>37****</subnetNo>
            <subnetName>test-****-private-kr1</subnetName>
            <vpcNo>**65</vpcNo>
            <vpcName>test-****</vpcName>
            <zoneCode>KR-1</zoneCode>
            <subnet>192.168.0.0/24</subnet>
            <isPublic>false</isPublic>>
            <createdDate>2022-03-24T18:00:00+0900</createdDate>
        </targetSubnet>
        <targetSubnet>
            <subnetNo>37****</subnetNo>
            <subnetName>test-****-public-kr1</subnetName>
            <vpcNo>**65</vpcNo>
            <vpcName>test-****</vpcName>
            <zoneCode>KR-1</zoneCode>
            <subnet>192.168.1.0/24</subnet>
            <isPublic>true</isPublic>>
            <createdDate>2022-03-24T18:00:00+0900</createdDate>
        </targetSubnet>
    </targetSubnetList>
</getCloudMssqlTargetSubnetListResponse>