turbot/oci_insights

Query: filestorage_filesystem_by_region

Usage

powerpipe query oci_insights.query.filestorage_filesystem_by_region

SQL

select
region as "Region",
count(*) as "FileSystems"
from
oci_file_storage_file_system
where
lifecycle_state <> 'DELETED'
group by
region
order by
region;

Dashboards

The query is used in the dashboards: