v1.0 for Steampipe, Powerpipe, Flowpipe, 116 plugins, and 44 mods →

Plugins Docs Home

turbot/oci_insights

0Controls

0Variables

autoscaling_auto_scaling_configurations_for_compute_instance blockstorage_block_volume_1_year blockstorage_block_volume_24_hrs blockstorage_block_volume_30_days blockstorage_block_volume_365_days blockstorage_block_volume_90_days blockstorage_block_volume_age_report blockstorage_block_volume_attached_instances blockstorage_block_volume_backup_policies_for_blockstorage_block_volume blockstorage_block_volume_backup_policy_schedules blockstorage_block_volume_backups_for_blockstorage_block_volume blockstorage_block_volume_by_compartment blockstorage_block_volume_by_creation_month blockstorage_block_volume_by_encryption_type blockstorage_block_volume_by_region blockstorage_block_volume_by_tenancy blockstorage_block_volume_count blockstorage_block_volume_customer_managed_encryption_count blockstorage_block_volume_default_backup_policies_for_blockstorage_block_volume blockstorage_block_volume_default_encrypted_volumes_count blockstorage_block_volume_encryption blockstorage_block_volume_encryption_report blockstorage_block_volume_input blockstorage_block_volume_overview blockstorage_block_volume_replicas_for_blockstorage_block_volume blockstorage_block_volume_storage blockstorage_block_volume_storage_by_compartment blockstorage_block_volume_storage_by_creation_month blockstorage_block_volume_storage_by_encryption_type blockstorage_block_volume_storage_by_region blockstorage_block_volume_storage_by_tenancy blockstorage_block_volume_storage_total blockstorage_block_volume_tags blockstorage_block_volume_unattached_count blockstorage_block_volume_unattached_report blockstorage_block_volume_vpu blockstorage_block_volume_with_backups blockstorage_block_volume_with_no_backups_count blockstorage_block_volumes_for_compute_instance blockstorage_block_volumes_for_kms_key blockstorage_boot_volume_1_year blockstorage_boot_volume_24_hrs blockstorage_boot_volume_30_days blockstorage_boot_volume_365_days blockstorage_boot_volume_90_days blockstorage_boot_volume_age_report blockstorage_boot_volume_attached_instances blockstorage_boot_volume_backup_policies_for_blockstorage_boot_volume blockstorage_boot_volume_backup_policy_schedules blockstorage_boot_volume_backups_for_blockstorage_boot_volume blockstorage_boot_volume_by_compartment blockstorage_boot_volume_by_creation_month blockstorage_boot_volume_by_encryption_status blockstorage_boot_volume_by_region blockstorage_boot_volume_by_tenancy blockstorage_boot_volume_count blockstorage_boot_volume_customer_managed_encryption_count blockstorage_boot_volume_default_backup_policies_for_blockstorage_boot_volume blockstorage_boot_volume_default_encrypted_volumes_count blockstorage_boot_volume_encryption blockstorage_boot_volume_encryption_report blockstorage_boot_volume_input blockstorage_boot_volume_overview blockstorage_boot_volume_replicas_for_blockstorage_boot_volume blockstorage_boot_volume_storage blockstorage_boot_volume_storage_by_compartment blockstorage_boot_volume_storage_by_creation_month blockstorage_boot_volume_storage_by_encryption_type blockstorage_boot_volume_storage_by_region blockstorage_boot_volume_storage_by_tenancy blockstorage_boot_volume_storage_total blockstorage_boot_volume_tags blockstorage_boot_volume_top_10_read_ops_avg blockstorage_boot_volume_top_10_write_ops_avg blockstorage_boot_volume_unattached_count blockstorage_boot_volume_unattached_report blockstorage_boot_volume_vpu blockstorage_boot_volume_with_backups blockstorage_boot_volume_with_no_backups_count blockstorage_boot_volumes_for_compute_instance blockstorage_boot_volumes_for_kms_key compartment_count compartment_table compute_images_for_blockstorage_boot_volume compute_images_for_compute_instance compute_instance_1_year compute_instance_24_hrs compute_instance_30_days compute_instance_365_days compute_instance_90_days compute_instance_age_report compute_instance_by_compartment compute_instance_by_creation_month compute_instance_by_monitoring compute_instance_by_public_ip compute_instance_by_region compute_instance_by_tenancy compute_instance_by_type compute_instance_core compute_instance_count compute_instance_input compute_instance_launch_options compute_instance_monitoring compute_instance_monitoring_disabled_count compute_instance_overview compute_instance_public compute_instance_public_instance_count compute_instance_security_groups compute_instance_shape compute_instance_state compute_instance_tag compute_instance_total_cores compute_instance_vnic compute_instances_by_cpu_utilization_category compute_instances_for_blockstorage_block_volume compute_instances_for_blockstorage_boot_volume compute_instances_for_ons_notification_topic compute_instances_for_vcn_network_security_group compute_instances_for_vcn_subnet compute_instances_for_vcn_vcn compute_top10_cpu_past_week database_autonomous_database_access_detail database_autonomous_database_backup database_autonomous_database_core database_autonomous_database_data_guard database_autonomous_database_db database_autonomous_database_input database_autonomous_database_overview database_autonomous_database_private_endpoint database_autonomous_database_tag database_autonomous_databases_for_kms_key database_autonomous_db_1_year database_autonomous_db_24_hrs database_autonomous_db_30_days database_autonomous_db_365_days database_autonomous_db_90_days database_autonomous_db_age_report database_autonomous_db_by_compartment database_autonomous_db_by_cpu_utilization database_autonomous_db_by_creation_month database_autonomous_db_by_operations_insights_count database_autonomous_db_by_operations_insights_status database_autonomous_db_by_region database_autonomous_db_by_storage_utilization database_autonomous_db_by_tenancy database_autonomous_db_by_workload_type database_autonomous_db_count database_autonomous_db_data_guard_status database_autonomous_db_operations_insights database_autonomous_db_total_cores database_autonomous_db_total_size database_autonomous_db_with_data_guard_count file_storage_file_systems_for_kms_key filestorage_filesystem_1_year filestorage_filesystem_24_hrs filestorage_filesystem_30_days filestorage_filesystem_365_days filestorage_filesystem_90_days filestorage_filesystem_age_report filestorage_filesystem_by_compartment filestorage_filesystem_by_creation_month filestorage_filesystem_by_region filestorage_filesystem_by_tenancy filestorage_filesystem_cloned filestorage_filesystem_cloned_count filestorage_filesystem_count filestorage_filesystem_encryption filestorage_filesystem_input filestorage_filesystem_overview filestorage_filesystem_snapshot filestorage_filesystem_snapshot_count filestorage_filesystem_snapshot_detail filestorage_filesystem_source filestorage_filesystem_tag filestorage_mount_targets_for_filestorage_file_system filestorage_mount_targets_for_vcn_network_security_group filestorage_snapshots_for_filestorage_file_system identity_api_key_1_year identity_api_key_24_hrs identity_api_key_30_days identity_api_key_365_days identity_api_key_90_days identity_api_key_age_report identity_api_key_count identity_api_key_for_identity_user identity_auth_token_for_identity_user identity_availability_domains_for_vcn_subnet identity_availability_domains_for_vcn_vcn identity_customer_secret_key_1_year identity_customer_secret_key_24_hrs identity_customer_secret_key_30_days identity_customer_secret_key_365_days identity_customer_secret_key_90_days identity_customer_secret_key_age_report identity_customer_secret_key_count identity_customer_secret_key_for_identity_user identity_group_count identity_group_input identity_group_lifecycle_state identity_group_overview identity_group_user identity_groups_by_creation_month identity_groups_by_tenancy identity_groups_for_identity_user identity_groups_with_policy identity_groups_without_policies_count identity_groups_without_users identity_groups_without_users_count identity_policies_for_group identity_policies_for_identity_group identity_user_access_key identity_user_by_groups identity_user_by_type identity_user_by_verified_email identity_user_count identity_user_email identity_user_group identity_user_input identity_user_mfa identity_user_mfa_disabled_count identity_user_mfa_enabled identity_user_mfa_report identity_user_not_attached_to_group identity_user_overview identity_user_password identity_user_tag identity_users_by_creation_month identity_users_by_tenancy identity_users_for_identity_group identity_users_for_objectstorage_bucket key_vault_input kms_hsm_key_count kms_key_1_year kms_key_24_hrs kms_key_30_days kms_key_365_days kms_key_90_days kms_key_age_report kms_key_by_compartment kms_key_by_creation_month kms_key_by_protection_mode kms_key_by_region kms_key_by_tenancy kms_key_count kms_key_detail kms_key_disabled kms_key_disabled_count kms_key_input kms_key_lifecycle_state kms_key_overview kms_key_protection_mode kms_key_tag kms_key_versions_for_kms_key kms_keys_for_blockstorage_block_volume kms_keys_for_blockstorage_boot_volume kms_keys_for_database_autonomous_database kms_keys_for_filestorage_file_system kms_keys_for_kms_vault kms_keys_for_objectstorage_bucket kms_vault_1_year kms_vault_24_hrs kms_vault_30_days kms_vault_365_days kms_vault_90_days kms_vault_age_report kms_vault_by_compartment kms_vault_by_creation_month kms_vault_by_region kms_vault_by_tenancy kms_vault_by_type kms_vault_count kms_vault_disabled kms_vault_disabled_count kms_vault_endpoints kms_vault_lifecycle_state kms_vault_overview kms_vault_secrets_for_kms_vault kms_vault_tags kms_vault_type kms_vaults_for_blockstorage_block_volume kms_vaults_for_blockstorage_boot_volume kms_vaults_for_database_autonomous_database kms_vaults_for_filestorage_file_system kms_vaults_for_kms_key kms_vaults_for_objectstorage_bucket mysql_automatic_backup_count mysql_backup_1_year mysql_backup_24_hrs mysql_backup_30_days mysql_backup_365_days mysql_backup_90_days mysql_backup_age_report mysql_backup_by_backup_type mysql_backup_by_compartment mysql_backup_by_creation_month mysql_backup_by_creation_type mysql_backup_by_region mysql_backup_by_tenancy mysql_backup_count mysql_backup_storage_by_backup_type mysql_backup_storage_by_compartment mysql_backup_storage_by_creation_month mysql_backup_storage_by_creation_type mysql_backup_storage_by_region mysql_backup_storage_by_tenancy mysql_backup_storage_total mysql_backups_for_mysql_db_system mysql_channels_for_mysql_db_system mysql_configurations_for_mysql_db_system mysql_db_system_1_year mysql_db_system_24_hrs mysql_db_system_30_days mysql_db_system_365_days mysql_db_system_90_days mysql_db_system_age_report mysql_db_system_analytics_cluster_attached_count mysql_db_system_backup mysql_db_system_backup_disabled_count mysql_db_system_backup_policy mysql_db_system_by_compartment mysql_db_system_by_cpu_utilization_category mysql_db_system_by_creation_month mysql_db_system_by_region mysql_db_system_by_tenancy mysql_db_system_connection mysql_db_system_count mysql_db_system_endpoint mysql_db_system_heat_wave_cluster_attached_count mysql_db_system_input mysql_db_system_mysql_version mysql_db_system_overview mysql_db_system_storage_by_compartment mysql_db_system_storage_by_creation_month mysql_db_system_storage_by_region mysql_db_system_storage_by_tenancy mysql_db_system_storage_total mysql_db_system_tag mysql_db_system_top10_cpu_past_week mysql_db_system_with_backups mysql_full_backup_count nosql_table_1_year nosql_table_24_hrs nosql_table_30_days nosql_table_365_days nosql_table_90_days nosql_table_age_report nosql_table_auto_reclaimable nosql_table_by_compartment nosql_table_by_creation_month nosql_table_by_region nosql_table_by_tenancy nosql_table_children_for_nosql_table nosql_table_column nosql_table_count nosql_table_input nosql_table_limits nosql_table_overview nosql_table_parents_for_nosql_table nosql_table_read_throttle nosql_table_state nosql_table_tag nosql_table_top_10_read_throttle_count_avg nosql_table_top_10_write_throttle_count_avg nosql_table_write_throttle objectstorage_bucket_1_year objectstorage_bucket_24_hrs objectstorage_bucket_30_days objectstorage_bucket_365_days objectstorage_bucket_90_days objectstorage_bucket_access objectstorage_bucket_age_report objectstorage_bucket_archived_count objectstorage_bucket_by_compartment objectstorage_bucket_by_creation_month objectstorage_bucket_by_region objectstorage_bucket_by_tenancy objectstorage_bucket_count objectstorage_bucket_default_encryption_count objectstorage_bucket_encryption objectstorage_bucket_encryption_report objectstorage_bucket_encryption_status objectstorage_bucket_input objectstorage_bucket_lifecycle_report objectstorage_bucket_logging_disabled_count objectstorage_bucket_logging_report objectstorage_bucket_logging_status objectstorage_bucket_object_lifecycle_policy objectstorage_bucket_overview objectstorage_bucket_public_access objectstorage_bucket_public_access_count objectstorage_bucket_public_access_report objectstorage_bucket_public_access_status objectstorage_bucket_read_only objectstorage_bucket_read_only_access_count objectstorage_bucket_report_customer_managed_encryption_count objectstorage_bucket_tag objectstorage_bucket_versioning objectstorage_bucket_versioning_disabled_count objectstorage_bucket_versioning_status objectstorage_buckets_for_kms_key objectstorage_objects_for_objectstorage_bucket oci_vcn_by_compartment oci_vcn_by_region oci_vcn_by_rfc1918_range oci_vcn_by_tenancy oci_vcn_count oci_vcn_no_subnet oci_vcn_no_subnet_count oci_vcn_security_group_by_ingress_rdp oci_vcn_security_group_by_ingress_ssh oci_vcn_security_group_count oci_vcn_security_group_unrestricted_ingress_rdp_count oci_vcn_security_group_unrestricted_ingress_ssh_count oci_vcn_security_groups_by_compartment oci_vcn_security_groups_by_region oci_vcn_security_groups_by_tenancy oci_vcn_security_groups_by_vcn oci_vcn_security_list_by_compartment oci_vcn_security_list_by_ingress_rdp oci_vcn_security_list_by_ingress_ssh oci_vcn_security_list_by_region oci_vcn_security_list_by_tenancy oci_vcn_security_list_by_vcn oci_vcn_security_list_count oci_vcn_security_list_unrestricted_ingress_rdp_count oci_vcn_security_list_unrestricted_ingress_ssh_count oci_vcn_subnet_by_compartment oci_vcn_subnet_by_flow_logs oci_vcn_subnet_by_region oci_vcn_subnet_by_tenancy oci_vcn_subnet_by_vcn oci_vcn_subnet_count oci_vcn_subnet_flow_logs_not_configured_count oci_vcn_subnet_flow_logs_report ons_notification_topic_1_year ons_notification_topic_24_hrs ons_notification_topic_30_days ons_notification_topic_365_days ons_notification_topic_90_days ons_notification_topic_age_report ons_notification_topic_by_compartment ons_notification_topic_by_creation_month ons_notification_topic_by_region ons_notification_topic_by_subscription ons_notification_topic_by_tenancy ons_notification_topic_count ons_notification_topic_input ons_notification_topic_overview ons_notification_topic_state ons_notification_topic_subscription ons_notification_topic_tag ons_notification_topic_unused_count ons_notification_topics_for_compute_instance ons_subscription_1_year ons_subscription_24_hrs ons_subscription_30_days ons_subscription_365_days ons_subscription_90_days ons_subscription_age_report ons_subscription_by_compartment ons_subscription_by_creation_month ons_subscription_by_lifecycle_state ons_subscription_by_region ons_subscription_by_tenancy ons_subscription_count ons_subscription_unused_count ons_subscriptions_for_ons_notification_topic regional_identity_availability_domains_for_vcn_subnet regional_identity_availability_domains_for_vcn_vcn source_blockstorage_block_volume_clones_for_blockstorage_block_volume source_blockstorage_boot_volume_clones_for_blockstorage_boot_volume target_blockstorage_block_volume_clones_for_blockstorage_block_volume target_blockstorage_boot_volume_clones_for_blockstorage_boot_volume tenancy_count tenancy_table vcn_attached_nsg_count vcn_attached_sl_count vcn_attached_subnet_count vcn_cidr_blocks vcn_dhcp_options vcn_dhcp_options_for_vcn_subnet vcn_dhcp_options_for_vcn_vcn vcn_flow_logs_for_vcn_subnet vcn_flow_logs_for_vcn_vcn vcn_gateway_sankey vcn_gateways_table vcn_input vcn_internet_gateways_for_vcn_vcn vcn_ipv4_count vcn_ipv6_count vcn_load_balancers_for_compute_instance vcn_load_balancers_for_vcn_network_security_group vcn_load_balancers_for_vcn_subnet vcn_load_balancers_for_vcn_vcn vcn_local_peering_gateways_for_vcn_vcn vcn_nat_gateways_for_vcn_vcn vcn_network_load_balancers_for_compute_instance vcn_network_load_balancers_for_vcn_network_security_group vcn_network_load_balancers_for_vcn_subnet vcn_network_load_balancers_for_vcn_vcn vcn_network_security_group_assoc vcn_network_security_group_egress_rule vcn_network_security_group_egress_rules_count vcn_network_security_group_ingress_rdp vcn_network_security_group_ingress_rule vcn_network_security_group_ingress_rules_count vcn_network_security_group_ingress_ssh vcn_network_security_group_input vcn_network_security_group_overview vcn_network_security_group_tag vcn_network_security_groups_for_compute_instance vcn_network_security_groups_for_database_autonomous_database vcn_network_security_groups_for_filestorage_file_system vcn_network_security_groups_for_vcn_vcn vcn_network_security_list_egress_rule vcn_network_security_list_ingress_rule vcn_nsl_egress_rule_sankey vcn_nsl_ingress_rule_sankey vcn_overview vcn_route_table vcn_route_tables_for_vcn_subnet vcn_route_tables_for_vcn_vcn vcn_security_group vcn_security_list vcn_security_list_ingress_rdp vcn_security_list_ingress_ssh vcn_security_list_input vcn_security_list_overview vcn_security_list_tag vcn_security_lists_for_vcn_subnet vcn_security_lists_for_vcn_vcn vcn_service_gateways_for_vcn_vcn vcn_subnet vcn_subnet_cidr_block vcn_subnet_flow_logs vcn_subnet_input vcn_subnet_overview vcn_subnet_tag vcn_subnets_for_compute_instance vcn_subnets_for_database_autonomous_database vcn_subnets_for_filestorage_file_system vcn_subnets_for_mysql_db_system vcn_subnets_for_vcn_security_list vcn_subnets_for_vcn_vcn vcn_tag vcn_vcns_for_compute_instance vcn_vcns_for_database_autonomous_database vcn_vcns_for_mysql_db_system vcn_vcns_for_vcn_network_security_group vcn_vcns_for_vcn_security_list vcn_vcns_for_vcn_subnet vcn_vnics_for_compute_instance vcn_vnics_for_vcn_network_security_group

Query: database_autonomous_db_1_year

Usage

powerpipe query oci_insights.query.database_autonomous_db_1_year

Steampipe Tables

oci_database_autonomous_database

Oracle Cloud Infrastructure plugin

SQL

select
  count(*) as value,
  '> 1 Year' as label
from
  oci_database_autonomous_database
where
  lifecycle_state <> 'TERMINATED' and time_created <= now() - '1 year' :: interval;

Dashboards

The query is used in the dashboards:

OCI Database Autonomous DB Age Report