turbot/oci_insights

Query: filestorage_filesystem_by_tenancy

Usage

powerpipe query oci_insights.query.filestorage_filesystem_by_tenancy

SQL

select
t.name as "Tenancy",
count(f.id) :: numeric as "File Systems"
from
oci_file_storage_file_system as f,
oci_identity_tenancy as t
where
t.id = f.tenant_id
and f.lifecycle_state <> 'DELETED'
group by
t.name
order by
t.name;

Dashboards

The query is used in the dashboards: