getCloudMssqlImageProductList

Available in VPC

Get the list of image product codes provided by Cloud DB for MSSQL.

Syntax

The getCloudMssqlImageProductList syntax is as follows:

./ncloud vmssql getCloudMssqlImageProductList \
    [--productCode <image-product-code>] \
    [--exclusionProductCode <exclusion-image-product-code>] \
    [--generationCode <G2|G3>] \
    [--regionCode <KR|SGN|JPN>] \
    [--output <json|xml>]

Options

This section describes the options available when running getCloudMssqlImageProductList.

Optional options

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

Options	Type	Required	Description
`--productCode`	String	Optional	Cloud DB for MSSQL image product code to be searched
`--exclusionProductCode`	String	Optional	Cloud DB for MSSQL image product code to be excluded
`--generationCode`	String	Optional	Generation code `G2` \| `G3`

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 list of Cloud DB for MSSQL image product codes is successful, the identification information and platform information for each product are returned.

Command

The command example is as follows:

./ncloud vmssql getCloudMssqlImageProductList \
    --exclusionProductCode SW.VMSSL.OS.WND64.WINNT.SVR2019.MSSQL.EE.B100.G003 \
    --generationCode G3 \
    --regionCode KR \
    --output json

Output

The output example is as follows:

{
  "getCloudMssqlImageProductListResponse": {
    "totalRows": 2,
    "productList": [
      {
        "productCode": "SW.VMSSL.OS.WND64.WINNT.SVR2019.MSSQL.SE.B100.G003",
        "productName": "MSSQL Standard Edition",
        "productType": {
          "code": "WINNT",
          "codeName": "Windows NT"
        },
        "productDescription": "Windows Server 2019 with MSSQL 2019 RTM Standard English Edition",
        "infraResourceType": {
          "code": "SW",
          "codeName": "Software"
        },
        "infraResourceDetailType": {
          "code": "SE",
          "codeName": "Standard Edition"
        },
        "baseBlockStorageSize": 107374182400,
        "platformType": {
          "code": "WND64",
          "codeName": "Windows 64 Bit"
        },
        "osInformation": "Windows Server 2019 with MSSQL Standard Edition",
        "generationCode": "G3",
        "engineVersionCode": "15.0.4440.1"
      },
      {
        "productCode": "SW.VMSSL.OS.WND64.WINNT.SVR2019.MSSQL.SE.B100.G003",
        "productName": "MSSQL Standard Edition",
        "productType": {
          "code": "WINNT",
          "codeName": "Windows NT"
        },
        "productDescription": "Windows Server 2019 with MSSQL 2019 RTM Standard English Edition",
        "infraResourceType": {
          "code": "SW",
          "codeName": "Software"
        },
        "infraResourceDetailType": {
          "code": "SE",
          "codeName": "Standard Edition"
        },
        "baseBlockStorageSize": 107374182400,
        "platformType": {
          "code": "WND64",
          "codeName": "Windows 64 Bit"
        },
        "osInformation": "Windows Server 2019 with MSSQL Standard Edition",
        "generationCode": "G3",
        "engineVersionCode": "15.0.4410.1"
      }
    ],
    "requestId": "a1b2c3d4-e5f6-7890-abcd-ef1234567890",
    "returnCode": "0",
    "returnMessage": "success"
  }
}