turbot/aws_compliance

Query: opensearch_domain_updated_with_latest_service_software_version

Usage

powerpipe query aws_compliance.query.opensearch_domain_updated_with_latest_service_software_version

Steampipe Tables

SQL

select
arn as resource,
case
when service_software_options ->> 'UpdateAvailable' = 'false' then 'ok'
else 'alarm'
end status,
case
when service_software_options ->> 'UpdateAvailable' = 'false' then title || ' updated with latest service software version.'
else title || ' not updated with latest service software version.'
end reason,
region,
account_id
from
aws_opensearch_domain;

Controls

The query is being used by the following controls: