Query: filestorage_filesystem_by_tenancy

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;