getCloudMssqlImageProductList

Article summary

Did you find this summary helpful?

Thank you for your feedback

Available in VPC

Views Cloud DB for MSSQL product code list.

Commands

The text of the command is as follows:

ncloud vmssql getCloudMssqlImageProductList [regionCode] [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	-
productCode	String	N	Cloud DB for MSSQL image product code to be viewed - productCode can be obtained via the getCloudMssqlImageProductList action's productCode	-
exclusionProductCode	String	N	Cloud DB for MSSQL image product code to be excluded - exclusionProductCode can be obtained via the getCloudMssqlImageProductList 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 getCloudMssqlImageProductList --regionCode KR --productCode 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.

{
  "getCloudMssqlImageProductListResponse": {
    "requestId": "c5d74898-60f7-4ac2-a9a8-23485ed70feb",
    "returnCode": 0,
    "returnMessage": "success",
    "totalRows": 3,
    "productList": [
      {
        "productCode": "SW.VMSSL.OS.WND64.WINNT.SVR2016.MSSQL.15020005.EE.B100",
        "productName": "MSSQL 15.0.2000.5 Enterprise Edition",
        "productType": {
          "code": "WINNT",
          "codeName": "Windows NT"
        },
        "productDescription": "Windows Server 2016 with MSSQL 2019 RTM (15.0.2000.5) Enterprise English Edition",
        "infraResourceType": {
          "code": "SW",
          "codeName": "Software"
        },
        "baseBlockStorageSize": 107374182400,
        "platformType": {
          "code": "WND64",
          "codeName": "Windows 64 Bit"
        },
        "osInformation": "Windows Server 2016 with MSSQL 15.0.2000.5 Enterprise Edition",
        "generationCode": "G2"
      },
      {
        "productCode": "SW.VMSSL.OS.WND64.WINNT.SVR2016.MSSQL.15041982.SE.B100",
        "productName": "MSSQL 15.0.4198.2 Standard Edition",
        "productType": {
          "code": "WINNT",
          "codeName": "Windows NT"
        },
        "productDescription": "Windows Server 2016 with MSSQL 2019 RTM (15.0.4198.2) Standard English Edition",
        "infraResourceType": {
          "code": "SW",
          "codeName": "Software"
        },
        "baseBlockStorageSize": 107374182400,
        "platformType": {
          "code": "WND64",
          "codeName": "Windows 64 Bit"
        },
        "osInformation": "Windows Server 2016 with MSSQL 15.0.4198.2 Standard Edition",
        "generationCode": "G2"
      },
      {
        "productCode": "SW.VMSSL.OS.WND64.WINNT.SVR2016.MSSQL.15041982.EE.B100",
        "productName": "MSSQL 15.0.4198.2 Enterprise Edition",
        "productType": {
          "code": "WINNT",
          "codeName": "Windows NT"
        },
        "productDescription": "Windows Server 2016 with MSSQL 2019 RTM (15.0.4198.2) Enterprise English Edition",
        "infraResourceType": {
          "code": "SW",
          "codeName": "Software"
        },
        "baseBlockStorageSize": 107374182400,
        "platformType": {
          "code": "WND64",
          "codeName": "Windows 64 Bit"
        },
        "osInformation": "Windows Server 2016 with MSSQL 15.0.4198.2 Enterprise Edition",
        "generationCode": "G2"
      }
    ]
  }
}

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

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

<getCloudMssqlImageProductListResponse>
    <requestId>c5d74898-60f7-4ac2-a9a8-23485ed70feb</requestId>
    <returnCode>0</returnCode>
    <returnMessage>success</returnMessage>
    <totalRows>3</totalRows>
    <productList>
        <product>
            <productCode>SW.VMSSL.OS.WND64.WINNT.SVR2016.MSSQL.15020005.EE.B100</productCode>
            <productName>MSSQL 15.0.2000.5 Enterprise Edition</productName>
            <productType>
                <code>WINNT</code>
                <codeName>Windows NT</codeName>
            </productType>
            <productDescription>Windows Server 2016 with MSSQL 2019 RTM (15.0.2000.5) Enterprise English Edition</productDescription>
            <infraResourceType>
                <code>SW</code>
                <codeName>Software</codeName>
            </infraResourceType>
            <baseBlockStorageSize>107374182400</baseBlockStorageSize>
            <platformType>
                <code>WND64</code>
                <codeName>Windows 64 Bit</codeName>
            </platformType>
            <osInformation>Windows Server 2016 with MSSQL 15.0.2000.5 Enterprise Edition</osInformation>
            <generationCode>G2</generationCode>
        </product>
        <product>
            <productCode>SW.VMSSL.OS.WND64.WINNT.SVR2016.MSSQL.15041982.SE.B100</productCode>
            <productName>MSSQL 15.0.4198.2 Standard Edition</productName>
            <productType>
                <code>WINNT</code>
                <codeName>Windows NT</codeName>
            </productType>
            <productDescription>Windows Server 2016 with MSSQL 2019 RTM (15.0.4198.2) Standard English Edition</productDescription>
            <infraResourceType>
                <code>SW</code>
                <codeName>Software</codeName>
            </infraResourceType>
            <baseBlockStorageSize>107374182400</baseBlockStorageSize>
            <platformType>
                <code>WND64</code>
                <codeName>Windows 64 Bit</codeName>
            </platformType>
            <osInformation>Windows Server 2016 with MSSQL 15.0.4198.2 Standard Edition</osInformation>
            <generationCode>G2</generationCode>
        </product>
        <product>
            <productCode>SW.VMSSL.OS.WND64.WINNT.SVR2016.MSSQL.15041982.EE.B100</productCode>
            <productName>MSSQL 15.0.4198.2 Enterprise Edition</productName>
            <productType>
                <code>WINNT</code>
                <codeName>Windows NT</codeName>
            </productType>
            <productDescription>Windows Server 2016 with MSSQL 2019 RTM (15.0.4198.2) Enterprise English Edition</productDescription>
            <infraResourceType>
                <code>SW</code>
                <codeName>Software</codeName>
            </infraResourceType>
            <baseBlockStorageSize>107374182400</baseBlockStorageSize>
            <platformType>
                <code>WND64</code>
                <codeName>Windows 64 Bit</codeName>
            </platformType>
            <osInformation>Windows Server 2016 with MSSQL 15.0.4198.2 Enterprise Edition</osInformation>
            <generationCode>G2</generationCode>
        </product>
    </productList>
</getCloudMssqlImageProductListResponse>

Was this article helpful?

What's Next

getCloudMssqlInstanceDetail

Table of contents

Commands
Responses
Examples