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

Plugins Docs Home

turbot/ibm_insights

0Controls

0Variables

ibm_account_count ibm_account_table ibm_classic_infrastructure_vpc_count ibm_compute_instance_1_year_count ibm_compute_instance_24_hours_count ibm_compute_instance_30_90_days_count ibm_compute_instance_30_days_count ibm_compute_instance_90_365_days_count ibm_compute_instance_age_table ibm_compute_instance_architecture ibm_compute_instance_bandwidth ibm_compute_instance_boot_volume ibm_compute_instance_by_account ibm_compute_instance_by_architecture ibm_compute_instance_by_creation_month ibm_compute_instance_by_floating_ip ibm_compute_instance_by_region ibm_compute_instance_by_resource_group ibm_compute_instance_by_status ibm_compute_instance_by_zone ibm_compute_instance_count ibm_compute_instance_data_volume ibm_compute_instance_disk_1_year_count ibm_compute_instance_disk_24_hours_count ibm_compute_instance_disk_30_90_days_count ibm_compute_instance_disk_30_days_count ibm_compute_instance_disk_90_365_days_count ibm_compute_instance_disk_age_table ibm_compute_instance_disk_attached_instances ibm_compute_instance_disk_by_account ibm_compute_instance_disk_by_creation_month ibm_compute_instance_disk_by_instance_state ibm_compute_instance_disk_by_interface_type ibm_compute_instance_disk_by_region ibm_compute_instance_disk_count ibm_compute_instance_disk_input ibm_compute_instance_disk_overview ibm_compute_instance_disk_storage ibm_compute_instance_disk_storage_by_account ibm_compute_instance_disk_storage_by_creation_month ibm_compute_instance_disk_storage_by_interface_type ibm_compute_instance_disk_storage_by_region ibm_compute_instance_disk_total_storage ibm_compute_instance_disks ibm_compute_instance_image ibm_compute_instance_input ibm_compute_instance_memory ibm_compute_instance_network_interfaces ibm_compute_instance_overview ibm_compute_instance_status ibm_compute_instance_tags ibm_compute_instance_total_vcpu ibm_compute_instance_total_vcpu_count ibm_compute_instance_vpc ibm_compute_instance_zone ibm_compute_public_instance ibm_compute_public_instance_count ibm_compute_unused_instance_disk ibm_compute_unused_instance_disk_count ibm_inbound_nacl_for_vpc_sankey ibm_is_security_group_1_year_count ibm_is_security_group_24_hours_count ibm_is_security_group_30_90_days_count ibm_is_security_group_30_days_count ibm_is_security_group_90_365_days_count ibm_is_security_group_age_table ibm_is_security_group_association ibm_is_security_group_attached_enis_count ibm_is_security_group_by_acount ibm_is_security_group_by_creation_month ibm_is_security_group_by_region ibm_is_security_group_by_resource_group ibm_is_security_group_by_vpc ibm_is_security_group_count ibm_is_security_group_inbound_rule_sankey ibm_is_security_group_inbound_rules ibm_is_security_group_inbound_rules_count ibm_is_security_group_input ibm_is_security_group_outbound_rule_sankey ibm_is_security_group_outbound_rules ibm_is_security_group_outbound_rules_count ibm_is_security_group_overview ibm_is_security_group_tags ibm_is_security_group_unassociated_count ibm_is_security_group_unassociated_status ibm_is_security_group_unrestricted_inbound ibm_is_security_group_unrestricted_inbound_count ibm_is_security_group_unrestricted_inbound_status ibm_is_security_group_unrestricted_outbound ibm_is_security_group_unrestricted_outbound_count ibm_is_security_group_unrestricted_outbound_status ibm_is_volume_1_year_count ibm_is_volume_24_hours_count ibm_is_volume_30_90_days_count ibm_is_volume_30_days_count ibm_is_volume_90_365_days_count ibm_is_volume_age_table ibm_is_volume_attached_instances ibm_is_volume_attached_instances_count ibm_is_volume_attachment_status ibm_is_volume_by_account ibm_is_volume_by_creation_month ibm_is_volume_by_encryption_type ibm_is_volume_by_profile ibm_is_volume_by_region ibm_is_volume_by_zone ibm_is_volume_count ibm_is_volume_encryption ibm_is_volume_encryption_report ibm_is_volume_encryption_status ibm_is_volume_input ibm_is_volume_iops ibm_is_volume_overview ibm_is_volume_provider_managed_encryption_count ibm_is_volume_state ibm_is_volume_storage ibm_is_volume_storage_by_account ibm_is_volume_storage_by_creation_month ibm_is_volume_storage_by_profile ibm_is_volume_storage_by_region ibm_is_volume_storage_by_zone ibm_is_volume_storage_total ibm_is_volume_tags ibm_is_volume_unattached_count ibm_is_volume_user_managed_encryption_count ibm_is_vpc_1_year_count ibm_is_vpc_24_hours_count ibm_is_vpc_30_90_days_count ibm_is_vpc_30_days_count ibm_is_vpc_90_365_days_count ibm_is_vpc_address_prefixes ibm_is_vpc_age_table ibm_is_vpc_by_account ibm_is_vpc_by_creation_month ibm_is_vpc_by_region ibm_is_vpc_by_resource_group ibm_is_vpc_by_rfc1918_range ibm_is_vpc_by_size ibm_is_vpc_count ibm_is_vpc_cse_source_ip_addresses ibm_is_vpc_empty_status ibm_is_vpc_input ibm_is_vpc_network_acl ibm_is_vpc_no_subnet_count ibm_is_vpc_num_ips_for_vpc ibm_is_vpc_overview ibm_is_vpc_security_groups ibm_is_vpc_subnet_by_zone ibm_is_vpc_subnets_for_vpc ibm_is_vpc_tags ibm_kms_key_1_year_count ibm_kms_key_24_hours_count ibm_kms_key_30_90_days_count ibm_kms_key_30_days_count ibm_kms_key_90_365_days_count ibm_kms_key_age ibm_kms_key_age_table ibm_kms_key_aliases ibm_kms_key_by_account ibm_kms_key_by_algorithm ibm_kms_key_by_creation_month ibm_kms_key_by_region ibm_kms_key_by_state ibm_kms_key_count ibm_kms_key_disabled_count ibm_kms_key_dual_auth_disabled_count ibm_kms_key_dual_auth_status ibm_kms_key_dual_authentication ibm_kms_key_input ibm_kms_key_overview ibm_kms_key_ring ibm_kms_key_state ibm_kms_key_state_details ibm_kms_key_type ibm_kms_root_key_count ibm_kms_root_key_rotation_disabled_count ibm_kms_root_key_rotation_enabled ibm_kms_root_key_rotation_status ibm_kms_standard_key_count ibm_outbound_nacl_for_vpc_sankey ibm_subnet_count_for_vpc

Query: ibm_is_vpc_by_size

Usage

powerpipe query ibm_insights.query.ibm_is_vpc_by_size

Steampipe Tables

IBM Cloud plugin

SQL

with vpc_size as (
  select
    id,
    a -> 'cidr' as cidr_block,
    concat(
      '/', masklen((a ->> 'cidr')::cidr),
      ' (', power(2, 32 - masklen((a ->> 'cidr')::cidr)), ')'
    ) as size
  from
    ibm_is_vpc,
    jsonb_array_elements(address_prefixes) as a
)
select
  size,
  count(*)
from
  vpc_size
group by
  size;

Dashboards

The query is used in the dashboards:

IBM VPC Dashboard