getCloudMssqlProductList

Available in VPC

Views available Cloud DB for MSSQL server spec codes

Commands

The text of the command is as follows:

ncloud vmssql getCloudMssqlProductList [regionCode] [zoneCode] [cloudMssqlImageProductCode] [productCode] [exclusionProductCode] [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	-
zoneCode	String	N	Zone code - zoneCode can be obtained via the getZoneList action	-
cloudMssqlImageProductCode	String	Y	Cloud DB for MSSQL image product code - Views a list of server spec products that can be created from Cloud DB for MSSQL image products - cloudMssqlImageProductCode can be obtained via the getCloudMssqlImageProductList action's productCode	-
productCode	String	N	Cloud DB for MSSQL product code to be viewed - productCode can be obtained via the getCloudMssqlProductList action's productCode	-
exclusionProductCode	String	N	Cloud DB for MSSQL product code to be excluded - exclusionProductCode can be obtained via the getCloudMssqlProductList action's productCode	-
output	String	N	Format type of the response result - options: xml \| json - default: json	-

Responses

Response data type

ProductList type

ProductList extends CommonResponse Description

private Integer totalRows; Total number of items viewed

private List<Product> productList = new ArrayList<>(); List of products

ProductList extends CommonResponse	Description
private Integer totalRows;	Total number of items viewed
private List<Product> productList = new ArrayList<>();	List of products

Product type

Product	Description
private String productCode;	Product code that defines the server’s specification or OS and is managed by NAVER Cloud Platform
private String productName;	Product name
private CommonCode productType;	Product type
private String productDescription;	Product description
private CommonCode infraResourceType;	Type of infrastructure resources
private CommonCode infraResourceDetailType;	Detailed type of infrastructure resources
private Integer cpuCount;	Number of CPUs
private Long memorySize;	Memory size
private Long baseBlockStorageSize;	- Default block storage size
private CommonCode platformType;	Platform type
private String osInformation;	OS information
private CommonCode diskType;	Disk type
private String dbKindCode;	DB type code
private Long addBlockStorageSize;	Size of additional Block Storage
private String generationCode;	Generation code

Examples

Describes examples of recalls and responses.

Recall examples

The following are examples of recalls.

ncloud vmssql getCloudMssqlProductList --regionCode KR --cloudMssqlImageProductCode SW.VMSSL.OS.WND64.WINNT.SVR2016.MSSQL.15020005.SE.B100 --productCode SVR.VMSSL.STAND.C016.M064.NET.HDD.B100.G002

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.

{
  "getCloudMssqlProductListResponse": {
    "requestId": "befb26ad-c104-43bd-9183-27600470f7fd",
    "returnCode": 0,
    "returnMessage": "success",
    "totalRows": 1,
    "productList": [
      {
        "productCode": "SVR.VMSSL.STAND.C016.M064.NET.HDD.B100.G002",
        "productName": "vCPU 16EA, Memory 64GB",
        "productType": {
          "code": "STAND",
          "codeName": "Standard"
        },
        "productDescription": "vCPU 16 EA, Memory 64 GB",
        "infraResourceType": {
          "code": "VMSSL",
          "codeName": "Cloud DB For MSSQL (VPC)"
        },
        "cpuCount": 16,
        "memorySize": 68719476736,
        "diskType": {
          "code": "NET",
          "codeName": "Network Storage"
        }
      }
    ]
  }
}

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

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

<getCloudMssqlProductListResponse>
    <requestId>befb26ad-c104-43bd-9183-27600470f7fd</requestId>
    <returnCode>0</returnCode>
    <returnMessage>success</returnMessage>
    <totalRows>1</totalRows>
    <productList>
        <product>
            <productCode>SVR.VMSSL.STAND.C016.M064.NET.HDD.B100.G002</productCode>
            <productName>vCPU 16EA, Memory 64GB</productName>
            <productType>
                <code>STAND</code>
                <codeName>Standard</codeName>
            </productType>
            <productDescription>vCPU 16 EA, Memory 64 GB</productDescription>
            <infraResourceType>
                <code>VMSSL</code>
                <codeName>Cloud DB for MSSQL (VPC)</codeName>
            </infraResourceType>
            <cpuCount>16</cpuCount>
            <memorySize>68719476736</memorySize>
            <diskType>
                <code>NET</code>
                <codeName>Network Storage</codeName>
            </diskType>
        </product>
    </productList>
</getCloudMssqlProductListResponse>