AZQR: Azure Quick Review

Today, I found a clever command line tool (CLI) that scans your Azure resources and generates an Excel report which includes detailed information and recommendations based on Azure's best practices. The main purpose is to provide Azure users with a detailed overview of their Azure setups.

Features include:

Identify non-compliant or suboptimal configurations of your Azure resources.
Produce an overview of your Azure resource types, locations, SKUs, SLAs, Diagnostic Settings and more.
Compare your resource naming conventions with the Cloud Adoption Framework (CAF) guidelines.
Visualise and analyse your Azure resource data using Excel

Ways to install

Linux 0r Azure Cloud Shell

latest_azqr=$(curl -sL https://api.github.com/repos/Azure/azqr/releases/latest | jq -r ".tag_name" | cut -c1-)
wget https://github.com/Azure/azqr/releases/download/$latest_azqr/azqr-ubuntu-latest-amd64 -O azqr
chmod +x azqr

Mac

Download the latest release from here.

Windows

winget install azqr

Authentication

Azure Quick Review (azqr) supports the following authentication methods:

Azure CLI
Service Principal. You'll need to set the following environment variables:
AZURE_CLIENT_ID
AZURE_CLIENT_SECRET
AZURE_TENANT_ID

Authorization

Azure Quick Review (azqr) requires the following permissions:

Subscription Reader

Running the Scan

To scan all resource groups in all subscription run:

./azqr scan

To scan all resource groups in a specific subscription run:

./azqr scan -s <subscription_id>

To scan a specific resource group in a specific subscription run:

./azqr scan -s <subscription_id> -g <resource_group_name>

For information on available commands and help run:

./azqr -h

Scan Results

Azure Quick Review (azqr) generates output in the form of an Excel file, containing several sheets like Overview, Recommendations, Services, Defender, Advisor, and Costs. On a Windows system, it also creates a Power BI Desktop Template for additional analysis and visualization of Azure resource data.

For more information, you can check out AZQR here: GitHub - Azure/azqr: Azure Quick Review

❤️ Enjoyed this article?

Forward to a friend and let them know where they can subscribe (hint: it's here).