Inventory Dashboards Using the Power of Azure Resource Graph
Published Sep 17 2019 06:37 AM 16.9K Views

 

The way human brain processes information, using something such as chart, makes it easier to visualize large amounts of data rather during to understand it through a PowerShell output or excel spreadsheet. Seeing your Azure resources visually can help you make better decisions on how to manage your environment, identify risks and areas of improvement. Combine the power of Azure Resource Graph Explorer with an Azure dashboard and now you have a focused and organized view of your environment, such as an Inventory Dashboard. The power of Azure Resource Graph is more than just advanced powerful queries to gain insight into your environment. It's that you can now take those results to become visual data by creating charts and graphs.

 

How do we do this ?

 

Using Azure Resource Graph Explorer you can query your Azure environment and display the results of the query into a chart to be displayed in your dashboard. You can also build custom dashboards with all your queries that can shared to other team members.

 

First let's show you how to run a query and display on your dashboard the later we'll show how to build custom dashboard.

 

Create a Query in Azure Resource Graph Explorer and pin to your dashboard:

1. First open Azure Resource Graph Explorer in the Azure Portal.

 

Dashboard1.png

 

2. Create your query. For this example we want to see summary of all VMs by OS type. To see a list of starter queries check them out here. Once you have your query, hit the Run Query.

 

dashboard2.png

 

3. When the results are completed you can select to see the results as bar or pie chart.

dashbaord3.png

 

4. On the top bar, select Save As to save your query

dashboard4.png

 

dashboard4a.png

 

5. When that is completed you can select to pin the query to your dashboard

dash5.png

6. Now when you go to your dashboard you will see you're saved query.

 

dash6.png

 

 

Building a Customized Dashboard

If you want to create an inventory dashboard of your environment you do the same steps as with different queries that can be found here and pin the results to an a blank dashboard or an existing one. You can also add Azure Resource Graph explorer tiles to a dashboard and customized the data in that tile. The following will be an example of creating a brand new dashboard and also using a preselected Azure Resource Graph Tile.

 

Create a new dashboard

1. Sign in to the Azure portal.

2. Select Dashboard from the upper section of the left sidebar. Your default view might already be set to dashboard.

3. Select + New dashboard.

dash7.png

 

Adding a Azure Resource Graph tile to a Dashboard

1. Select Edit from the page header.

dash8.png

2. Browse the Tile Gallery and select Azure Resource Graph Explorer.

dash9.png

 

3. Select Add to automatically add the tile to the dashboard with a default size and location. Or, drag the tile to the grid and place it where you want. Continue to add as many tiles as you would like on your dashboard and then select done customizing.

 

Customizing the data on your Azure Resource Graph

 

1. In the tile Select Configure tile

dash10.png

 

2. Select the Update Pinned part on dashboard

dash11.png

 

3. Once the data has been updated it will now display the results in your dashboard.

dash12.png

 

Tips to consider

You will also notice that once the data is update with your environment data the name of the query uses the default Query name. If you want a custom tile name for each query you may find that it is easier to use a blank dashboard and run a bunch queries from Azure Resource Graph Explorer then save them with the name that you prefer. Your final result can look like below example.

 

dash13.png

 

Additional resources for Queries and Dashboard customizations

Starter Queries

Advanced Queries

Azure Portal Dashboard and customizations 

 

1 Comment
Version history
Last update:
‎Sep 17 2019 07:20 AM
Updated by: