Control: Cosmos DB accounts should have public network access disabled

Description

Disable public network access on your Azure Cosmos DB accounts to prevent the account from being accessed from the public internet. This prevents the account from being accessed from the public internet.

Usage

Run the control in your terminal:

powerpipe control run terraform_azure_compliance.control.cosmodb_account_public_network_access_disabled

Snapshot and share results via Turbot Pipes:

powerpipe login
powerpipe control run terraform_azure_compliance.control.cosmodb_account_public_network_access_disabled --share

SQL

This control uses a named query:

select
  address as resource,
  case
    when (attributes_std ->> 'public_network_access_enabled') is null then 'alarm'
    when (attributes_std ->> 'public_network_access_enabled')::boolean then 'alarm'
    else 'ok'
  end status,
  split_part(address, '.', 2) || case
    when (attributes_std ->> 'public_network_access_enabled') is null then ' public network access enabled'
    when (attributes_std ->> 'public_network_access_enabled')::boolean then  ' public network access enabled'
    else ' public network access disabled'
  end || '.' reason
  
  , path || ':' || start_line
from
  terraform_resource
where
  type = 'azurerm_cosmosdb_account';

Control: Cosmos DB accounts should have public network access disabled

Description

Usage

SQL

Tags