action_trail_enabledaction_trail_oss_bucket_not_publiccs_kubernetes_cluster_cloud_monitor_enabledcs_kubernetes_cluster_ipvlan_enabledcs_kubernetes_cluster_log_service_enabledcs_kubernetes_cluster_network_policy_enabledcs_kubernetes_cluster_private_cluster_enabledecs_disk_encryption_enabledecs_instance_latest_os_patches_appliedecs_instance_with_no_legacy_networkecs_security_center_agent_installedecs_security_group_remote_administrationecs_security_group_restrict_ingress_rdp_allecs_security_group_restrict_ingress_ssh_allecs_unattached_disk_encryption_enabledlog_store_retention_period_365_daysmanual_controloss_bucket_encrypted_with_byokoss_bucket_encrypted_with_service_keyoss_bucket_enforces_ssloss_bucket_logging_enabledoss_bucket_public_access_blockedram_account_password_policy_min_length_14ram_account_password_policy_one_lowercase_letterram_account_password_policy_one_numberram_account_password_policy_one_symbolram_account_password_policy_one_uppercase_letterram_account_password_policy_reuse_5ram_password_policy_expire_365_or_greaterram_password_policy_expire_90ram_password_policy_max_login_attempts_5ram_policy_no_full_wildcard_privilegesram_root_account_mfa_enabledram_root_account_no_access_keysram_root_account_unusedram_user_access_key_rotated_90ram_user_console_access_mfa_enabledram_user_no_policiesram_user_unused_90rds_instance_postgresql_log_connections_parameter_onrds_instance_postgresql_log_disconnections_parameter_onrds_instance_postgresql_log_duration_parameter_onrds_instance_restrict_access_to_internetrds_instance_sql_audit_enabledrds_instance_sql_audit_retention_period_180_daysrds_instance_ssl_enabledrds_instance_tde_enabledrds_instance_tde_encrypted_with_byoksecurity_center_advanced_or_enterprise_editionsecurity_center_all_assets_installed_with_agentsls_alert_cloud_firewall_changessls_alert_console_authentication_failuressls_alert_console_signin_without_mfasls_alert_kms_key_disable_deletionsls_alert_oss_bucket_policy_changessls_alert_oss_permission_changessls_alert_ram_role_changessls_alert_rds_configuration_changessls_alert_root_account_usagesls_alert_security_group_changessls_alert_unauthorized_api_callssls_alert_vpc_changessls_alert_vpc_route_changesvpc_and_vswitch_flow_log_integrated_with_log_servicevpc_flow_logs_enabled
Query: cs_kubernetes_cluster_private_cluster_enabled
Usage
powerpipe query alicloud_compliance.query.cs_kubernetes_cluster_private_cluster_enabledSteampipe Tables
SQL
select arn as resource, case when state != 'running' then 'skip' when master_url is not null and (master_url::jsonb->>'api_server_endpoint') is not null and (master_url::jsonb->>'api_server_endpoint') != '' then 'alarm' else 'ok' end as status, case when state != 'running' then title || ' is in ' || state || ' state.' when master_url is not null and (master_url::jsonb->>'api_server_endpoint') is not null and (master_url::jsonb->>'api_server_endpoint') != '' then title || ' has a public API server endpoint configured.' else title || ' is configured as a private cluster with no public API server endpoint.' end as reason , account_id as account_id, region as regionfrom alicloud_cs_kubernetes_cluster;
Controls
The query is being used by the following controls: