cloud_vm_clusters
Creates, updates, deletes, gets or lists a cloud_vm_clusters
resource.
Overview
Name | cloud_vm_clusters |
Type | Resource |
Id | azure_isv.oracle.cloud_vm_clusters |
Fields
- vw_cloud_vm_clusters
- cloud_vm_clusters
Name | Datatype | Description |
---|---|---|
backup_subnet_cidr | text | field from the properties object |
cloud_exadata_infrastructure_id | text | field from the properties object |
cloudvmclustername | text | field from the properties object |
cluster_name | text | field from the properties object |
compartment_id | text | field from the properties object |
compute_nodes | text | field from the properties object |
cpu_core_count | text | field from the properties object |
data_collection_options | text | field from the properties object |
data_storage_percentage | text | field from the properties object |
data_storage_size_in_tbs | text | field from the properties object |
db_node_storage_size_in_gbs | text | field from the properties object |
db_servers | text | field from the properties object |
disk_redundancy | text | field from the properties object |
display_name | text | field from the properties object |
domain | text | field from the properties object |
gi_version | text | field from the properties object |
hostname | text | field from the properties object |
iorm_config_cache | text | field from the properties object |
is_local_backup_enabled | text | field from the properties object |
is_sparse_diskgroup_enabled | text | field from the properties object |
last_update_history_entry_id | text | field from the properties object |
license_model | text | field from the properties object |
lifecycle_details | text | field from the properties object |
lifecycle_state | text | field from the properties object |
listener_port | text | field from the properties object |
location | text | The geo-location where the resource lives |
memory_size_in_gbs | text | field from the properties object |
node_count | text | field from the properties object |
nsg_cidrs | text | field from the properties object |
nsg_url | text | field from the properties object |
oci_url | text | field from the properties object |
ocid | text | field from the properties object |
ocpu_count | text | field from the properties object |
provisioning_state | text | field from the properties object |
resourceGroupName | text | field from the properties object |
scan_dns_name | text | field from the properties object |
scan_dns_record_id | text | field from the properties object |
scan_ip_ids | text | field from the properties object |
scan_listener_port_tcp | text | field from the properties object |
scan_listener_port_tcp_ssl | text | field from the properties object |
shape | text | field from the properties object |
ssh_public_keys | text | field from the properties object |
storage_size_in_gbs | text | field from the properties object |
subnet_id | text | field from the properties object |
subnet_ocid | text | field from the properties object |
subscriptionId | text | field from the properties object |
system_version | text | field from the properties object |
tags | text | Resource tags. |
time_created | text | field from the properties object |
time_zone | text | field from the properties object |
vip_ids | text | field from the properties object |
vnet_id | text | field from the properties object |
zone_id | text | field from the properties object |
Name | Datatype | Description |
---|---|---|
location | string | The geo-location where the resource lives |
properties | object | CloudVmCluster resource model |
tags | object | Resource tags. |
Methods
Name | Accessible by | Required Params | Description |
---|---|---|---|
get | SELECT | cloudvmclustername, resourceGroupName, subscriptionId | Get a CloudVmCluster |
list_by_resource_group | SELECT | resourceGroupName, subscriptionId | List CloudVmCluster resources by resource group |
list_by_subscription | SELECT | subscriptionId | List CloudVmCluster resources by subscription ID |
create_or_update | INSERT | cloudvmclustername, resourceGroupName, subscriptionId | Create a CloudVmCluster |
delete | DELETE | cloudvmclustername, resourceGroupName, subscriptionId | Delete a CloudVmCluster |
update | UPDATE | cloudvmclustername, resourceGroupName, subscriptionId | Update a CloudVmCluster |
add_vms | EXEC | cloudvmclustername, resourceGroupName, subscriptionId, data__dbServers | Add VMs to the VM Cluster |
remove_vms | EXEC | cloudvmclustername, resourceGroupName, subscriptionId, data__dbServers | Remove VMs from the VM Cluster |
SELECT
examples
List CloudVmCluster resources by subscription ID
- vw_cloud_vm_clusters
- cloud_vm_clusters
SELECT
backup_subnet_cidr,
cloud_exadata_infrastructure_id,
cloudvmclustername,
cluster_name,
compartment_id,
compute_nodes,
cpu_core_count,
data_collection_options,
data_storage_percentage,
data_storage_size_in_tbs,
db_node_storage_size_in_gbs,
db_servers,
disk_redundancy,
display_name,
domain,
gi_version,
hostname,
iorm_config_cache,
is_local_backup_enabled,
is_sparse_diskgroup_enabled,
last_update_history_entry_id,
license_model,
lifecycle_details,
lifecycle_state,
listener_port,
location,
memory_size_in_gbs,
node_count,
nsg_cidrs,
nsg_url,
oci_url,
ocid,
ocpu_count,
provisioning_state,
resourceGroupName,
scan_dns_name,
scan_dns_record_id,
scan_ip_ids,
scan_listener_port_tcp,
scan_listener_port_tcp_ssl,
shape,
ssh_public_keys,
storage_size_in_gbs,
subnet_id,
subnet_ocid,
subscriptionId,
system_version,
tags,
time_created,
time_zone,
vip_ids,
vnet_id,
zone_id
FROM azure_isv.oracle.vw_cloud_vm_clusters
WHERE subscriptionId = '{{ subscriptionId }}';
SELECT
location,
properties,
tags
FROM azure_isv.oracle.cloud_vm_clusters
WHERE subscriptionId = '{{ subscriptionId }}';
INSERT
example
Use the following StackQL query and manifest file to create a new cloud_vm_clusters
resource.
- All Properties
- Manifest
/*+ create */
INSERT INTO azure_isv.oracle.cloud_vm_clusters (
cloudvmclustername,
resourceGroupName,
subscriptionId,
properties,
tags,
location
)
SELECT
'{{ cloudvmclustername }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ properties }}',
'{{ tags }}',
'{{ location }}'
;
- name: your_resource_model_name
props:
- name: properties
value:
- name: ocid
value: []
- name: listenerPort
value: integer
- name: nodeCount
value: integer
- name: storageSizeInGbs
value: integer
- name: dataStorageSizeInTbs
value: number
- name: dbNodeStorageSizeInGbs
value: integer
- name: memorySizeInGbs
value: integer
- name: timeCreated
value: string
- name: lifecycleDetails
value: string
- name: timeZone
value: string
- name: hostname
value: string
- name: domain
value: string
- name: cpuCoreCount
value: integer
- name: ocpuCount
value: number
- name: clusterName
value: string
- name: dataStoragePercentage
value: integer
- name: isLocalBackupEnabled
value: boolean
- name: cloudExadataInfrastructureId
value: []
- name: isSparseDiskgroupEnabled
value: boolean
- name: systemVersion
value: string
- name: sshPublicKeys
value:
- string
- name: licenseModel
value: []
- name: diskRedundancy
value: []
- name: scanIpIds
value:
- string
- name: vipIds
value:
- string
- name: scanDnsName
value: string
- name: scanListenerPortTcp
value: integer
- name: scanListenerPortTcpSsl
value: integer
- name: shape
value: string
- name: provisioningState
value: []
- name: lifecycleState
value: []
- name: vnetId
value: []
- name: giVersion
value: string
- name: ociUrl
value: string
- name: nsgUrl
value: string
- name: subnetId
value: []
- name: backupSubnetCidr
value: string
- name: nsgCidrs
value:
- - name: source
value: string
- name: destinationPortRange
value:
- name: min
value: integer
- name: max
value: integer
- name: dataCollectionOptions
value:
- name: isDiagnosticsEventsEnabled
value: boolean
- name: isHealthMonitoringEnabled
value: boolean
- name: isIncidentLogsEnabled
value: boolean
- name: displayName
value: string
- name: computeNodes
value:
- []
- name: iormConfigCache
value:
- name: dbPlans
value:
- - name: dbName
value: string
- name: flashCacheLimit
value: string
- name: share
value: integer
- name: lifecycleDetails
value: string
- name: lifecycleState
value: []
- name: objective
value: []
- name: dbServers
value:
- []
- name: tags
value: object
- name: location
value: string
UPDATE
example
Updates a cloud_vm_clusters
resource.
/*+ update */
UPDATE azure_isv.oracle.cloud_vm_clusters
SET
tags = '{{ tags }}',
properties = '{{ properties }}'
WHERE
cloudvmclustername = '{{ cloudvmclustername }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';
DELETE
example
Deletes the specified cloud_vm_clusters
resource.
/*+ delete */
DELETE FROM azure_isv.oracle.cloud_vm_clusters
WHERE cloudvmclustername = '{{ cloudvmclustername }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';