standard
turbot/azure_compliance

Trigger: Detect & correct PostgreSQL flexible servers with SSL disabled

Detect PostgreSQL flexible servers with SSL disabled and then enable SSL.

Query

with ssl_enabled as(
select
id
from
azure_postgresql_flexible_server,
jsonb_array_elements(flexible_server_configurations) as config
where
config ->> 'Name' = 'require_secure_transport'
and config -> 'ConfigurationProperties' ->> 'value' = 'Off'
)
select
s.id as id,
s.name as name,
s.resource_group as resource_group,
s.subscription_id as subscription_id,
s._ctx ->> 'connection_name' as conn
from
azure_postgresql_flexible_server as s
left join ssl_enabled as a on s.id = a.id,
azure_subscription as sub
where
sub.subscription_id = s.subscription_id;

Schedule

15m

Tags

category = Compliance
plugin = azure
service = Azure/PostgreSQL