Skip to main content

vw_cloud_vm_clusters

Creates, updates, deletes, gets or lists a vw_cloud_vm_clusters resource.

Overview​

Namevw_cloud_vm_clusters
TypeView
Idazure_isv.oracle.vw_cloud_vm_clusters

Fields​

See the SQL Definition (view DDL) for fields returned by this view.

SQL Definition​

SELECT
location as location,
tags as tags,
JSON_EXTRACT(properties, '$.ocid') as "ocid",
JSON_EXTRACT(properties, '$.listenerPort') as "listener_port",
JSON_EXTRACT(properties, '$.nodeCount') as "node_count",
JSON_EXTRACT(properties, '$.storageSizeInGbs') as "storage_size_in_gbs",
JSON_EXTRACT(properties, '$.dataStorageSizeInTbs') as "data_storage_size_in_tbs",
JSON_EXTRACT(properties, '$.dbNodeStorageSizeInGbs') as "db_node_storage_size_in_gbs",
JSON_EXTRACT(properties, '$.memorySizeInGbs') as "memory_size_in_gbs",
JSON_EXTRACT(properties, '$.timeCreated') as "time_created",
JSON_EXTRACT(properties, '$.lifecycleDetails') as "lifecycle_details",
JSON_EXTRACT(properties, '$.timeZone') as "time_zone",
JSON_EXTRACT(properties, '$.zoneId') as "zone_id",
JSON_EXTRACT(properties, '$.hostname') as "hostname",
JSON_EXTRACT(properties, '$.domain') as "domain",
JSON_EXTRACT(properties, '$.cpuCoreCount') as "cpu_core_count",
JSON_EXTRACT(properties, '$.ocpuCount') as "ocpu_count",
JSON_EXTRACT(properties, '$.clusterName') as "cluster_name",
JSON_EXTRACT(properties, '$.dataStoragePercentage') as "data_storage_percentage",
JSON_EXTRACT(properties, '$.isLocalBackupEnabled') as "is_local_backup_enabled",
JSON_EXTRACT(properties, '$.cloudExadataInfrastructureId') as "cloud_exadata_infrastructure_id",
JSON_EXTRACT(properties, '$.isSparseDiskgroupEnabled') as "is_sparse_diskgroup_enabled",
JSON_EXTRACT(properties, '$.systemVersion') as "system_version",
JSON_EXTRACT(properties, '$.sshPublicKeys') as "ssh_public_keys",
JSON_EXTRACT(properties, '$.licenseModel') as "license_model",
JSON_EXTRACT(properties, '$.diskRedundancy') as "disk_redundancy",
JSON_EXTRACT(properties, '$.scanIpIds') as "scan_ip_ids",
JSON_EXTRACT(properties, '$.vipIds') as "vip_ids",
JSON_EXTRACT(properties, '$.scanDnsName') as "scan_dns_name",
JSON_EXTRACT(properties, '$.scanListenerPortTcp') as "scan_listener_port_tcp",
JSON_EXTRACT(properties, '$.scanListenerPortTcpSsl') as "scan_listener_port_tcp_ssl",
JSON_EXTRACT(properties, '$.scanDnsRecordId') as "scan_dns_record_id",
JSON_EXTRACT(properties, '$.shape') as "shape",
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
JSON_EXTRACT(properties, '$.lifecycleState') as "lifecycle_state",
JSON_EXTRACT(properties, '$.vnetId') as "vnet_id",
JSON_EXTRACT(properties, '$.giVersion') as "gi_version",
JSON_EXTRACT(properties, '$.ociUrl') as "oci_url",
JSON_EXTRACT(properties, '$.nsgUrl') as "nsg_url",
JSON_EXTRACT(properties, '$.subnetId') as "subnet_id",
JSON_EXTRACT(properties, '$.backupSubnetCidr') as "backup_subnet_cidr",
JSON_EXTRACT(properties, '$.nsgCidrs') as "nsg_cidrs",
JSON_EXTRACT(properties, '$.dataCollectionOptions') as "data_collection_options",
JSON_EXTRACT(properties, '$.displayName') as "display_name",
JSON_EXTRACT(properties, '$.computeNodes') as "compute_nodes",
JSON_EXTRACT(properties, '$.iormConfigCache') as "iorm_config_cache",
JSON_EXTRACT(properties, '$.lastUpdateHistoryEntryId') as "last_update_history_entry_id",
JSON_EXTRACT(properties, '$.dbServers') as "db_servers",
JSON_EXTRACT(properties, '$.compartmentId') as "compartment_id",
JSON_EXTRACT(properties, '$.subnetOcid') as "subnet_ocid",
subscriptionId,
resourceGroupName,
cloudvmclustername
FROM azure_isv.oracle.cloud_vm_clusters
WHERE subscriptionId = 'replace-me';