standard
turbot/azure_compliance

Trigger: Detect & correct PostgreSQL flexible servers with connection throttling disabled

Detect PostgreSQL flexible servers with connection throttling disabled and then enable connection throttling.

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_flexible_server as db,
jsonb_array_elements(flexible_server_configurations) config
where
config ->> 'Name' = 'connection_throttle.enable'
and lower(config -> 'ConfigurationProperties' ->> 'value') != 'on'

Schedule

15m

Tags

category = Compliance
plugin = azure
service = Azure/PostgreSQL