Query: sql_database_inventory_table

select
  d.name as "Name",
  d.server_name as "Server Name",
  d.status as "Status",
  d.creation_date as "Creation Date",
  d.edition as "Edition",
  d.elastic_pool_name as "Elastic Pool Name",
  d.requested_service_objective_name as "Service Tier",
  d.max_size_bytes as "Max Size Bytes",
  d.zone_redundant as "Zone Redundant",
  d.read_scale as "Read Scale",
  d.tags as "Tags",
  lower(d.id) as "ID",
  sub.title as "Subscription",
  d.subscription_id as "Subscription ID",
  d.resource_group as "Resource Group",
  d.region as "Region"
from
  azure_sql_database as d,
  azure_subscription as sub
where
  sub.subscription_id = d.subscription_id
order by
  d.name;