Find Unused Resource Groups in Azure Portal

Step 1: Log in to Azure Portal

Step 2: Search Resource Graph Explorer from azure global search to access it

Step 3: Now, Select the scope of your choice which you want to query either Directory,  Management Group, or Subscription/Subscriptions. 

Step 4: Copy and paste the below-following azure resource graph kql query to find azure orphan resource groups at the selected scope.

ResourceContainers
| where type == "microsoft.resources/
subscriptions/resourcegroups"
| extend rgAndSub = strcat(resourceGroup, 
"--", subscriptionId)
| join kind=leftouter (
    Resources
    | extend rgAndSub = strcat(resourceGroup,
     "--", subscriptionId)
    | summarize count() by rgAndSub
) on rgAndSub
| where isnull(count_)

Step 5: Now select the complete query >> Click on Run Query to view the results. 

Output:

Pre-requisite: AZURE 

In this article, we will be using the resource graph query to find the unused Azure App Service Plans and unused Azure Resource Groups. For this will be using the Resource Graph Explorer which is an Azure native tool that can be accessed from Azure Portal with ease. To run the KQL resource graph query one should have the minimum RBAC Reader role permission on the Directory or Management Group or on the Subscription/Subscriptions to find or to fetch the information of orphaned or unused Azure resource groups & app service plans resources in Azure. Finding and deleting resources will help you or your organization to reduce and save costs.