turbot/steampipe-mod-azure-insights

Query: storage_account_inventory_table

Usage

powerpipe query azure_insights.query.storage_account_inventory_table

SQL

select
s.name as "Name",
s.creation_time as "Creation Time",
s.kind as "Kind",
s.sku_name as "SKU Name",
s.sku_tier as "SKU Tier",
s.access_tier as "Access Tier",
s.enable_https_traffic_only as "Enable HTTPS Traffic Only",
s.is_hns_enabled as "Hierarchical Namespace Enabled",
s.network_rule_default_action as "Network Rule Default Action",
s.require_infrastructure_encryption as "Infrastructure Encryption Required",
s.allow_blob_public_access as "Allow Blob Public Access",
s.minimum_tls_version as "Minimum TLS Version",
s.tags as "Tags",
lower(s.id) as "ID",
sub.title as "Subscription",
s.subscription_id as "Subscription ID",
s.resource_group as "Resource Group",
s.region as "Region"
from
azure_storage_account as s,
azure_subscription as sub
where
s.subscription_id = sub.subscription_id
order by
s.name;

Dashboards

The query is used in the dashboards: