Control: Ensure Storage Logging is Enabled for Table Service for 'Read', 'Write', and 'Delete' requests

Description

Azure Table storage is a service that stores structured NoSQL data in the cloud, providing a key/attribute store with a schema-less design. Storage Logging happens server-side and allows details for both successful and failed requests to be recorded in the storage account. These logs allow users to see the details of read, write, and delete operations against the tables. Storage Logging log entries contain the following information about individual requests: timing information such as start time, end-to-end latency, and server latency; authentication details; concurrency information; and the sizes of the request and response messages.

Usage

Run the control in your terminal:

powerpipe control run azure_compliance.control.storage_account_table_service_logging_enabled

Snapshot and share results via Turbot Pipes:

powerpipe login
powerpipe control run azure_compliance.control.storage_account_table_service_logging_enabled --share

SQL

This control uses a named query:

with table_logs as (
  select
    a.id,
    a.name,
    log ->> 'category' as category,
    (log ->> 'enabled') :: boolean as enabled
  from
    azure_storage_account a,
    jsonb_array_elements(a.default_table_diagnostic_settings) as b,
    jsonb_array_elements(b -> 'properties' -> 'logs') as log
  where
    log ->> 'category' in ('StorageRead', 'StorageWrite', 'StorageDelete')
),
log_status as (
  select
    id,
    name,
    max(
      case
        when category = 'StorageRead' then (enabled :: int)
        else 0
      end
    ) = 1 as read_enabled,
    max(
      case
        when category = 'StorageWrite' then (enabled :: int)
        else 0
      end
    ) = 1 as write_enabled,
    max(
      case
        when category = 'StorageDelete' then (enabled :: int)
        else 0
      end
    ) = 1 as delete_enabled
  from
    table_logs
  group by
    id,
    name
)
select
  sa.id as resource,
  case
    when lower(sku_tier) = 'premium' then 'skip'
    when default_table_diagnostic_settings is null then 'alarm'
    when ls.read_enabled
    and ls.write_enabled
    and ls.delete_enabled then 'ok'
    else 'alarm'
  end as status,
  case
    when lower(sku_tier) = 'premium' then sa.name || ' is premium ' || kind || ' storage account.'
    when default_table_diagnostic_settings is null then sa.name || ' table service logging disabled for read, write, delete requests.'
    when ls.read_enabled
    and ls.write_enabled
    and ls.delete_enabled then sa.name || ' table service logging enabled for read, write, delete requests.'
    else sa.name || ' table service logging missing for: ' || trim(
      both ', '
      from
        case
          when not ls.read_enabled then 'read, '
          else ''
        end || case
          when not ls.write_enabled then 'write, '
          else ''
        end || case
          when not ls.delete_enabled then 'delete, '
          else ''
        end
    ) || ' requests.'
  end as reason,
  sa.resource_group as resource_group,
  sub.display_name as subscription
from
  azure_storage_account sa
  left join log_status as ls on ls.id = sa.id
  left join azure_subscription sub on sub.subscription_id = sa.subscription_id

Control: Ensure Storage Logging is Enabled for Table Service for 'Read', 'Write', and 'Delete' requests

Description

Usage

SQL

Tags