turbot/steampipe-mod-azure-compliance

Control: Ensure 'Allow Azure services on the trusted services list to access this storage account' is Enabled for Storage Account Access

Description

Some Azure services that interact with storage accounts operate from networks that can't be granted access through network rules. To help this type of service work as intended, allow the set of trusted Azure services to bypass the network rules. These services will then use strong authentication to access the storage account.

Usage

Run the control in your terminal:

powerpipe control run azure_compliance.control.storage_account_trusted_microsoft_services_enabled

Snapshot and share results via Turbot Pipes:

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

SQL

This control uses a named query:

select
sa.id as resource,
case
when network_rule_bypass not like '%AzureServices%' then 'alarm'
else 'ok'
end as status,
case
when network_rule_bypass not like '%AzureServices%' then sa.name || ' trusted Microsoft services not enabled.'
else sa.name || ' trusted Microsoft services enabled.'
end as reason
, sa.resource_group as resource_group
, sub.display_name as subscription
from
azure_storage_account sa,
azure_subscription sub
where
sub.subscription_id = sa.subscription_id;

Tags