getCloudMssqlInstanceList
- 인쇄
- PDF
getCloudMssqlInstanceList
- 인쇄
- PDF
Article Summary
Share feedback
Thanks for sharing your feedback!
개요
Cloud DB for MSSQL 인스턴스 리스트를 조회합니다.
요청
요청 파라미터
파라미터명 | 필수 여부 | 타입 | 제약 사항 | 설명 |
---|---|---|---|---|
cloudMssqlInstanceNoList | No | List<String> | - Cloud DB for MSSQL 인스턴스 번호 리스트 Cloud DB for MSSQL 인스턴스 번호로 필터링하여 검색 가능 cloudMssqlInstanceNoList는 getCloudMssqlInstanceList 액션을 통해서 획득 가능 ex) cloudMssqlInstanceNoList 1234 2345 | |
cloudMssqlServiceName | No | String | - Cloud DB for MSSQL 서비스 이름 Cloud DB for MSSQL 서비스 이름으로 필터링하여 검색 가능 cloudMssqlServiceName은 getCloudMssqlInstanceList 액션을 통해서 획득 가능 | |
cloudMssqlServerInstanceNoList | No | List<String> | - Cloud DB for MSSQL 서버 인스턴스 번호 리스트 Cloud DB for MSSQL 서버 인스턴스 번호로 필터링하여 검색 가능 cloudMssqlServerInstanceNoList getCloudMssqlInstanceList 액션을 통해서 획득 가능 ex) cloudMssqlServerInstanceNoList 1234 2345 | |
cloudMssqlServerName | No | String | - Cloud DB for MSSQL 서버 이름 Cloud DB for MSSQL 서버 이름으로 필터링하여 검색 가능 cloudMssqlServerName은 getCloudMssqlInstanceList 액션을 통해서 획득 가능 | |
regionCode | No | String | - 리전 코드 Cloud DB for MSSQL 인스턴스 리스트가 조회될 리전(Region)을 결정 가능 regionCode는 getRegionList 액션을 통해서 획득 가능 Default: getRegionList 조회 결과의 첫 번째 리전을 선택 | |
zoneCode | No | String | - ZONE 코드 Cloud DB for MSSQL 인스턴스 리스트가 조회될 Zone을 결정 가능 zoneCode는 getZoneList 액션을 통해서 획득 가능 | |
vpcNo | No | String | - VPC 번호 Cloud DB for MSSQL 인스턴스 리스트가 조회될 VPC를 결정 가능 vpcNo는 getCloudMssqlTargetVpcList 액션을 통해서 획득 가능 | |
subnetNo | No | String | - Subnet 번호 Cloud DB for MSSQL 인스턴스 리스트가 조회될 Subnet을 결정 가능 SubnetNo는 getCloudMssqlTargetSubnetList 액션을 통해서 획득 가능 | |
pageNo | No | Integer | Min: 0 | - 페이징된 결과의 페이지 번호 결괏값을 pageNo, pageSize를 이용하여 페이징 처리 가능 |
pageSize | Conditional | Integer | Min: 1 | - 페이징 시 보여줄 각 페이지 사이즈 결괏값을 pageNo, pageSize를 이용하여 페이징 처리 가능 pageNo 입력 시 입력 필수 |
output | No | String | - 응답 결과의 포맷 타입 Options: xml | json Default: json |
응답
응답 데이터 타입
- CloudMssqlInstanceList 타입
CloudMssqlInstanceList extends CommonResponse |
---|
private Integer totalRows; |
private List<CloudMssqlInstance> cloudMssqlInstanceList = new ArrayList<>(); |
CloudMssqlInstance |
---|
private String cloudMssqlInstanceNo; |
private String cloudMssqlServiceName; |
private String cloudMssqlInstanceStatusName; |
private CommonCode cloudMssqlInstanceStatus; |
private CommonCode cloudMssqlInstanceOperation; |
private String cloudMssqlImageProductCode; |
private Boolean isHa; |
private Boolean isMultiZone; |
private CommonCode license; |
private Integer cloudMssqlPort; |
private Integer backupFileRetentionPeriod; |
private String backupTime; |
private String configGroupNo; |
private String configGroupName; |
private String engineVersion; |
private Date createDate; |
private String dbCollation; |
private List<CloudMssqlServerInstance> cloudMssqlServerInstanceList; |
private AccessControlGroupNoList accessControlGroupNoList; |
CloudMssqlServerInstance |
---|
private String cloudMssqlServerInstanceNo; |
private String cloudMssqlServerName; |
private CommonCode cloudMssqlServerRole; |
private String cloudMssqlServerInstanceStatusName; |
private CommonCode cloudMssqlServerInstanceStatus; |
private CommonCode cloudMssqlServerInstanceOperation; |
private String regionCode; |
private String zoneCode; |
private String vpcNo; |
private String subnetNo; |
private Long dataStorageSize; |
private Integer cpuCount; |
private Long memorySize; |
private Boolean isPublicSubnet; |
private String cloudMssqlProductCode; |
private String privateDomain; |
private String publicDomain; |
private Date createDate; |
private Date uptime; |
private CommonCode dataStorageType; |
private Long usedDataStorageSize; |
AccessControlGroupNoList |
---|
private List<String> accessControlGroupNoList = new ArrayList<>(); |
예시
요청 예시
ncloud vmssql getCloudMssqlInstanceList --regionCode FKR --zoneCode FKR-1 --vpcNo ***83 --subnetNo **91 --cloudMssqlServiceName test-**** --cloudMssqlInstanceNoList ****890 --cloudMssqlServerName test--**** --cloudMssqlServerInstanceNoList ****891 --pageNo 0 --pageSize 10
응답 예시
<getCloudMssqlInstanceListResponse>
<requestId>c04bfdd1-e27e-4006-9bc3-bc37840ce1dd</requestId>
<returnCode>0</returnCode>
<returnMessage>success</returnMessage>
<totalRows>1</totalRows>
<cloudMssqlInstanceList>
<cloudMssqlInstance>
<cloudMssqlInstanceNo>****890</cloudMssqlInstanceNo>
<cloudMssqlServiceName>test-****</cloudMssqlServiceName>
<cloudMssqlInstanceStatusName>running</cloudMssqlInstanceStatusName>
<cloudMssqlInstanceStatus>
<code>CREAT</code>
<codeName>CLOUD DATABASE(VPC) Created State</codeName>
</cloudMssqlInstanceStatus>
<cloudMssqlInstanceOperation>
<code>NULL</code>
<codeName>CLOUD DATABASE(VPC) Null OP</codeName>
</cloudMssqlInstanceOperation>
<cloudMssqlImageProductCode>SW.VMSSL.OS.WND64.WINNT.SVR2016.MSSQL.15020005.SE.B100</cloudMssqlImageProductCode>
<isHa>true</isHa>
<isMultiZone>false</isMultiZone>
<license>
<code>GPL</code>
<codeName>General Public License</codeName>
</license>
<cloudMssqlPort>1433</cloudMssqlPort>
<backupFileRetentionPeriod>10</backupFileRetentionPeriod>
<backupTime>00:15</backupTime>
<configGroupNo>**9</configGroupNo>
<configGroupName>test-****-config</configGroupName>
<engineVersion>MSSQL 15.0.2000.5 Standard Edition</engineVersion>
<createDate>2021-04-12T19:30:38+0900</createDate>
<cloudMssqlServerInstanceList>
<cloudMssqlServerInstanceList>
<cloudMssqlServerInstanceNo>****891</cloudMssqlServerInstanceNo>
<cloudMssqlServerName>m-****890-001</cloudMssqlServerName>
<cloudMssqlServerRole>
<code>M</code>
<codeName>Principal</codeName>
</cloudMssqlServerRole>
<cloudMssqlServerInstanceStatusName>running</cloudMssqlServerInstanceStatusName>
<cloudMssqlServerInstanceStatus>
<code>RUN</code>
<codeName>CLOUD DATABASE(VPC) Server Running State</codeName>
</cloudMssqlServerInstanceStatus>
<cloudMssqlServerInstanceOperation>
<code>NOOP</code>
<codeName>CLOUD DATABASE(VPC) Server Null OP</codeName>
</cloudMssqlServerInstanceOperation>
<regionCode>FKR</regionCode>
<zoneCode>FKR-1</zoneCode>
<vpcNo>****83</vpcNo>
<subnetNo>****91</subnetNo>
<dataStorageSize>107374182400</dataStorageSize>
<cpuCount>2</cpuCount>
<memorySize>8589934592</memorySize>
<isPublicSubnet>true</isPublicSubnet>
<cloudMssqlProductCode>SVR.VMSSL.STAND.C002.M008.NET.HDD.B100.G002</cloudMssqlProductCode>
<privateDomain>mssql-***.beta-vpc-cdb.ntruss.com</privateDomain>
<createDate>2021-04-30T14:03:20+0900</createDate>
<uptime>2021-04-30T14:14:39+0900</uptime>
<dataStorageType>
<code>SSD</code>
<codeName>SSD</codeName>
</dataStorageType>
<usedDataStorageSize>1073741824</usedDataStorageSize>
</cloudMssqlServerInstanceList>
<cloudMssqlServerInstanceList>
<cloudMssqlServerInstanceNo>****897</cloudMssqlServerInstanceNo>
<cloudMssqlServerName>m-****890-002</cloudMssqlServerName>
<cloudMssqlServerRole>
<code>H</code>
<codeName>Mirror</codeName>
</cloudMssqlServerRole>
<cloudMssqlServerInstanceStatusName>running</cloudMssqlServerInstanceStatusName>
<cloudMssqlServerInstanceStatus>
<code>RUN</code>
<codeName>CLOUD DATABASE(VPC) Server Running State</codeName>
</cloudMssqlServerInstanceStatus>
<cloudMssqlServerInstanceOperation>
<code>NOOP</code>
<codeName>CLOUD DATABASE(VPC) Server Null OP</codeName>
</cloudMssqlServerInstanceOperation>
<regionCode>FKR</regionCode>
<zoneCode>FKR-1</zoneCode>
<vpcNo>****83</vpcNo>
<subnetNo>****91</subnetNo>
<dataStorageSize>107374182400</dataStorageSize>
<cpuCount>2</cpuCount>
<memorySize>8589934592</memorySize>
<isPublicSubnet>true</isPublicSubnet>
<cloudMssqlProductCode>SVR.VMSSL.STAND.C002.M008.NET.HDD.B100.G002</cloudMssqlProductCode>
<privateDomain>mssql-***.beta-vpc-cdb.ntruss.com</privateDomain>
<createDate>2021-05-27T19:00:00+0900</createDate>
<uptime>2021-05-27T19:01:00+0900</uptime>
<dataStorageType>
<code>SSD</code>
<codeName>SSD</codeName>
</dataStorageType>
<usedDataStorageSize>1073741824</usedDataStorageSize>
</cloudMssqlServerInstanceList>
</cloudMssqlServerInstanceList>
</cloudMssqlInstance>
</cloudMssqlInstanceList>
<accessControlGroupNoList/>
</getCloudMssqlInstanceListResponse>
이 문서가 도움이 되었습니까?