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

Plugins Docs Home

turbot/aws_insights

0Controls

0Variables

account_count account_table acm_certificate_1_year_count acm_certificate_24_hours_count acm_certificate_30_90_days_count acm_certificate_30_days_count acm_certificate_90_365_days_count acm_certificate_age_table acm_certificate_by_account acm_certificate_by_age acm_certificate_by_region acm_certificate_by_transparency_logging_preference acm_certificate_by_type acm_certificate_by_validity acm_certificate_count acm_certificate_domain_validation_options acm_certificate_in_use_by acm_certificate_input acm_certificate_invalid acm_certificate_key_algorithm acm_certificate_key_usage acm_certificate_overview acm_certificate_renewal_eligibility_ineligible acm_certificate_renewal_eligibility_status acm_certificate_revocation_detail acm_certificate_revoked_count acm_certificate_status acm_certificate_tags acm_certificate_transparency_logging_disabled acm_certificate_transparency_logging_status acm_certificate_validity acm_certificates_for_cloudfront_distribution acm_certificates_for_ec2_application_load_balancer acm_certificates_for_ec2_classic_load_balancer acm_certificates_for_ec2_gateway_load_balancer acm_certificates_for_ec2_network_load_balancer api_gateway_apis_for_lambda_function api_gatewayv2_api_1_year_count api_gatewayv2_api_24_hours_count api_gatewayv2_api_30_90_days_count api_gatewayv2_api_30_days_count api_gatewayv2_api_90_365_days_count api_gatewayv2_api_by_account api_gatewayv2_api_by_age api_gatewayv2_api_by_protocol api_gatewayv2_api_by_region api_gatewayv2_api_count api_gatewayv2_api_default_endpoint_enabled api_gatewayv2_api_endpoint_status api_gatewayv2_api_input api_gatewayv2_api_integrations api_gatewayv2_api_overview api_gatewayv2_api_protocol api_gatewayv2_api_stages api_gatewayv2_api_table api_gatewayv2_api_tags api_gatewayv2_default_endpoint api_gatewayv2_stage_count appconfig_applications_for_codepipeline_pipeline backup_plan_input backup_plan_overview backup_plan_resource_assignment backup_plan_rules backup_plans_for_backup_vault backup_vault_input backup_vault_overview backup_vault_policy backup_vault_recovery_points backup_vaults_for_backup_plan bucket_policy_stds_for_s3_bucket cloudformation_stacks_for_codepipeline_pipeline cloudformation_stacks_for_sns_topic cloudfront_distribution_by_account cloudfront_distribution_by_status cloudfront_distribution_count cloudfront_distribution_encryption_in_transit_disabled cloudfront_distribution_encryption_in_transit_status cloudfront_distribution_field_level_encryption cloudfront_distribution_input cloudfront_distribution_logging cloudfront_distribution_logging_disabled cloudfront_distribution_logging_status cloudfront_distribution_overview cloudfront_distribution_price_class cloudfront_distribution_restrictions cloudfront_distribution_sni cloudfront_distribution_sni_disabled cloudfront_distribution_sni_status cloudfront_distribution_status cloudfront_distribution_tags cloudfront_distribution_waf_disabled cloudfront_distribution_waf_status cloudfront_distributions_for_acm_certificate cloudfront_distributions_for_ec2_application_load_balancer cloudtrail_regional_trail_count cloudtrail_trail_bucket cloudtrail_trail_bucket_publicly_accessible cloudtrail_trail_cost_mtd cloudtrail_trail_cost_per_month cloudtrail_trail_count cloudtrail_trail_encryption_status cloudtrail_trail_encryption_table cloudtrail_trail_input cloudtrail_trail_log_file_validation cloudtrail_trail_log_file_validation_disabled_count cloudtrail_trail_log_file_validation_status cloudtrail_trail_logging cloudtrail_trail_logging_disabled_count cloudtrail_trail_logging_status cloudtrail_trail_logging_table cloudtrail_trail_monthly_forecast_table cloudtrail_trail_multi_region cloudtrail_trail_multi_region_count cloudtrail_trail_overview cloudtrail_trail_per_account cloudtrail_trail_per_region cloudtrail_trail_regional cloudtrail_trail_tags cloudtrail_trail_unencrypted cloudtrail_trail_unencrypted_count cloudtrail_trails_for_cloudwatch_log_group cloudtrail_trails_for_kms_key cloudtrail_trails_for_s3_bucket cloudtrail_trails_for_sns_topic cloudwatch_groups_for_codebuild_project cloudwatch_log_group_encryption_details cloudwatch_log_group_input cloudwatch_log_group_metric_filter_count cloudwatch_log_group_overview cloudwatch_log_group_retention_in_days cloudwatch_log_group_stored_bytes cloudwatch_log_group_tags cloudwatch_log_group_unencrypted cloudwatch_log_groups_for_cloudtrail_trail cloudwatch_log_groups_for_ecs_task_definition cloudwatch_log_groups_for_eventbridge_rule cloudwatch_log_groups_for_redshift_cluster cloudwatch_log_groups_for_vpc_flow_log cloudwatch_log_metric_filters_for_cloudwatch_log_group codebuild_project_1_year_count codebuild_project_24_hours_count codebuild_project_30_90_days_count codebuild_project_30_days_count codebuild_project_90_365_days_count codebuild_project_age_table codebuild_project_badge_disabled codebuild_project_badge_status codebuild_project_by_account codebuild_project_by_creation_month codebuild_project_by_environment_type codebuild_project_by_region codebuild_project_by_source_type codebuild_project_by_visibility codebuild_project_cost_per_month codebuild_project_count codebuild_project_encrypted codebuild_project_encryption_disabled codebuild_project_encryption_status codebuild_project_forecast_table codebuild_project_input codebuild_project_logging_disabled codebuild_project_logging_enabled codebuild_project_logging_status codebuild_project_overview codebuild_project_privileged_mode codebuild_project_privileged_mode_disabled codebuild_project_privileged_mode_status codebuild_project_sources codebuild_project_tags codebuild_projects_for_codecommit_repository codebuild_projects_for_codepipeline_pipeline codecommit_repositories_for_codebuild_project codecommit_repositories_for_codepipeline_pipeline codecommit_repository_1_year_count codecommit_repository_24_hours_count codecommit_repository_30_90_days_count codecommit_repository_30_days_count codecommit_repository_90_365_days_count codecommit_repository_age_table codecommit_repository_by_account codecommit_repository_by_creation_month codecommit_repository_by_region codecommit_repository_cost_mtd codecommit_repository_cost_per_month codecommit_repository_count codecommit_repository_default_branch codecommit_repository_input codecommit_repository_monthly_forecast_table codecommit_repository_overview codecommit_repository_tags codecommit_repository_untagged_count codecommit_repository_untagged_count_status codepipeline_pipeline_1_year_count codepipeline_pipeline_24_hours_count codepipeline_pipeline_30_90_days_count codepipeline_pipeline_30_days_count codepipeline_pipeline_90_365_days_count codepipeline_pipeline_age_table codepipeline_pipeline_by_account codepipeline_pipeline_by_creation_month codepipeline_pipeline_by_region codepipeline_pipeline_count codepipeline_pipeline_encryption codepipeline_pipeline_encryption_status codepipeline_pipeline_input codepipeline_pipeline_overview codepipeline_pipeline_stages codepipeline_pipeline_tags codepipeline_pipeline_unencrypted_count codepipeline_pipelines_for_codecommit_repository dax_cluster_discovery_endpoint dax_cluster_encryption dax_cluster_input dax_cluster_node_details dax_cluster_node_type dax_cluster_overview dax_cluster_status dax_cluster_tags dax_clusters_for_vpc_security_group dynamodb_backups_for_dynamodb_table dynamodb_monthly_forecast_table dynamodb_table_1_year_count dynamodb_table_24_hours_count dynamodb_table_30_90_days_count dynamodb_table_30_days_count dynamodb_table_90_365_days_count dynamodb_table_age_table dynamodb_table_autoscaling_disabled_count dynamodb_table_autoscaling_state dynamodb_table_autoscaling_status dynamodb_table_average_read_throughput dynamodb_table_average_write_throughput dynamodb_table_aws_managed_key_encryption dynamodb_table_backup_count dynamodb_table_backup_plan_protection_status dynamodb_table_by_account dynamodb_table_by_creation_month dynamodb_table_by_region dynamodb_table_class dynamodb_table_continuous_backups dynamodb_table_continuous_backups_count dynamodb_table_continuous_backups_status dynamodb_table_cost_mtd dynamodb_table_cost_per_month dynamodb_table_count dynamodb_table_customer_managed_key_encryption dynamodb_table_default_encryption dynamodb_table_encryption_table dynamodb_table_encryption_type dynamodb_table_input dynamodb_table_item_count_by_account dynamodb_table_item_count_by_creation_month dynamodb_table_item_count_by_region dynamodb_table_key_schema dynamodb_table_overview dynamodb_table_point_in_time_recovery dynamodb_table_read_write_capacity dynamodb_table_size dynamodb_table_status dynamodb_table_tags dynamodb_table_unused_count dynamodb_table_unused_status ebs_snapshot_1_year_count ebs_snapshot_24_hours_count ebs_snapshot_30_90_days_count ebs_snapshot_30_days_count ebs_snapshot_90_365_days_count ebs_snapshot_age_table ebs_snapshot_by_account ebs_snapshot_by_creation_month ebs_snapshot_by_encryption_status ebs_snapshot_by_public_status ebs_snapshot_by_region ebs_snapshot_cost_mtd ebs_snapshot_cost_per_month ebs_snapshot_count ebs_snapshot_encryption ebs_snapshot_input ebs_snapshot_monthly_forecast_table ebs_snapshot_overview ebs_snapshot_public_count ebs_snapshot_public_table ebs_snapshot_state ebs_snapshot_storage ebs_snapshot_storage_by_account ebs_snapshot_storage_by_age ebs_snapshot_storage_by_region ebs_snapshot_storage_total ebs_snapshot_tags ebs_snapshots_for_ec2_ami ebs_unencrypted_snapshot_count ebs_volume_1_year_count ebs_volume_24_hours_count ebs_volume_30_90_days_count ebs_volume_30_days_count ebs_volume_90_365_days_count ebs_volume_age_table ebs_volume_attached_instances ebs_volume_attached_instances_count ebs_volume_by_account ebs_volume_by_creation_month ebs_volume_by_encryption_status ebs_volume_by_region ebs_volume_by_state ebs_volume_by_type ebs_volume_cost_mtd ebs_volume_cost_per_month ebs_volume_count ebs_volume_encryption ebs_volume_encryption_status ebs_volume_encryption_table ebs_volume_input ebs_volume_iops ebs_volume_monthly_forecast_table ebs_volume_overview ebs_volume_state ebs_volume_storage ebs_volume_storage_by_account ebs_volume_storage_by_creation_month ebs_volume_storage_by_region ebs_volume_storage_by_type ebs_volume_storage_total ebs_volume_tags ebs_volume_top_10_read_ops_avg ebs_volume_top_10_write_ops_avg ebs_volume_type ebs_volume_unattached_count ebs_volume_unencrypted_count ebs_volumes_for_ec2_instance ebs_volumes_for_kms_key ec2_ami_architecture ec2_ami_hypervisor ec2_ami_input ec2_ami_instances ec2_ami_overview ec2_ami_shared_with ec2_ami_state ec2_ami_tags ec2_ami_virtualization ec2_amis_for_ebs_snapshot ec2_amis_for_ebs_volume ec2_amis_for_emr_cluster ec2_application_load_balancer_attributes ec2_application_load_balancer_az_zone ec2_application_load_balancer_deletion_protection ec2_application_load_balancer_input ec2_application_load_balancer_ip_type ec2_application_load_balancer_logging_enabled ec2_application_load_balancer_overview ec2_application_load_balancer_scheme ec2_application_load_balancer_state ec2_application_load_balancer_tags ec2_application_load_balancers_for_acm_certificate ec2_application_load_balancers_for_cloudfront_distribution ec2_application_load_balancers_for_ec2_instance ec2_application_load_balancers_for_s3_bucket ec2_application_load_balancers_for_vpc ec2_application_load_balancers_for_vpc_security_group ec2_application_load_balancers_for_vpc_subnet ec2_classic_load_balancer_az_zone ec2_classic_load_balancer_cross_zone_enabled ec2_classic_load_balancer_input ec2_classic_load_balancer_instances ec2_classic_load_balancer_logging_enabled ec2_classic_load_balancer_overview ec2_classic_load_balancer_scheme ec2_classic_load_balancer_tags ec2_classic_load_balancers_for_acm_certificate ec2_classic_load_balancers_for_ec2_instance ec2_classic_load_balancers_for_s3_bucket ec2_classic_load_balancers_for_vpc ec2_classic_load_balancers_for_vpc_security_group ec2_classic_load_balancers_for_vpc_subnet ec2_ebs_optimized_count ec2_gateway_load_balancer_attributes ec2_gateway_load_balancer_az_zone ec2_gateway_load_balancer_deletion_protection ec2_gateway_load_balancer_input ec2_gateway_load_balancer_logging_enabled ec2_gateway_load_balancer_overview ec2_gateway_load_balancer_state ec2_gateway_load_balancer_tags ec2_gateway_load_balancers_for_ec2_instance ec2_gateway_load_balancers_for_vpc ec2_gateway_load_balancers_for_vpc_subnet ec2_instance_1_year_count ec2_instance_24_hours_count ec2_instance_30_90_days_count ec2_instance_30_days_count ec2_instance_90_365_days_count ec2_instance_age_table ec2_instance_block_device_mapping ec2_instance_by_account ec2_instance_by_cpu_utilization_category ec2_instance_by_creation_month ec2_instance_by_public_ip ec2_instance_by_region ec2_instance_by_state ec2_instance_by_type ec2_instance_cost_mtd ec2_instance_cost_per_month ec2_instance_count ec2_instance_cpu_cores ec2_instance_detailed_monitoring_enabled ec2_instance_ebs_optimized ec2_instance_ebs_optimized_status ec2_instance_input ec2_instance_network_interfaces ec2_instance_overview ec2_instance_public_access ec2_instance_public_access_count ec2_instance_public_access_table ec2_instance_security_groups ec2_instance_status ec2_instance_tags ec2_instance_total_cores ec2_instance_total_cores_count ec2_instance_type ec2_instances_for_ebs_volume ec2_instances_for_ec2_ami ec2_instances_for_ec2_application_load_balancer ec2_instances_for_ec2_classic_load_balancer ec2_instances_for_ec2_gateway_load_balancer ec2_instances_for_ec2_network_interface ec2_instances_for_ec2_network_load_balancer ec2_instances_for_iam_role ec2_instances_for_vpc ec2_instances_for_vpc_eip ec2_instances_for_vpc_security_group ec2_instances_for_vpc_subnet ec2_launch_configurations_for_ebs_snapshot ec2_launch_configurations_for_vpc_security_group ec2_load_balancer_listeners_for_api_gatewayv2_api ec2_load_balancer_listeners_for_ec2_application_load_balancer ec2_load_balancer_listeners_for_ec2_classic_load_balancer ec2_load_balancer_listeners_for_ec2_gateway_load_balancer ec2_load_balancer_listeners_for_ec2_network_load_balancer ec2_monthly_forecast_table ec2_network_interface_association_details ec2_network_interface_attachment_status ec2_network_interface_delete_on_termination ec2_network_interface_overview ec2_network_interface_private_ip ec2_network_interface_public_ip ec2_network_interface_status ec2_network_interface_tags ec2_network_interface_type ec2_network_interfaces_for_ec2_instance ec2_network_interfaces_for_vpc ec2_network_interfaces_for_vpc_eip ec2_network_interfaces_for_vpc_flow_log ec2_network_interfaces_for_vpc_subnet ec2_network_load_balancer_attributes ec2_network_load_balancer_az_zone ec2_network_load_balancer_deletion_protection ec2_network_load_balancer_input ec2_network_load_balancer_ip_type ec2_network_load_balancer_logging_enabled ec2_network_load_balancer_overview ec2_network_load_balancer_scheme ec2_network_load_balancer_state ec2_network_load_balancer_tags ec2_network_load_balancers_for_acm_certificate ec2_network_load_balancers_for_ec2_instance ec2_network_load_balancers_for_s3_bucket ec2_network_load_balancers_for_vpc ec2_network_load_balancers_for_vpc_subnet ec2_public_instance_count ec2_target_groups_for_ec2_application_load_balancer ec2_target_groups_for_ec2_gateway_load_balancer ec2_target_groups_for_ec2_instance ec2_target_groups_for_ec2_network_load_balancer ec2_target_groups_for_ecs_service ec2_top10_cpu_past_week ecr_policy_std_for_ecr_repository ecr_repositories_for_codebuild_project ecr_repositories_for_codepipeline_pipeline ecr_repositories_for_ecs_task_definition ecr_repository_1_year_count ecr_repository_24_hours_count ecr_repository_30_90_days_count ecr_repository_30_days_count ecr_repository_90_365_days_count ecr_repository_age_table ecr_repository_by_account ecr_repository_by_creation_month ecr_repository_by_region ecr_repository_count ecr_repository_encrypted ecr_repository_encryption_disabled_count ecr_repository_encryption_status ecr_repository_input ecr_repository_overview ecr_repository_public_access ecr_repository_scan_on_push ecr_repository_scan_on_push_disabled_count ecr_repository_scan_on_push_status ecr_repository_tag_immutability ecr_repository_tag_immutability_status ecr_repository_tag_mutability_count ecr_repository_tagging ecr_repository_tagging_disabled_count ecr_repository_tagging_status ecr_repository_tags ecs_cluster_active_service_count ecs_cluster_active_services_count ecs_cluster_by_account ecs_cluster_by_region ecs_cluster_by_status ecs_cluster_container_insights_disabled ecs_cluster_container_insights_enabled ecs_cluster_container_insights_status ecs_cluster_container_instances ecs_cluster_cost_per_month ecs_cluster_count ecs_cluster_input ecs_cluster_monthly_forecast_table ecs_cluster_overview ecs_cluster_pending_tasks_count ecs_cluster_registered_container_instances_count ecs_cluster_running_tasks_count ecs_cluster_statistics ecs_cluster_status ecs_cluster_tags ecs_clusters_for_codepipeline_pipeline ecs_clusters_for_ec2_instance ecs_clusters_for_ecs_service ecs_container_instances_for_ecs_cluster ecs_container_instances_for_ecs_service ecs_service_input ecs_service_launch_type ecs_service_overview ecs_service_status ecs_service_tags ecs_service_tasks ecs_services_for_ecs_cluster ecs_services_for_ecs_task_definition ecs_task_definition_cpu_units ecs_task_definition_input ecs_task_definition_memory ecs_task_definition_network_mode ecs_task_definition_overview ecs_task_definition_requires_compatibilities ecs_task_definition_tags ecs_task_definitions_for_ecr_repository ecs_task_definitions_for_ecs_cluster ecs_task_definitions_for_ecs_service ecs_tasks_for_ecs_service ecs_tasks_for_ecs_task_definition efs_access_points_for_efs_file_system efs_file_system_1_year_count efs_file_system_24_hours_count efs_file_system_30_90_days_count efs_file_system_30_days_count efs_file_system_90_365_days_count efs_file_system_automatic_backup efs_file_system_automatic_backup_disabled_count efs_file_system_by_account efs_file_system_by_age efs_file_system_by_automatic_backup_status efs_file_system_by_encryption_status efs_file_system_by_performance_mode efs_file_system_by_region efs_file_system_by_state efs_file_system_by_throughput_mode efs_file_system_count efs_file_system_encryption efs_file_system_encryption_disabled_count efs_file_system_input efs_file_system_mount_targets efs_file_system_overview efs_file_system_performance_mode efs_file_system_size_in_bytes efs_file_system_status efs_file_system_table efs_file_system_tags efs_file_system_throughput_mode efs_file_systems_for_ecs_task_definition efs_mount_targets_for_efs_file_system efs_mount_targets_for_vpc_security_group egress_nacl_for_vpc_sankey eks_addons_for_eks_cluster eks_cluste_by_creation_month eks_cluster_1_year_count eks_cluster_24_hours_count eks_cluster_30_90_days_count eks_cluster_30_days_count eks_cluster_90_365_days_count eks_cluster_age_table eks_cluster_audit_logging_disabled eks_cluster_audit_logging_status eks_cluster_by_account eks_cluster_by_ip_family eks_cluster_by_platform_version eks_cluster_by_region eks_cluster_by_status eks_cluster_control_plane_audit_logging eks_cluster_count eks_cluster_endpoint_endpoint_public_access_disabled eks_cluster_endpoint_public_access_status eks_cluster_endpoint_restrict_public_access eks_cluster_input eks_cluster_kubernetes_version eks_cluster_logging eks_cluster_node_group eks_cluster_overview eks_cluster_resources_vpc_config eks_cluster_secrets_encryption eks_cluster_secrets_encryption_disabled eks_cluster_secrets_encryption_status eks_cluster_status eks_cluster_tags eks_cost_per_month eks_fargate_profiles_for_eks_cluster eks_identity_providers_for_eks_cluster eks_monthly_forecast_table eks_node_groups_for_eks_cluster elastic_beanstalk_applications_for_codepipeline_pipeline elasticache_cluster_auth_token elasticache_cluster_automatic_backup elasticache_cluster_cache_node_count elasticache_cluster_encryption_rest elasticache_cluster_encryption_transit elasticache_cluster_input elasticache_cluster_node_1_year_count elasticache_cluster_node_24_hours_count elasticache_cluster_node_30_90_days_count elasticache_cluster_node_30_days_count elasticache_cluster_node_90_365_days_count elasticache_cluster_node_age_table elasticache_cluster_node_auth_token elasticache_cluster_node_automatic_backup elasticache_cluster_node_automatic_backup_disabled_count elasticache_cluster_node_by_account elasticache_cluster_node_by_automatic_backup_status elasticache_cluster_node_by_creation_month elasticache_cluster_node_by_encryption_at_rest_status elasticache_cluster_node_by_encryption_at_transit_status elasticache_cluster_node_by_engine elasticache_cluster_node_by_node_type elasticache_cluster_node_by_region elasticache_cluster_node_cost_per_month elasticache_cluster_node_count elasticache_cluster_node_encryption_at_rest_disabled_count elasticache_cluster_node_encryption_at_transit_disabled_count elasticache_cluster_node_encryption_rest elasticache_cluster_node_encryption_transit elasticache_cluster_node_input elasticache_cluster_node_monthly_forecast_table elasticache_cluster_node_node_type elasticache_cluster_node_notification_configuration elasticache_cluster_node_overview elasticache_cluster_node_status elasticache_cluster_node_tags elasticache_cluster_nodes_for_elasticache_cluster elasticache_cluster_overview elasticache_cluster_status elasticache_clusters_for_elasticache_cluster_node elasticache_clusters_for_sns_topic elasticache_clusters_for_vpc_security_group elasticache_node_groups_for_elasticache_cluster elasticache_node_groups_for_elasticache_cluster_node elasticache_parameter_groups_for_elasticache_cluster_node elasticache_shard_details elasticache_subnet_groups_for_elasticache_cluster_node emr_cluster_1_year_count emr_cluster_24_hours_count emr_cluster_30_90_days_count emr_cluster_30_days_count emr_cluster_90_365_days_count emr_cluster_age_table emr_cluster_applications emr_cluster_auto_termination emr_cluster_by_account emr_cluster_by_age emr_cluster_by_region emr_cluster_by_state emr_cluster_count emr_cluster_ec2_instance_attributes emr_cluster_input emr_cluster_instance emr_cluster_log_encryption emr_cluster_logging emr_cluster_logging_disbaled_count emr_cluster_logging_encryption_disabled_count emr_cluster_logging_encryption_status emr_cluster_logging_status emr_cluster_overview emr_cluster_state emr_cluster_status emr_cluster_tags emr_cluster_termination_protection_disabled_count emr_cluster_termination_protection_status emr_clusters_for_iam_role eventbridge_buses_for_eventbridge_rule eventbridge_rule_input eventbridge_rule_overview eventbridge_rule_state eventbridge_rule_tags eventbridge_rule_target_count eventbridge_rule_targets eventbridge_rules_for_sqs_queue flow_logs_count_for_vpc guardduty_detectors_for_cloudtrail_trail guardduty_detectors_for_iam_role iam_access_count iam_access_key_1_year_count iam_access_key_24_hours_count iam_access_key_30_90_days_count iam_access_key_30_days_count iam_access_key_90_365_days_count iam_access_key_age_table iam_accounts_without_root_mfa iam_actions_for_glob iam_actions_for_glob_total_statements iam_all_policies_for_group iam_all_policies_for_role iam_all_policies_for_user iam_boundary_policy_for_role iam_boundary_policy_for_user iam_credential_entities_console_access_with_no_mfa_count iam_credential_entities_count iam_credential_entities_root_access_keys_table iam_group_count iam_group_direct_attached_policy_count_for_group iam_group_inline_policy_count_for_group iam_group_input iam_group_overview iam_groups_by_account iam_groups_by_creation_month iam_groups_by_path iam_groups_for_iam_policy iam_groups_for_iam_user iam_groups_for_user iam_groups_with_inline_policy iam_groups_with_inline_policy_count iam_groups_without_users iam_groups_without_users_count iam_policies_for_iam_group iam_policies_for_iam_role iam_policies_for_iam_user iam_policy_attached iam_policy_aws_managed iam_policy_input iam_policy_overview iam_policy_statement iam_policy_std_for_iam_policy iam_policy_tags iam_role_allows_assume_role_to_all_principal_count iam_role_count iam_role_direct_attached_policy_count_for_role iam_role_inline_policy_count_for_role iam_role_input iam_role_no_boundary_count iam_role_overview iam_role_tags iam_roles_allow_all_action iam_roles_allow_all_action_count iam_roles_by_account iam_roles_by_boundary_policy iam_roles_by_creation_month iam_roles_by_path iam_roles_for_codebuild_project iam_roles_for_codepipeline_pipeline iam_roles_for_dax_cluster iam_roles_for_ec2_instance iam_roles_for_ecs_service iam_roles_for_ecs_task_definition iam_roles_for_eks_cluster iam_roles_for_emr_cluster iam_roles_for_iam_policy iam_roles_for_lambda_function iam_roles_for_rds_db_cluster iam_roles_for_redshift_cluster iam_roles_for_vpc_flow_log iam_roles_with_direct_attached_policy iam_roles_with_inline_policy iam_roles_with_inline_policy_count iam_roles_without_direct_attached_policy_count iam_root_access_keys_count iam_root_access_keys_table iam_user_access_keys iam_user_by_creation_month iam_user_by_path iam_user_console_password iam_user_count iam_user_direct_attached_policy_count_for_user iam_user_excessive_permissions_count iam_user_excessive_permissions_report iam_user_inline_policy_count_for_user iam_user_input iam_user_manage_policies_hierarchy iam_user_manage_policies_sankey iam_user_mfa_devices iam_user_mfa_for_user iam_user_mfa_table iam_user_no_boundary_count iam_user_no_mfa_count iam_user_overview iam_user_tags iam_user_with_excessive_permissions_count iam_users_by_account iam_users_by_boundary_policy iam_users_by_mfa_enabled iam_users_for_group iam_users_for_iam_group iam_users_for_iam_policy iam_users_with_direct_attached_policy iam_users_with_direct_attached_policy_count iam_users_with_inline_policy iam_users_with_inline_policy_count ingress_nacl_for_vpc_sankey key_policy_std_for_kms_key kinesis_streams_for_api_gatewayv2_api kinesis_streams_for_cloudwatch_log_group kinesis_streams_for_dynamodb_table kms_cmk_lifecycle_table kms_cmk_pending_deletion_count kms_cmk_rotation_disabled_count kms_customer_managed_key_count kms_key_1_year_count kms_key_24_hours_count kms_key_30_90_days_count kms_key_30_days_count kms_key_90_365_days_count kms_key_age kms_key_age_table kms_key_aliases kms_key_by_account kms_key_by_creation_month kms_key_by_region kms_key_by_state kms_key_cost_mtd kms_key_cost_per_month kms_key_count kms_key_disabled_count kms_key_disabled_status kms_key_input kms_key_origin kms_key_overview kms_key_policy kms_key_rotation_disabled_count kms_key_rotation_enabled kms_key_rotation_status kms_key_state kms_key_tags kms_key_type kms_keys_for_backup_vault kms_keys_for_cloudtrail_trail kms_keys_for_cloudwatch_log_group kms_keys_for_codebuild_project kms_keys_for_codepipeline_pipeline kms_keys_for_dynamodb_table kms_keys_for_ebs_snapshot kms_keys_for_ebs_volume kms_keys_for_ecr_repository kms_keys_for_efs_file_system kms_keys_for_eks_cluster kms_keys_for_elasticache_cluster_node kms_keys_for_lambda_function kms_keys_for_rds_db_cluster kms_keys_for_rds_db_cluster_snapshot kms_keys_for_rds_db_instance kms_keys_for_rds_db_instance_snapshot kms_keys_for_redshift_cluster kms_keys_for_redshift_snapshot kms_keys_for_s3_bucket kms_keys_for_sns_topic kms_keys_for_sqs_queue kms_monthly_forecast_table lambda_function_by_account lambda_function_by_encryption_status lambda_function_by_region lambda_function_by_runtime lambda_function_code_size_by_account lambda_function_code_size_by_region lambda_function_code_size_by_runtime lambda_function_cost_mtd lambda_function_cost_per_month lambda_function_count lambda_function_dead_letter_config_status lambda_function_encryption lambda_function_encryption_table lambda_function_input lambda_function_invocation_rate lambda_function_last_update_status lambda_function_memory lambda_function_memory_size_by_account lambda_function_memory_size_by_region lambda_function_memory_size_by_runtime lambda_function_overview lambda_function_policy lambda_function_public lambda_function_public_access_table lambda_function_public_count lambda_function_public_status lambda_function_runtime lambda_function_security_groups lambda_function_subnet_ids lambda_function_tags lambda_function_unencrypted_count lambda_function_uses_latest_runtime_status lambda_functions_for_api_gatewayv2_api lambda_functions_for_cloudwatch_log_group lambda_functions_for_eventbridge_rule lambda_functions_for_iam_role lambda_functions_for_kms_key lambda_functions_for_s3_bucket lambda_functions_for_sqs_queue lambda_functions_for_vpc lambda_functions_for_vpc_security_group lambda_functions_for_vpc_subnet lambda_high_error_rate lambda_monthly_forecast_table logging_destination_s3_buckets_for_s3_bucket logging_source_s3_buckets_for_s3_bucket media_stores_for_cloudfront_distribution network_interface_id opensearch_domain_endpoint opensearch_domain_input opensearch_domain_instance_type opensearch_domain_overview opensearch_domain_security_groups opensearch_domain_subnet opensearch_domain_tags opensearch_domain_version opensearch_domains_for_acm_certificate policy_std_for_backup_vault policy_std_for_lambda_function queue_policy_std_for_sqs_queue rds_clusters_for_rds_db_cluster_snapshot rds_db_cluster_1_year_count rds_db_cluster_24_hours_count rds_db_cluster_30_90_days_count rds_db_cluster_30_days_count rds_db_cluster_age_table rds_db_cluster_by_account rds_db_cluster_by_creation_month rds_db_cluster_by_encryption_status rds_db_cluster_by_engine_type rds_db_cluster_by_region rds_db_cluster_by_state rds_db_cluster_cost_mtd rds_db_cluster_cost_per_month rds_db_cluster_count rds_db_cluster_deletion_protection_status rds_db_cluster_encryption_table rds_db_cluster_input rds_db_cluster_logging_disabled rds_db_cluster_logging_disabled_count rds_db_cluster_logging_status rds_db_cluster_logging_table rds_db_cluster_monthly_forecast_table rds_db_cluster_multiple_az_status rds_db_cluster_no_deletion_protection rds_db_cluster_no_deletion_protection_count rds_db_cluster_overview rds_db_cluster_snapshot_1_year_count rds_db_cluster_snapshot_24_hours_count rds_db_cluster_snapshot_30_90_days_count rds_db_cluster_snapshot_30_days_count rds_db_cluster_snapshot_90_365_days_count rds_db_cluster_snapshot_age_table rds_db_cluster_snapshot_allocated_storage rds_db_cluster_snapshot_attributes rds_db_cluster_snapshot_by_account rds_db_cluster_snapshot_by_creation_month rds_db_cluster_snapshot_by_encryption_status rds_db_cluster_snapshot_by_engine_type rds_db_cluster_snapshot_by_region rds_db_cluster_snapshot_by_state rds_db_cluster_snapshot_count rds_db_cluster_snapshot_encryption_table rds_db_cluster_snapshot_engine rds_db_cluster_snapshot_iam_authentication_enabled rds_db_cluster_snapshot_iam_database_authentication_enabled rds_db_cluster_snapshot_input rds_db_cluster_snapshot_overview rds_db_cluster_snapshot_status rds_db_cluster_snapshot_tags rds_db_cluster_snapshot_type rds_db_cluster_snapshot_unencrypted rds_db_cluster_snapshot_unencrypted_count rds_db_cluster_snapshots_for_kms_key rds_db_cluster_snapshots_for_rds_db_cluster rds_db_cluster_status rds_db_cluster_tags rds_db_cluster_unencrypted rds_db_cluster_unencrypted_count rds_db_clustere_90_365_days_count rds_db_clusters_for_kms_key rds_db_clusters_for_rds_db_instance rds_db_clusters_for_vpc_security_group rds_db_instance_1_year_count rds_db_instance_24_hours_count rds_db_instance_30_90_days_count rds_db_instance_30_days_count rds_db_instance_90_365_days_count rds_db_instance_age_table rds_db_instance_by_account rds_db_instance_by_class rds_db_instance_by_cpu_utilization_category rds_db_instance_by_creation_month rds_db_instance_by_encryption_status rds_db_instance_by_engine_type rds_db_instance_by_region rds_db_instance_by_state rds_db_instance_class rds_db_instance_cost_mtd rds_db_instance_cost_per_month rds_db_instance_count rds_db_instance_db_subnet_groups rds_db_instance_deletion_protection rds_db_instance_deletion_protection_status rds_db_instance_encryption_table rds_db_instance_engine_type rds_db_instance_input rds_db_instance_logging rds_db_instance_logging_disabled_count rds_db_instance_logging_status rds_db_instance_logging_table rds_db_instance_monthly_forecast_table rds_db_instance_multiple_az_status rds_db_instance_overview rds_db_instance_parameter_groups rds_db_instance_public rds_db_instance_public_access_table rds_db_instance_public_count rds_db_instance_public_status rds_db_instance_security_groups rds_db_instance_snapshot_1_year_count rds_db_instance_snapshot_24_hours_count rds_db_instance_snapshot_30_90_days_count rds_db_instance_snapshot_30_days_count rds_db_instance_snapshot_90_365_days_count rds_db_instance_snapshot_age_table rds_db_instance_snapshot_by_account rds_db_instance_snapshot_by_creation_month rds_db_instance_snapshot_by_encryption_status rds_db_instance_snapshot_by_engine_type rds_db_instance_snapshot_by_region rds_db_instance_snapshot_by_state rds_db_instance_snapshot_count rds_db_instance_snapshot_encryption_table rds_db_instance_snapshot_iam_authentication_enabled rds_db_instance_snapshot_unencrypted_count rds_db_instance_storage rds_db_instance_subnets rds_db_instance_tags rds_db_instance_top10_cpu_past_week rds_db_instance_unencrypted rds_db_instance_unencrypted_count rds_db_instances_for_kms_key rds_db_instances_for_rds_db_cluster rds_db_instances_for_sns_topic rds_db_instances_for_vpc rds_db_instances_for_vpc_security_group rds_db_instances_for_vpc_subnet rds_db_snapshot_attribute rds_db_snapshot_engine rds_db_snapshot_iam_database_authentication_enabled rds_db_snapshot_input rds_db_snapshot_overview rds_db_snapshot_status rds_db_snapshot_storage rds_db_snapshot_tag rds_db_snapshot_type rds_db_snapshot_unencrypted rds_db_snapshots_for_kms_key rds_db_snapshots_for_rds_db_instance rds_db_subnet_groups_for_rds_db_cluster rds_db_subnet_groups_for_rds_db_instance rds_instances_for_rds_db_instance_snapshot redshift_cluster_1_year_count redshift_cluster_24_hours_count redshift_cluster_30_90_days_count redshift_cluster_30_days_count redshift_cluster_90_365_days_count redshift_cluster_age_table redshift_cluster_by_account redshift_cluster_by_cpu_utilization_category redshift_cluster_by_creation_month redshift_cluster_by_encryption_status redshift_cluster_by_publicly_accessible_status redshift_cluster_by_region redshift_cluster_by_state redshift_cluster_cost_mtd redshift_cluster_cost_per_month redshift_cluster_count redshift_cluster_encryption redshift_cluster_encryption_table redshift_cluster_input redshift_cluster_logging redshift_cluster_logging_status redshift_cluster_logging_table redshift_cluster_monthly_forecast_table redshift_cluster_node_details redshift_cluster_node_type redshift_cluster_number_of redshift_cluster_overview redshift_cluster_parameter_groups redshift_cluster_public redshift_cluster_publicly_accessible redshift_cluster_publicly_accessible_table redshift_cluster_scheduled_actions redshift_cluster_security_groups redshift_cluster_status redshift_cluster_tags redshift_cluster_top10_cpu_past_week redshift_cluster_unencrypted_count redshift_cluster_version redshift_clusters_for_kms_key redshift_clusters_for_redshift_snapshot redshift_clusters_for_sns_topic redshift_clusters_for_vpc redshift_clusters_for_vpc_security_group redshift_snapshot_backup_size redshift_snapshot_engine redshift_snapshot_input redshift_snapshot_node_type redshift_snapshot_overview redshift_snapshot_status redshift_snapshot_tags redshift_snapshot_type redshift_snapshot_unencrypted redshift_snapshots_for_redshift_cluster s3_bucket_1_year_count s3_bucket_24_hours_count s3_bucket_30_90_days_count s3_bucket_30_days_count s3_bucket_90_365_days_count s3_bucket_age_table s3_bucket_block_public_acls_disabled_count s3_bucket_block_public_policy_disabled_count s3_bucket_by_account s3_bucket_by_creation_month s3_bucket_by_default_encryption_status s3_bucket_by_region s3_bucket_cost_mtd s3_bucket_cost_per_month s3_bucket_count s3_bucket_cross_region_replication s3_bucket_cross_region_replication_status s3_bucket_encryption s3_bucket_encryption_table s3_bucket_https_enforce s3_bucket_https_unenforced_count s3_bucket_ignore_public_acls_disabled_count s3_bucket_input s3_bucket_lifecycle_policy s3_bucket_lifecycle_table s3_bucket_logging s3_bucket_logging_disabled_count s3_bucket_logging_enabled s3_bucket_logging_status s3_bucket_logging_table s3_bucket_overview s3_bucket_public s3_bucket_public_access s3_bucket_public_access_blocked s3_bucket_public_access_table s3_bucket_public_block_count s3_bucket_public_policy_count s3_bucket_restrict_public_buckets_disabled_count s3_bucket_server_side_encryption s3_bucket_tags_detail s3_bucket_unencrypted_count s3_bucket_versioning s3_bucket_versioning_disabled_count s3_bucket_versioning_mfa_disabled_count s3_bucket_versioning_mfa_status s3_bucket_versioning_status s3_buckets_for_cloudfront_distribution s3_buckets_for_cloudtrail_trail s3_buckets_for_codebuild_project s3_buckets_for_codepipeline_pipeline s3_buckets_for_dynamodb_table s3_buckets_for_ec2_application_load_balancer s3_buckets_for_ec2_classic_load_balancer s3_buckets_for_ec2_gateway_load_balancer s3_buckets_for_ec2_network_load_balancer s3_buckets_for_emr_cluster s3_buckets_for_kms_key s3_buckets_for_lambda_function s3_buckets_for_redshift_cluster s3_buckets_for_sns_topic s3_buckets_for_sqs_queue s3_buckets_for_vpc_flow_log s3_monthly_forecast_table sagemaker_notebook_instances_for_vpc_security_group sagemaker_notebook_instances_for_vpc_subnet sns_topic_by_account sns_topic_by_encryption_status sns_topic_by_region sns_topic_by_subscription_count sns_topic_by_subscription_status sns_topic_cost_mtd sns_topic_cost_per_month sns_topic_count sns_topic_delivery_policy sns_topic_encrypted_count sns_topic_encryption_status sns_topic_encryption_table sns_topic_input sns_topic_monthly_forecast_table sns_topic_overview sns_topic_subscription_count sns_topic_subscriptions_confirmed_count sns_topic_subscriptions_for_lambda_function sns_topic_subscriptions_for_sns_topic sns_topic_tags sns_topics_for_backup_vault sns_topics_for_cloudtrail_trail sns_topics_for_dax_cluster sns_topics_for_elasticache_cluster_node sns_topics_for_eventbridge_rule sns_topics_for_kms_key sns_topics_for_lambda_function sns_topics_for_rds_db_cluster sns_topics_for_rds_db_instance sns_topics_for_s3_bucket source_ebs_snapshots_for_ebs_volume source_ebs_volumes_for_ebs_snapshot source_sqs_queues_for_api_gatewayv2_api sqs_queue_anonymous_access_count sqs_queue_by_account sqs_queue_by_dlq_status sqs_queue_by_encryption_status sqs_queue_by_region sqs_queue_by_type sqs_queue_content_based_deduplication sqs_queue_cost_mtd sqs_queue_cost_per_month sqs_queue_count sqs_queue_delay_seconds sqs_queue_encryption sqs_queue_encryption_details sqs_queue_encryption_table sqs_queue_fifo_count sqs_queue_input sqs_queue_message sqs_queue_message_retention_seconds sqs_queue_monthly_forecast_table sqs_queue_overview sqs_queue_policy sqs_queue_public_access_status sqs_queue_tags_detail sqs_queue_unencrypted_count sqs_queues_for_kms_key sqs_queues_for_s3_bucket subnet_count_for_vpc target_ebs_snapshots_for_ebs_volume target_ebs_volumes_for_ebs_snapshot target_sqs_queues_for_api_gatewayv2_api topic_policy_std_for_sns_topic vpc_by_account vpc_by_region vpc_by_rfc1918_range vpc_by_size vpc_cidr_blocks vpc_cost_mtd vpc_cost_per_month vpc_count vpc_default_count vpc_default_security_group_status vpc_default_status vpc_dhcp_options vpc_eip_association vpc_eip_association_details vpc_eip_input vpc_eip_other_ip vpc_eip_overview vpc_eip_private_ip_address vpc_eip_public_ip_address vpc_eip_tags vpc_eips_for_ec2_instance vpc_eips_for_ec2_network_interface vpc_eips_for_redshift_cluster vpc_empty_status vpc_endpoint_details_for_vpc vpc_endpoints_for_sqs_queue vpc_endpoints_for_vpc vpc_flow_log_deliver_logs_status vpc_flow_log_destination vpc_flow_log_input vpc_flow_log_overview vpc_flow_log_resource_id vpc_flow_logs_for_cloudwatch_log_group vpc_flow_logs_for_ec2_network_interface vpc_flow_logs_for_vpc vpc_flow_logs_for_vpc_subnet vpc_flow_logs_status vpc_flow_logs_table vpc_flow_tags vpc_gateways_for_vpc vpc_input vpc_is_default vpc_monthly_forecast_table vpc_nat_gateways_for_ec2_network_interface vpc_nat_gateways_for_vpc vpc_nat_gateways_for_vpc_eip vpc_no_flow_logs_count vpc_no_subnet_count vpc_num_ips_for_vpc vpc_overview vpc_peers_for_vpc vpc_route_tables_for_vpc vpc_routes_for_vpc vpc_security_attached_enis_count vpc_security_group_assoc vpc_security_group_by_acount vpc_security_group_by_region vpc_security_group_by_vpc vpc_security_group_count vpc_security_group_details_for_vpc vpc_security_group_egress_rule_sankey vpc_security_group_egress_rules vpc_security_group_egress_rules_count vpc_security_group_ingress_rule_sankey vpc_security_group_ingress_rules vpc_security_group_ingress_rules_count vpc_security_group_input vpc_security_group_overview vpc_security_group_tags vpc_security_group_unassociated_count vpc_security_group_unassociated_status vpc_security_group_unrestricted_egress_status vpc_security_group_unrestricted_ingress_status vpc_security_groups_for_codebuild_project vpc_security_groups_for_dax_cluster vpc_security_groups_for_ec2_application_load_balancer vpc_security_groups_for_ec2_classic_load_balancer vpc_security_groups_for_ec2_gateway_load_balancer vpc_security_groups_for_ec2_instance vpc_security_groups_for_ec2_network_interface vpc_security_groups_for_ec2_network_load_balancer vpc_security_groups_for_ecs_service vpc_security_groups_for_efs_file_system vpc_security_groups_for_eks_cluster vpc_security_groups_for_elasticache_cluster_node vpc_security_groups_for_lambda_function vpc_security_groups_for_opensearch vpc_security_groups_for_rds_db_cluster vpc_security_groups_for_rds_db_instance vpc_security_groups_for_redshift_cluster vpc_security_groups_for_vpc vpc_security_unrestricted_egress vpc_security_unrestricted_egress_count vpc_security_unrestricted_ingress vpc_security_unrestricted_ingress_count vpc_subnet_association vpc_subnet_by_az vpc_subnet_cidr_block vpc_subnet_details_for_vpc vpc_subnet_ids_for_opensearch vpc_subnet_input vpc_subnet_map_public_ip_on_launch_disabled vpc_subnet_num_ips vpc_subnet_overview vpc_subnet_tags vpc_subnets_for_codebuild_project vpc_subnets_for_dax_cluster vpc_subnets_for_ec2_application_load_balancer vpc_subnets_for_ec2_classic_load_balancer vpc_subnets_for_ec2_gateway_load_balancer vpc_subnets_for_ec2_instance vpc_subnets_for_ec2_network_interface vpc_subnets_for_ec2_network_load_balancer vpc_subnets_for_ecs_cluster vpc_subnets_for_ecs_service vpc_subnets_for_efs_file_system vpc_subnets_for_eks_cluster vpc_subnets_for_elasticache_cluster_node vpc_subnets_for_lambda_function vpc_subnets_for_rds_db_cluster vpc_subnets_for_rds_db_instance vpc_subnets_for_redshift_cluster vpc_subnets_for_vpc vpc_subnets_for_vpc_flow_log vpc_tags vpc_vpcs_for_codebuild_project vpc_vpcs_for_dax_cluster vpc_vpcs_for_ec2_application_load_balancer vpc_vpcs_for_ec2_classic_load_balancer vpc_vpcs_for_ec2_gateway_load_balancer vpc_vpcs_for_ec2_instance vpc_vpcs_for_ec2_network_interface vpc_vpcs_for_ec2_network_load_balancer vpc_vpcs_for_ecs_cluster vpc_vpcs_for_ecs_service vpc_vpcs_for_efs_file_system vpc_vpcs_for_eks_cluster vpc_vpcs_for_elasticache_cluster_node vpc_vpcs_for_lambda_function vpc_vpcs_for_opensearch vpc_vpcs_for_rds_db_cluster vpc_vpcs_for_rds_db_instance vpc_vpcs_for_redshift_cluster vpc_vpcs_for_sqs_queue vpc_vpcs_for_vpc_flow_log vpc_vpcs_for_vpc_security_group vpc_vpcs_for_vpc_subnet wafv2_web_acls_for_cloudfront_distribution

Query: iam_role_count

Usage

powerpipe query aws_insights.query.iam_role_count

Steampipe Tables

Amazon Web Services plugin

SQL

select count(*) as "Roles" from aws_iam_role;

Dashboards

The query is used in the dashboards:

AWS IAM Role Dashboard