autoscaling_auto_scaling_configurations_for_compute_instanceblockstorage_block_volume_1_yearblockstorage_block_volume_24_hrsblockstorage_block_volume_30_daysblockstorage_block_volume_365_daysblockstorage_block_volume_90_daysblockstorage_block_volume_age_reportblockstorage_block_volume_attached_instancesblockstorage_block_volume_backup_policies_for_blockstorage_block_volumeblockstorage_block_volume_backup_policy_schedulesblockstorage_block_volume_backups_for_blockstorage_block_volumeblockstorage_block_volume_by_compartmentblockstorage_block_volume_by_creation_monthblockstorage_block_volume_by_encryption_typeblockstorage_block_volume_by_regionblockstorage_block_volume_by_tenancyblockstorage_block_volume_countblockstorage_block_volume_customer_managed_encryption_countblockstorage_block_volume_default_backup_policies_for_blockstorage_block_volumeblockstorage_block_volume_default_encrypted_volumes_countblockstorage_block_volume_encryptionblockstorage_block_volume_encryption_reportblockstorage_block_volume_inputblockstorage_block_volume_overviewblockstorage_block_volume_replicas_for_blockstorage_block_volumeblockstorage_block_volume_storageblockstorage_block_volume_storage_by_compartmentblockstorage_block_volume_storage_by_creation_monthblockstorage_block_volume_storage_by_encryption_typeblockstorage_block_volume_storage_by_regionblockstorage_block_volume_storage_by_tenancyblockstorage_block_volume_storage_totalblockstorage_block_volume_tagsblockstorage_block_volume_unattached_countblockstorage_block_volume_unattached_reportblockstorage_block_volume_vpublockstorage_block_volume_with_backupsblockstorage_block_volume_with_no_backups_countblockstorage_block_volumes_for_compute_instanceblockstorage_block_volumes_for_kms_keyblockstorage_boot_volume_1_yearblockstorage_boot_volume_24_hrsblockstorage_boot_volume_30_daysblockstorage_boot_volume_365_daysblockstorage_boot_volume_90_daysblockstorage_boot_volume_age_reportblockstorage_boot_volume_attached_instancesblockstorage_boot_volume_backup_policies_for_blockstorage_boot_volumeblockstorage_boot_volume_backup_policy_schedulesblockstorage_boot_volume_backups_for_blockstorage_boot_volumeblockstorage_boot_volume_by_compartmentblockstorage_boot_volume_by_creation_monthblockstorage_boot_volume_by_encryption_statusblockstorage_boot_volume_by_regionblockstorage_boot_volume_by_tenancyblockstorage_boot_volume_countblockstorage_boot_volume_customer_managed_encryption_countblockstorage_boot_volume_default_backup_policies_for_blockstorage_boot_volumeblockstorage_boot_volume_default_encrypted_volumes_countblockstorage_boot_volume_encryptionblockstorage_boot_volume_encryption_reportblockstorage_boot_volume_inputblockstorage_boot_volume_overviewblockstorage_boot_volume_replicas_for_blockstorage_boot_volumeblockstorage_boot_volume_storageblockstorage_boot_volume_storage_by_compartmentblockstorage_boot_volume_storage_by_creation_monthblockstorage_boot_volume_storage_by_encryption_typeblockstorage_boot_volume_storage_by_regionblockstorage_boot_volume_storage_by_tenancyblockstorage_boot_volume_storage_totalblockstorage_boot_volume_tagsblockstorage_boot_volume_top_10_read_ops_avgblockstorage_boot_volume_top_10_write_ops_avgblockstorage_boot_volume_unattached_countblockstorage_boot_volume_unattached_reportblockstorage_boot_volume_vpublockstorage_boot_volume_with_backupsblockstorage_boot_volume_with_no_backups_countblockstorage_boot_volumes_for_compute_instanceblockstorage_boot_volumes_for_kms_keycompartment_countcompartment_tablecompute_images_for_blockstorage_boot_volumecompute_images_for_compute_instancecompute_instance_1_yearcompute_instance_24_hrscompute_instance_30_dayscompute_instance_365_dayscompute_instance_90_dayscompute_instance_age_reportcompute_instance_by_compartmentcompute_instance_by_creation_monthcompute_instance_by_monitoringcompute_instance_by_public_ipcompute_instance_by_regioncompute_instance_by_tenancycompute_instance_by_typecompute_instance_corecompute_instance_countcompute_instance_inputcompute_instance_launch_optionscompute_instance_monitoringcompute_instance_monitoring_disabled_countcompute_instance_overviewcompute_instance_publiccompute_instance_public_instance_countcompute_instance_security_groupscompute_instance_shapecompute_instance_statecompute_instance_tagcompute_instance_total_corescompute_instance_vniccompute_instances_by_cpu_utilization_categorycompute_instances_for_blockstorage_block_volumecompute_instances_for_blockstorage_boot_volumecompute_instances_for_ons_notification_topiccompute_instances_for_vcn_network_security_groupcompute_instances_for_vcn_subnetcompute_instances_for_vcn_vcncompute_top10_cpu_past_weekdatabase_autonomous_database_access_detaildatabase_autonomous_database_backupdatabase_autonomous_database_coredatabase_autonomous_database_data_guarddatabase_autonomous_database_dbdatabase_autonomous_database_inputdatabase_autonomous_database_overviewdatabase_autonomous_database_private_endpointdatabase_autonomous_database_tagdatabase_autonomous_databases_for_kms_keydatabase_autonomous_db_1_yeardatabase_autonomous_db_24_hrsdatabase_autonomous_db_30_daysdatabase_autonomous_db_365_daysdatabase_autonomous_db_90_daysdatabase_autonomous_db_age_reportdatabase_autonomous_db_by_compartmentdatabase_autonomous_db_by_cpu_utilizationdatabase_autonomous_db_by_creation_monthdatabase_autonomous_db_by_operations_insights_countdatabase_autonomous_db_by_operations_insights_statusdatabase_autonomous_db_by_regiondatabase_autonomous_db_by_storage_utilizationdatabase_autonomous_db_by_tenancydatabase_autonomous_db_by_workload_typedatabase_autonomous_db_countdatabase_autonomous_db_data_guard_statusdatabase_autonomous_db_operations_insightsdatabase_autonomous_db_total_coresdatabase_autonomous_db_total_sizedatabase_autonomous_db_with_data_guard_countfile_storage_file_systems_for_kms_keyfilestorage_filesystem_1_yearfilestorage_filesystem_24_hrsfilestorage_filesystem_30_daysfilestorage_filesystem_365_daysfilestorage_filesystem_90_daysfilestorage_filesystem_age_reportfilestorage_filesystem_by_compartmentfilestorage_filesystem_by_creation_monthfilestorage_filesystem_by_regionfilestorage_filesystem_by_tenancyfilestorage_filesystem_clonedfilestorage_filesystem_cloned_countfilestorage_filesystem_countfilestorage_filesystem_encryptionfilestorage_filesystem_inputfilestorage_filesystem_overviewfilestorage_filesystem_snapshotfilestorage_filesystem_snapshot_countfilestorage_filesystem_snapshot_detailfilestorage_filesystem_sourcefilestorage_filesystem_tagfilestorage_mount_targets_for_filestorage_file_systemfilestorage_mount_targets_for_vcn_network_security_groupfilestorage_snapshots_for_filestorage_file_systemidentity_api_key_1_yearidentity_api_key_24_hrsidentity_api_key_30_daysidentity_api_key_365_daysidentity_api_key_90_daysidentity_api_key_age_reportidentity_api_key_countidentity_api_key_for_identity_useridentity_auth_token_for_identity_useridentity_availability_domains_for_vcn_subnetidentity_availability_domains_for_vcn_vcnidentity_customer_secret_key_1_yearidentity_customer_secret_key_24_hrsidentity_customer_secret_key_30_daysidentity_customer_secret_key_365_daysidentity_customer_secret_key_90_daysidentity_customer_secret_key_age_reportidentity_customer_secret_key_countidentity_customer_secret_key_for_identity_useridentity_group_countidentity_group_inputidentity_group_lifecycle_stateidentity_group_overviewidentity_group_useridentity_groups_by_creation_monthidentity_groups_by_tenancyidentity_groups_for_identity_useridentity_groups_with_policyidentity_groups_without_policies_countidentity_groups_without_usersidentity_groups_without_users_countidentity_policies_for_groupidentity_policies_for_identity_groupidentity_user_access_keyidentity_user_by_groupsidentity_user_by_typeidentity_user_by_verified_emailidentity_user_countidentity_user_emailidentity_user_groupidentity_user_inputidentity_user_mfaidentity_user_mfa_disabled_countidentity_user_mfa_enabledidentity_user_mfa_reportidentity_user_not_attached_to_groupidentity_user_overviewidentity_user_passwordidentity_user_tagidentity_users_by_creation_monthidentity_users_by_tenancyidentity_users_for_identity_groupidentity_users_for_objectstorage_bucketkey_vault_inputkms_hsm_key_countkms_key_1_yearkms_key_24_hrskms_key_30_dayskms_key_365_dayskms_key_90_dayskms_key_age_reportkms_key_by_compartmentkms_key_by_creation_monthkms_key_by_protection_modekms_key_by_regionkms_key_by_tenancykms_key_countkms_key_detailkms_key_disabledkms_key_disabled_countkms_key_inputkms_key_lifecycle_statekms_key_overviewkms_key_protection_modekms_key_tagkms_key_versions_for_kms_keykms_keys_for_blockstorage_block_volumekms_keys_for_blockstorage_boot_volumekms_keys_for_database_autonomous_databasekms_keys_for_filestorage_file_systemkms_keys_for_kms_vaultkms_keys_for_objectstorage_bucketkms_vault_1_yearkms_vault_24_hrskms_vault_30_dayskms_vault_365_dayskms_vault_90_dayskms_vault_age_reportkms_vault_by_compartmentkms_vault_by_creation_monthkms_vault_by_regionkms_vault_by_tenancykms_vault_by_typekms_vault_countkms_vault_disabledkms_vault_disabled_countkms_vault_endpointskms_vault_lifecycle_statekms_vault_overviewkms_vault_secrets_for_kms_vaultkms_vault_tagskms_vault_typekms_vaults_for_blockstorage_block_volumekms_vaults_for_blockstorage_boot_volumekms_vaults_for_database_autonomous_databasekms_vaults_for_filestorage_file_systemkms_vaults_for_kms_keykms_vaults_for_objectstorage_bucketmysql_automatic_backup_countmysql_backup_1_yearmysql_backup_24_hrsmysql_backup_30_daysmysql_backup_365_daysmysql_backup_90_daysmysql_backup_age_reportmysql_backup_by_backup_typemysql_backup_by_compartmentmysql_backup_by_creation_monthmysql_backup_by_creation_typemysql_backup_by_regionmysql_backup_by_tenancymysql_backup_countmysql_backup_storage_by_backup_typemysql_backup_storage_by_compartmentmysql_backup_storage_by_creation_monthmysql_backup_storage_by_creation_typemysql_backup_storage_by_regionmysql_backup_storage_by_tenancymysql_backup_storage_totalmysql_backups_for_mysql_db_systemmysql_channels_for_mysql_db_systemmysql_configurations_for_mysql_db_systemmysql_db_system_1_yearmysql_db_system_24_hrsmysql_db_system_30_daysmysql_db_system_365_daysmysql_db_system_90_daysmysql_db_system_age_reportmysql_db_system_analytics_cluster_attached_countmysql_db_system_backupmysql_db_system_backup_disabled_countmysql_db_system_backup_policymysql_db_system_by_compartmentmysql_db_system_by_cpu_utilization_categorymysql_db_system_by_creation_monthmysql_db_system_by_regionmysql_db_system_by_tenancymysql_db_system_connectionmysql_db_system_countmysql_db_system_endpointmysql_db_system_heat_wave_cluster_attached_countmysql_db_system_inputmysql_db_system_mysql_versionmysql_db_system_overviewmysql_db_system_storage_by_compartmentmysql_db_system_storage_by_creation_monthmysql_db_system_storage_by_regionmysql_db_system_storage_by_tenancymysql_db_system_storage_totalmysql_db_system_tagmysql_db_system_top10_cpu_past_weekmysql_db_system_with_backupsmysql_full_backup_countnosql_table_1_yearnosql_table_24_hrsnosql_table_30_daysnosql_table_365_daysnosql_table_90_daysnosql_table_age_reportnosql_table_auto_reclaimablenosql_table_by_compartmentnosql_table_by_creation_monthnosql_table_by_regionnosql_table_by_tenancynosql_table_children_for_nosql_tablenosql_table_columnnosql_table_countnosql_table_inputnosql_table_limitsnosql_table_overviewnosql_table_parents_for_nosql_tablenosql_table_read_throttlenosql_table_statenosql_table_tagnosql_table_top_10_read_throttle_count_avgnosql_table_top_10_write_throttle_count_avgnosql_table_write_throttleobjectstorage_bucket_1_yearobjectstorage_bucket_24_hrsobjectstorage_bucket_30_daysobjectstorage_bucket_365_daysobjectstorage_bucket_90_daysobjectstorage_bucket_accessobjectstorage_bucket_age_reportobjectstorage_bucket_archived_countobjectstorage_bucket_by_compartmentobjectstorage_bucket_by_creation_monthobjectstorage_bucket_by_regionobjectstorage_bucket_by_tenancyobjectstorage_bucket_countobjectstorage_bucket_default_encryption_countobjectstorage_bucket_encryptionobjectstorage_bucket_encryption_reportobjectstorage_bucket_encryption_statusobjectstorage_bucket_inputobjectstorage_bucket_lifecycle_reportobjectstorage_bucket_logging_disabled_countobjectstorage_bucket_logging_reportobjectstorage_bucket_logging_statusobjectstorage_bucket_object_lifecycle_policyobjectstorage_bucket_overviewobjectstorage_bucket_public_accessobjectstorage_bucket_public_access_countobjectstorage_bucket_public_access_reportobjectstorage_bucket_public_access_statusobjectstorage_bucket_read_onlyobjectstorage_bucket_read_only_access_countobjectstorage_bucket_report_customer_managed_encryption_countobjectstorage_bucket_tagobjectstorage_bucket_versioningobjectstorage_bucket_versioning_disabled_countobjectstorage_bucket_versioning_statusobjectstorage_buckets_for_kms_keyobjectstorage_objects_for_objectstorage_bucketoci_vcn_by_compartmentoci_vcn_by_regionoci_vcn_by_rfc1918_rangeoci_vcn_by_tenancyoci_vcn_countoci_vcn_no_subnetoci_vcn_no_subnet_countoci_vcn_security_group_by_ingress_rdpoci_vcn_security_group_by_ingress_sshoci_vcn_security_group_countoci_vcn_security_group_unrestricted_ingress_rdp_countoci_vcn_security_group_unrestricted_ingress_ssh_countoci_vcn_security_groups_by_compartmentoci_vcn_security_groups_by_regionoci_vcn_security_groups_by_tenancyoci_vcn_security_groups_by_vcnoci_vcn_security_list_by_compartmentoci_vcn_security_list_by_ingress_rdpoci_vcn_security_list_by_ingress_sshoci_vcn_security_list_by_regionoci_vcn_security_list_by_tenancyoci_vcn_security_list_by_vcnoci_vcn_security_list_countoci_vcn_security_list_unrestricted_ingress_rdp_countoci_vcn_security_list_unrestricted_ingress_ssh_countoci_vcn_subnet_by_compartmentoci_vcn_subnet_by_flow_logsoci_vcn_subnet_by_regionoci_vcn_subnet_by_tenancyoci_vcn_subnet_by_vcnoci_vcn_subnet_countoci_vcn_subnet_flow_logs_not_configured_countoci_vcn_subnet_flow_logs_reportons_notification_topic_1_yearons_notification_topic_24_hrsons_notification_topic_30_daysons_notification_topic_365_daysons_notification_topic_90_daysons_notification_topic_age_reportons_notification_topic_by_compartmentons_notification_topic_by_creation_monthons_notification_topic_by_regionons_notification_topic_by_subscriptionons_notification_topic_by_tenancyons_notification_topic_countons_notification_topic_inputons_notification_topic_overviewons_notification_topic_stateons_notification_topic_subscriptionons_notification_topic_tagons_notification_topic_unused_countons_notification_topics_for_compute_instanceons_subscription_1_yearons_subscription_24_hrsons_subscription_30_daysons_subscription_365_daysons_subscription_90_daysons_subscription_age_reportons_subscription_by_compartmentons_subscription_by_creation_monthons_subscription_by_lifecycle_stateons_subscription_by_regionons_subscription_by_tenancyons_subscription_countons_subscription_unused_countons_subscriptions_for_ons_notification_topicregional_identity_availability_domains_for_vcn_subnetregional_identity_availability_domains_for_vcn_vcnsource_blockstorage_block_volume_clones_for_blockstorage_block_volumesource_blockstorage_boot_volume_clones_for_blockstorage_boot_volumetarget_blockstorage_block_volume_clones_for_blockstorage_block_volumetarget_blockstorage_boot_volume_clones_for_blockstorage_boot_volumetenancy_counttenancy_tablevcn_attached_nsg_countvcn_attached_sl_countvcn_attached_subnet_countvcn_cidr_blocksvcn_dhcp_optionsvcn_dhcp_options_for_vcn_subnetvcn_dhcp_options_for_vcn_vcnvcn_flow_logs_for_vcn_subnetvcn_flow_logs_for_vcn_vcnvcn_gateway_sankeyvcn_gateways_tablevcn_inputvcn_internet_gateways_for_vcn_vcnvcn_ipv4_countvcn_ipv6_countvcn_load_balancers_for_compute_instancevcn_load_balancers_for_vcn_network_security_groupvcn_load_balancers_for_vcn_subnetvcn_load_balancers_for_vcn_vcnvcn_local_peering_gateways_for_vcn_vcnvcn_nat_gateways_for_vcn_vcnvcn_network_load_balancers_for_compute_instancevcn_network_load_balancers_for_vcn_network_security_groupvcn_network_load_balancers_for_vcn_subnetvcn_network_load_balancers_for_vcn_vcnvcn_network_security_group_assocvcn_network_security_group_egress_rulevcn_network_security_group_egress_rules_countvcn_network_security_group_ingress_rdpvcn_network_security_group_ingress_rulevcn_network_security_group_ingress_rules_countvcn_network_security_group_ingress_sshvcn_network_security_group_inputvcn_network_security_group_overviewvcn_network_security_group_tagvcn_network_security_groups_for_compute_instancevcn_network_security_groups_for_database_autonomous_databasevcn_network_security_groups_for_filestorage_file_systemvcn_network_security_groups_for_vcn_vcnvcn_network_security_list_egress_rulevcn_network_security_list_ingress_rulevcn_nsl_egress_rule_sankeyvcn_nsl_ingress_rule_sankeyvcn_overviewvcn_route_tablevcn_route_tables_for_vcn_subnetvcn_route_tables_for_vcn_vcnvcn_security_groupvcn_security_listvcn_security_list_ingress_rdpvcn_security_list_ingress_sshvcn_security_list_inputvcn_security_list_overviewvcn_security_list_tagvcn_security_lists_for_vcn_subnetvcn_security_lists_for_vcn_vcnvcn_service_gateways_for_vcn_vcnvcn_subnetvcn_subnet_cidr_blockvcn_subnet_flow_logsvcn_subnet_inputvcn_subnet_overviewvcn_subnet_tagvcn_subnets_for_compute_instancevcn_subnets_for_database_autonomous_databasevcn_subnets_for_filestorage_file_systemvcn_subnets_for_mysql_db_systemvcn_subnets_for_vcn_security_listvcn_subnets_for_vcn_vcnvcn_tagvcn_vcns_for_compute_instancevcn_vcns_for_database_autonomous_databasevcn_vcns_for_mysql_db_systemvcn_vcns_for_vcn_network_security_groupvcn_vcns_for_vcn_security_listvcn_vcns_for_vcn_subnetvcn_vnics_for_compute_instancevcn_vnics_for_vcn_network_security_group
Query: ons_subscription_by_lifecycle_state
Usage
powerpipe query oci_insights.query.ons_subscription_by_lifecycle_stateSteampipe Tables
SQL
select case when lifecycle_state = 'PENDING' then 'unused' else 'in_use' end as status, count(lifecycle_state)from oci_ons_subscriptionwhere lifecycle_state <> 'DELETED'group by status;