I am pasting my some of the frequently used queries for Azure Resource Graph Explorer.
These queries are designed in Kusto Query Laguage. You can learn more from below link. Link: https://learn.microsoft.com/en-us/azure-data-studio/extensions/kusto-extension
if you are wrking on Azure infrastructure and have a lot of compute workload there, reporting of each asset or each component is always hectic. These queris will help you to get the desired output on graph queries. If youhave a question on where and how to run these queries, then here is the place. Please follow below link to Azure Resource Graph Explorer. https://portal.azure.com/#view/HubsExtension/ArgQueryBlade
You will see this interface.
Simply paste your query and clieck on "Run Query"
Query will take some time to execute.
You will see an option to download yur output in CSV.
Once CSV file is downloaded, you can open it and save ad Excel file.