turbot/oci

steampipe plugin install ocisteampipe plugin install oci
oci_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_dhcp_optionsoci_core_drgoci_core_imageoci_core_instanceoci_core_instance_metric_cpu_utilizationoci_core_instance_metric_cpu_utilization_dailyoci_core_instance_metric_cpu_utilization_hourlyoci_core_internet_gatewayoci_core_local_peering_gatewayoci_core_nat_gatewayoci_core_network_load_balanceroci_core_network_security_groupoci_core_public_ipoci_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_dns_rrsetoci_dns_tsig_keyoci_dns_zoneoci_events_ruleoci_file_storage_file_systemoci_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_db_systemoci_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_region

Table: oci_budget_alert_rule

Budget alert rules can contain rules based on a percentage of your budget or an absolute amount, and on your actual spending or your forecast spending.

Examples

Basic info

select
display_name,
id,
budget_id,
threshold,
lifecycle_state as state
from
oci_budget_alert_rule;

List alert rules that are not active

select
display_name,
id,
budget_id,
threshold,
lifecycle_state as state
from
oci_budget_alert_rule
where
lifecycle_state <> 'ACTIVE';

List alert rules with a threshold more than 100 percentage

select
display_name,
id,
budget_id,
threshold,
lifecycle_state as state
from
oci_budget_alert_rule
where
threshold > 100
and threshold_type = 'PERCENTAGE';

.inspect oci_budget_alert_rule

OCI Budget Alert Rule

NameTypeDescription
budget_idtextThe OCID of the budget
compartment_idtextThe OCID of the compartment in Tenant in which the resource is located.
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.
descriptiontextThe description of the alert rule.
display_nametextThe name of the alert rule.
freeform_tagsjsonbFree-form tags for resource. This tags can be applied by any user with permissions on the resource.
idtextThe OCID of the alert rule.
lifecycle_statetextThe current state of the alert rule.
messagetextCustom message sent when alert is triggered.
recipientstextDelimited list of email addresses to receive the alert when it triggers.
tagsjsonbA map of tags for the resource.
tenant_idtextThe OCID of the Tenant in which the resource is located.
thresholddouble precisionThe threshold for triggering the alert. If thresholdType is PERCENTAGE, the maximum value is 10000.
threshold_typetextThe type of threshold.
time_createdtimestamp without time zoneTime that budget was created.
time_updatedtimestamp without time zoneTime that budget was updated.
titletextTitle of the resource.
typetextThe type of alert.
versionbigintVersion of the alert rule. Starts from 1 and increments by 1.