Azure Resource Inventory Automation Account v2.1

What is required to run ARI as an Automation Account?

1) Azure Automation Account

2) Azure Storage Account

3) Azure Blob Container inside the Storage Account

Those are the steps you have to do:

On the Automation Account, enable the System Assigned Identity:

This will create an identity in the Azure AD.

Now we are going to use that identity to give the following permissions to the Automation Account:

1) Reader in the Management Group (for the script to be able to read all resources from Azure):

2) Contributor to the Storage Account Container (for the script to be able to copy the Excel file to the container)

3) Storage Blob Data Contributor to the Storage Account

Now, back in the Automation Account, the following Modules need to be imported:

1) "ImportExcel"

2) "Az.ResourceGraph"

3) "Az.Storage"

4) "Az.Account"

This is done by going to the "Modules" then "Browse gallery":

Then search for the modules, click them and click "Import" (wait for the confirmation as it might take some time):

Now just create a Powershell Runbook:

Then just copy the script content from ARI_Automation.ps1

Hit Save and Publish and you are ready to go.