turbot/aws_insights

Query: efs_file_system_table

Usage

powerpipe query aws_insights.query.efs_file_system_table

SQL

select
fs.name as "Name",
fs.file_system_id as "ID",
now() :: date - fs.creation_time :: date as "Age in Days",
fs.creation_time as "Create Time",
fs.arn as "ARN",
acc.title as "Account",
fs.account_id as "Account ID",
fs.region as "Region"
from
aws_efs_file_system as fs,
aws_account as acc
where
fs.account_id = acc.account_id
order by
fs.creation_time,
fs.name;

Dashboards

The query is used in the dashboards: