Query: fsx_file_system_copy_tags_to_backup_and_volume_enabled

select
  arn as resource,
  case
    when file_system_type <> 'OPENZFS' then 'skip'
    when (open_zfs_configuration ->> 'CopyTagsToBackups') :: bool
    and (open_zfs_configuration ->> 'CopyTagsToVolumes') :: bool 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 ->> 'CopyTagsToBackups') :: bool
    and (open_zfs_configuration ->> 'CopyTagsToVolumes') :: bool then title || ' copy tags to backup and volume enabled.'
    when (open_zfs_configuration ->> 'CopyTagsToBackups') :: bool then title || ' copy tags to backup enabled but disabled for volume.'
    when (open_zfs_configuration ->> 'CopyTagsToVolumes') :: bool then title || ' copy tags to volume enabled but disabled for backup.'
    else title || ' copy tags to backup and volume disabled.'
  end as reason,
  region,
  account_id
from
  aws_fsx_file_system;