Kaido Jarvemets - Logo

Automate Your Azure Audits: Unlock Insights & Efficiency in Minutes


Navigating Azure’s extensive cloud environment efficiently requires a streamlined approach, especially when it comes to audits and resource management. With numerous resources to monitor and manage, the need for an automated, comprehensive auditing solution is clear. Azure Audit Toolkit is designed to simplify this process, enabling you to focus on analysis and optimization.

The Challenge

As your Azure footprint grows, so does the complexity of maintaining oversight. Ensuring compliance, security, and efficient resource utilization across an expansive set of cloud resources can become a daunting task. Traditional, manual auditing methods are time-consuming and prone to error, making them less viable for comprehensive cloud governance.

Solution: The Azure Audit Toolkit

I have crafted a solution that automates the audit process, making it easier to gather the data you need for a thorough analysis of your Azure environment. This toolkit combines Azure Resource Graph queries with a powerful PowerShell function, Invoke-AzGraphQueryWithPagination, to automatically fetch detailed information about your Azure resources.

Key Features

  • Automated Data Extraction: Utilize pre-defined Azure Resource Graph queries to automatically extract data from your Azure resources.
  • Streamlined Reporting: Automatically compile the extracted data into CSV files for easy analysis and reporting.
  • Customizable Queries: The included JSON file with queries can be easily modified to suit your specific auditing needs, ensuring flexibility and relevance.
  • Efficiency at Scale: Designed to handle environments of any size, ensuring no resource is overlooked.


  • Time-Saving: Dramatically reduce the time spent on manual data collection.
  • Accuracy: Minimize human error and ensure accurate data extraction for auditing purposes.
  • Insightful Analysis: With automated data collection, spend more time on analysis and optimization of your Azure resources.

Version 0.2 KQL Queries (Updated 29.02)

  • List all Microsoft Sentinel Workspaces
  • List all Azure Log Analytics Workspaces
  • List all Data Collection Rules
  • List all Azure VMs
  • List all Applied Azure Policies
  • List all User Assigned Managed Identities
  • List all Azure VMs Extensions
  • List all Azure Arc for Servers connected servers
  • List all Azure Arc for Servers Extensions
  • List all Azure Automation Accounts
  • List all Azure Subscriptions and Management Groups
  • List All Azure Automation Accounts with Runbooks
  • List All Azure Logic Apps
  • List All Azure VMs enabled identities

Getting Started

The toolkit is ready to use with minimal setup. Download the files (JSON file with KQL queries and the PowerShell script), execute the script, and start automating your Azure resource audits today. It’s that simple.



The Azure Audit Toolkit brings efficiency and simplicity to Azure audits, allowing you to automate the data extraction process and focus on what really matters: analyzing the data to optimize your Azure environment. With this toolkit, you’re not just conducting audits; you’re gaining insights and driving optimization across your cloud resources.

Explore the possibilities with my Azure Audit Toolkit and take the first step towards simplified, automated Azure audits.

Leave a Reply

Contact me

If you’re interested in learning about Automate Your Azure Audits: Unlock Insights & Efficiency in Minutes. I can help you understand how this solution can benefit your organization and provide a customized solution tailored to your specific needs.

Table of Contents