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_events_rule

The Oracle Cloud Infrastructure Events service invokes the action specified in the rule by delivering the event message to action resources, which can include topics, streams, or functions.

Examples

Basic info

select
id as rule_id,
display_name,
lifecycle_state as state,
condition,
is_enabled,
time_created,
actions
from
oci_events_rule;

List enabled rules

select
id as rule_id,
display_name,
lifecycle_state,
condition,
is_enabled
from
oci_events_rule
where
is_enabled;

List failed rules

select
id as rule_id,
display_name,
lifecycle_state,
condition,
is_enabled
from
oci_events_rule
where
lifecycle_state = 'FAILED';

Get action details for rules that have the Oracle Notification Service action type

select
id as rule_id,
display_name,
is_enabled,
a ->> 'actionType' as action_type,
a ->> 'id' as action_id,
a ->> 'isEnabled' as action_is_enabled,
a ->> 'lifecycleState' as action_state,
a ->> 'topicId' as topic_id
from
oci_events_rule,
jsonb_array_elements(actions) as a
where
a ->> 'actionType' = 'ONS'

Get action details for rules that have the Oracle Streaming Service action type

select
id as rule_id,
display_name,
is_enabled,
a ->> 'actionType' as action_type,
a ->> 'id' as action_id,
a ->> 'isEnabled' as action_is_enabled,
a ->> 'lifecycleState' as action_state,
a ->> 'streamId' as stream_id
from
oci_events_rule,
jsonb_array_elements(actions) as a
where
a ->> 'actionType' = 'OSS'

Get event type details for each rule

select
id as rule_id,
display_name,
condition ->> 'eventType' as event_type
from
oci_events_rule;

.inspect oci_events_rule

OCI Events Rule

NameTypeDescription
actionsjsonbAn object that represents an action to trigger for events that match a rule.
compartment_idtextColumnDescriptionCompartment
conditionjsonbA filter that specifies the event that will trigger actions associated with this rule.
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.
descriptiontextA string that describes the details of the rule.
display_nametextA string that describes the rule.
freeform_tagsjsonbFree-form tags for resource. This tags can be applied by any user with permissions on the resource.
idtextThe OCID of this rule.
is_enabledbooleanIndicates whether or not this rule is currently enabled.
lifecycle_messagetextA message generated by the Events service about the current state of this rule.
lifecycle_statetextThe current state of the rule.
regiontextThe OCI region in which the resource is located.
tagsjsonbA map of tags for the resource.
tenant_idtextThe OCID of the Tenant in which the resource is located.
time_createdtimestamp without time zoneThe time this rule was created.
titletextTitle of the resource.