Export you Azure Subscription Inventory to Excel – Azure ARM inventory Script V0.5

One of the things with Azure to me is the lack of overview.

I know you can click endlessly trough the interface to look at stuff. But that’s not my thing.

It needs to be quick and fast without the hassle of the new portal interface, don’t think we will ever get along but maybe that’s just me.

Luckily there is PowerShell!



I like to have a quick overview on what is deployed, same as with any datacenter.

This was always a pain since you needed to query tons of devices, which where obviously mostly not ware of each other.

So I figured well Azure is all Azure, right? One platform and one interface for querying: PowerShell!

Azure ARM Inventory Script V0.5

I have written which I consider as a V.05 version of a script which uses PowerShell to Query Azure and dump all information in an excel sheet.

You need to have Azure RM PowerShell module installed to run the script –https://azure.microsoft.com/en-us/documentation/articles/powershell-install-configure/

After Installation of the module run the script, which will query for login to Azure and after this will gather all information and export it to Excel.

It creates several csv files and one XLSX file in a directory C:\AzureInventory where you will have a worksheet for every Azure Resource:

  • Resouce Groups
  • Virtual Networks
  • Network Security Groups
  • Subnets
  • Virtual Machines
  • Vnics
  • Storage Accounts
  • Storage Blobs

The Script – https://gallery.technet.microsoft.com/Export-you-Azure-bc1d6b15

There are “some” challenges / improvements when using Azure and AzureRM PowerShell modules but this is for another day and I will make myself familiar with how to write modules to add my improvements.

For now happy Documenting your Azure subscription, feel free to add improvements or comments.



Oskar Landman

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.