turbot/oci

steampipe plugin install ocisteampipe plugin install oci
oci_analytics_instanceoci_apigateway_apioci_autoscaling_auto_scaling_configurationoci_budget_alert_ruleoci_budget_budgetoci_cloud_guard_configurationoci_cloud_guard_detector_recipeoci_cloud_guard_managed_listoci_cloud_guard_responder_recipeoci_cloud_guard_targetoci_core_block_volume_replicaoci_core_boot_volumeoci_core_boot_volume_attachmentoci_core_boot_volume_backupoci_core_boot_volume_metric_read_opsoci_core_boot_volume_metric_read_ops_dailyoci_core_boot_volume_metric_read_ops_hourlyoci_core_boot_volume_metric_write_opsoci_core_boot_volume_metric_write_ops_dailyoci_core_boot_volume_metric_write_ops_hourlyoci_core_boot_volume_replicaoci_core_dhcp_optionsoci_core_drgoci_core_imageoci_core_image_customoci_core_instanceoci_core_instance_metric_cpu_utilizationoci_core_instance_metric_cpu_utilization_dailyoci_core_instance_metric_cpu_utilization_hourlyoci_core_internet_gatewayoci_core_load_balanceroci_core_local_peering_gatewayoci_core_nat_gatewayoci_core_network_load_balanceroci_core_network_security_groupoci_core_public_ipoci_core_public_ip_pooloci_core_route_tableoci_core_security_listoci_core_service_gatewayoci_core_subnetoci_core_vcnoci_core_volumeoci_core_volume_attachmentoci_core_volume_backupoci_core_volume_backup_policyoci_database_autonomous_databaseoci_database_autonomous_database_metric_cpu_utilizationoci_database_autonomous_database_metric_cpu_utilization_dailyoci_database_autonomous_database_metric_storage_utilizationoci_database_autonomous_database_metric_storage_utilization_daioci_database_dboci_database_db_homeoci_database_db_systemoci_database_software_imageoci_dns_rrsetoci_dns_tsig_keyoci_dns_zoneoci_events_ruleoci_file_storage_file_systemoci_file_storage_mount_targetoci_file_storage_snapshotoci_functions_applicationoci_identity_api_keyoci_identity_auth_tokenoci_identity_authentication_policyoci_identity_availability_domainoci_identity_compartmentoci_identity_customer_secret_keyoci_identity_dynamic_groupoci_identity_groupoci_identity_network_sourceoci_identity_policyoci_identity_tag_defaultoci_identity_tag_namespaceoci_identity_tenancyoci_identity_useroci_kms_keyoci_kms_key_versionoci_kms_vaultoci_logging_logoci_logging_log_groupoci_mysql_backupoci_mysql_channeloci_mysql_configurationoci_mysql_configuration_customoci_mysql_db_systemoci_mysql_db_system_metric_connectionsoci_mysql_db_system_metric_connections_dailyoci_mysql_db_system_metric_cpu_utilizationoci_mysql_db_system_metric_cpu_utilization_dailyoci_mysql_db_system_metric_memory_utilizationoci_mysql_db_system_metric_memory_utilization_dailyoci_nosql_tableoci_nosql_table_metric_read_throttle_countoci_nosql_table_metric_read_throttle_count_dailyoci_nosql_table_metric_read_throttle_count_hourlyoci_nosql_table_metric_storage_utilizationoci_nosql_table_metric_storage_utilization_dailyoci_nosql_table_metric_storage_utilization_hourlyoci_nosql_table_metric_write_throttle_countoci_nosql_table_metric_write_throttle_count_dailyoci_nosql_table_metric_write_throttle_count_hourlyoci_objectstorage_bucketoci_ons_notification_topicoci_ons_subscriptionoci_regionoci_resource_search

Table: oci_autoscaling_auto_scaling_configuration

The Oracle Cloud Infrastructure autoscaling configuration allows you to dynamically scale the resources in a Compute instance pool.

Examples

Basic info

select
display_name,
id,
is_enabled,
time_created,
cool_down_in_seconds,
max_resource_count
from
oci_autoscaling_auto_scaling_configuration;

List enabled autoscaling configurations

select
display_name,
id,
is_enabled
from
oci_autoscaling_auto_scaling_configuration
where
is_enabled;

Get policy details for each autoscaling configuration

select
display_name as autoscaling_configuration_display_name,
id,
p ->> 'displayName' as policy_display_name,
p ->> 'id' as policy_id,
p ->> 'isEnabled' as policy_is_enabled,
p ->> 'policyType' as policy_type,
p ->> 'rules' as rules,
p ->> 'capacity' as capacity
from
oci_autoscaling_auto_scaling_configuration,
jsonb_array_elements(policies) as p

Get resource details for each autoscaling configuration

select
display_name as autoscaling_configuration_display_name,
id as autoscaling_configuration_id,
resource ->> 'id' as resource_id,
resource ->> 'type' as resource_type
from
oci_autoscaling_auto_scaling_configuration;

.inspect oci_autoscaling_auto_scaling_configuration

OCI Auto Scaling Configuration

NameTypeDescription
compartment_idtextThe OCID of the compartment in Tenant in which the resource is located.
cool_down_in_secondsbigintThe minimum period of time to wait between scaling actions.
defined_tagsjsonbDefined tags for resource. Defined tags are set up in your tenancy by an administrator. Only users granted permission to work with the defined tags can apply them to resources.
display_nametextA user-friendly name.
freeform_tagsjsonbFree-form tags for resource. This tags can be applied by any user with permissions on the resource.
idtextThe OCID of the autoscaling configuration..
is_enabledbooleanIndicates whether the autoscaling configuration is enabled.
max_resource_countbigintThe maximum number of resources to scale out to.
min_resource_countbigintThe minimum number of resources to scale in to.
policiesjsonbAutoscaling policy definitions for the autoscaling configuration.
regiontextThe OCI region in which the resource is located.
resourcejsonbThe resource details of this AutoScalingConfiguration.
tagsjsonbA map of tags for the resource.
tenant_idtextThe OCID of the Tenant in which the resource is located.
time_createdtimestamp without time zoneThe date and time the AutoScalingConfiguration was created.
titletextTitle of the resource.