🔍 Azure SQL Database Inventory Script

This powershell script leverages the Azure CLI to inventory all Azure SQL Databases in your subscription. It organizes the databases by SQL server and resource group, and displays useful details such as service tier, current status, and zone redundancy.

Ideal for cloud administrators, DevOps engineers, or developers managing large-scale Azure environments.

---

📋 Features

• ✅ Lists all Azure SQL Databases and Azure SQL Managed Instances across your subscription
• 🔢 Displays the total number of subscriptions scanned
• 🔠 Automatically sorts subscriptions alphabetically for consistent output
• 🗂️ Groups databases by their parent SQL server and resource group
• 📊 Displays database service tier, status, redundancy type, storage size, failover groups (applicable only to Azure SQL Databases) and compute details in a clean table format
• 🔁 Uses standard CLI tools
• 🧩 Easily customizable for filtering, CSV export

---

📦 Pre-requisites

To use this script, you'll need the following installed:

• Git
  Install instructions

• Azure CLI
  Install instructions

• Login to your Azure account before running the script:

  az login
  

• ✅ Minimum Role Required To run your script successfully, a user needs at least the Reader role at the subscription level plus visibility into the SQL resources.

  Specifically, they need permission to:

  • List Azure resources (for az resource list)
  • List SQL servers and databases (for az sql db list)

---

🚀 Getting Started

🔧 1. Clone the repository

git clone https://github.com/Azure/azure-sql-db-inventory.git

▶️ 2. Run the script

cd azure-sql-db-inventory

cd scripts

az login

.\list-azure-sql-databases.ps1

🖥️ Example Output

---

🔗 References

• Azure CLI Documentation
• Install Azure CLI
• Azure CLI az resource list
• Azure CLI az sql db list
• Azure Built-in Roles: Reader
• Azure Built-in Roles: Contributor
• Azure Role-Based Access Control (RBAC)

---

🛠️ Troubleshooting

If you encounter any issues, here are some common solutions:

1. Error: "Unable to authenticate"

   • Ensure you've run az login and that you have the necessary permissions for the subscription.

2. Error: "Command not found"

   • Make sure you've installed the Azure CLI and are running the script in the correct environment (Bash or PowerShell).

3. Output not as expected

   • Ensure your subscription contains SQL databases and that the az sql db list command is functioning properly.

For more help, refer to the Azure CLI troubleshooting guide.