turbot/steampipe-mod-aws-compliance

Query: fsx_openzfs_file_system_multi_az_deployment_enabled

Usage

powerpipe query aws_compliance.query.fsx_openzfs_file_system_multi_az_deployment_enabled

Steampipe Tables

SQL

select
arn as resource,
case
when file_system_type <> 'OPENZFS' then 'skip'
when open_zfs_configuration ->> 'DeploymentType' = 'MULTI_AZ_1' then 'ok'
else 'alarm'
end as status,
case
when file_system_type <> 'OPENZFS' then title || ' is of ' || file_system_type || ' type file system.'
when open_zfs_configuration ->> 'DeploymentType' = 'MULTI_AZ_1' then title || ' Multi-AZ deployment enabled.'
else title || ' Multi-AZ deployment disabled.'
end as reason
, region, account_id
from
aws_fsx_file_system;

Controls

The query is being used by the following controls: