turbot/aws_insights

Query: media_stores_for_cloudfront_distribution

Usage

powerpipe query aws_insights.query.media_stores_for_cloudfront_distribution

SQL

select
arn as mediastore_arn
from
aws_media_store_container
where
endpoint in (
select
'https://' || (origin ->> 'DomainName')
from
aws_cloudfront_distribution,
jsonb_array_elements(origins) as origin
where
arn = $1
);