standard
turbot/azure_compliance

Trigger: Detect & correct PostgreSQL servers with infrastructure encryption disabled

Detect PostgreSQL servers with infrastructure encryption disabled.

Query

select
concat(id, ' [', subscription_id, '/', resource_group, ']') as title,
id as id,
name,
resource_group,
subscription_id,
_ctx ->> 'connection_name' as conn
from
azure_postgresql_server
where
not (public_network_access = 'Enabled');

Schedule

15m

Tags

category = Compliance
plugin = azure
service = Azure/PostgreSQL