db_nodes

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

Overview

Name	db_nodes
Type	Resource
Id	azure_isv.oracle.db_nodes

Fields

vw_db_nodes

Name	Datatype	Description
additional_details	text	field from the properties object
backup_ip_id	text	field from the properties object
backup_vnic2_id	text	field from the properties object
backup_vnic_id	text	field from the properties object
cloudvmclustername	text	field from the properties object
cpu_core_count	text	field from the properties object
db_node_storage_size_in_gbs	text	field from the properties object
db_server_id	text	field from the properties object
db_system_id	text	field from the properties object
dbnodeocid	text	field from the properties object
fault_domain	text	field from the properties object
host_ip_id	text	field from the properties object
hostname	text	field from the properties object
lifecycle_details	text	field from the properties object
lifecycle_state	text	field from the properties object
maintenance_type	text	field from the properties object
memory_size_in_gbs	text	field from the properties object
ocid	text	field from the properties object
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
software_storage_size_in_gb	text	field from the properties object
subscriptionId	text	field from the properties object
time_created	text	field from the properties object
time_maintenance_window_end	text	field from the properties object
time_maintenance_window_start	text	field from the properties object
vnic2_id	text	field from the properties object
vnic_id	text	field from the properties object

db_nodes

Name	Datatype	Description
properties	object	The properties of DbNodeResource

Methods

Name	Accessible by	Required Params	Description
get	SELECT	cloudvmclustername, dbnodeocid, resourceGroupName, subscriptionId	Get a DbNode
list_by_cloud_vm_cluster	SELECT	cloudvmclustername, resourceGroupName, subscriptionId	List DbNode resources by CloudVmCluster
action	EXEC	cloudvmclustername, dbnodeocid, resourceGroupName, subscriptionId, data__action	VM actions on DbNode of VM Cluster by the provided filter

SELECT examples

List DbNode resources by CloudVmCluster

vw_db_nodes

SELECT
additional_details,
backup_ip_id,
backup_vnic2_id,
backup_vnic_id,
cloudvmclustername,
cpu_core_count,
db_node_storage_size_in_gbs,
db_server_id,
db_system_id,
dbnodeocid,
fault_domain,
host_ip_id,
hostname,
lifecycle_details,
lifecycle_state,
maintenance_type,
memory_size_in_gbs,
ocid,
provisioning_state,
resourceGroupName,
software_storage_size_in_gb,
subscriptionId,
time_created,
time_maintenance_window_end,
time_maintenance_window_start,
vnic2_id,
vnic_id
FROM azure_isv.oracle.vw_db_nodes
WHERE cloudvmclustername = '{{ cloudvmclustername }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

db_nodes

SELECT
properties
FROM azure_isv.oracle.db_nodes
WHERE cloudvmclustername = '{{ cloudvmclustername }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';