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_budget_budget

A budget can be used to set soft limits on your Oracle Cloud Infrastructure spending. You can set alerts on your budget to let you know when you might exceed your budget, and you can view all of your budgets and spending from one single place in the Oracle Cloud Infrastructure console.

Examples

Basic info

select
display_name,
id,
amount,
actual_spend,
lifecycle_state as state
from
oci_budget_budget;

List budgets that are not active

select
display_name,
id,
amount,
actual_spend,
lifecycle_state as state
from
oci_budget_budget
where
lifecycle_state <> 'ACTIVE';

List budgets with actual spend more than 100 percent

select
display_name,
id,
amount,
actual_spend,
lifecycle_state as state
from
oci_budget_budget
where
actual_spend > amount;

Control examples

.inspect oci_budget_budget

OCI Budget

NameTypeDescription
actual_spenddouble precisionThe actual spend in currency for the current budget cycle.
alert_rule_countbigintTotal number of alert rules in the budget.
amountdouble precisionThe amount of the budget expressed in the currency of the customer's rate card.
budget_processing_period_start_offsetbigintThe number of days offset from the first day of the month, at which the budget processing period starts.
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 budget.
display_nametextThe display name of the budget.
forecasted_spenddouble precisionThe forecasted spend in currency by the end of the current budget cycle.
freeform_tagsjsonbFree-form tags for resource. This tags can be applied by any user with permissions on the resource.
idtextThe OCID of the budget.
lifecycle_statetextThe current state of the budget.
reset_periodtextThe reset period for the budget.
tagsjsonbA map of tags for the resource.
target_compartment_idtextThis is DEPRECATED. For backwards compatability, the property will be populated when targetType is COMPARTMENT AND targets contains EXACT ONE target compartment ocid. For all other scenarios, this property will be left empty.
target_typetextThe type of target on which the budget is applied.
targetsjsonbThe list of targets on which the budget is applied.
tenant_idtextThe OCID of the Tenant in which the resource is located.
time_createdtimestamp without time zoneTime that budget was created.
time_spend_computedtimestamp without time zoneThe time that the budget spend was last computed.
time_updatedtimestamp without time zoneTime that budget was updated.
titletextTitle of the resource.
versionbigintVersion of the budget. Starts from 1 and increments by 1.