How to export the resources based on pricing tier in Azure Subscription level?

Question

How to export the resources based on pricing tier in Azure Subscription level?

krishna572 886

For the Function Apps, we have pricing tier grouping

[ enter image description here

](https://i.stack.imgur.com/Pnc1k.png)

For the APIM Services, we have pricing tier with the Group By Tier view:

[ enter image description here

](https://i.stack.imgur.com/WJgxy.png)

Service Wise - I can list the Pricing based using Grouping Column but how to list the resources with Pricing Tier based in the Subscription level resources - I cannot see any option "Grouping by pricing tier/tier/plan" in the grouping drop down?

I tried Googling whether it is possible with Azure PowerShell or CLI, but no luck.

[ enter image description here

](https://i.stack.imgur.com/i1Krc.png)

For the Function Apps, we have pricing tier grouping

[ enter image description here

](https://i.stack.imgur.com/Pnc1k.png)

For the APIM Services, we have pricing tier with the Group By Tier view:

[ enter image description here

](https://i.stack.imgur.com/WJgxy.png)

Service Wise - I can list the Pricing based using Grouping Column but how to list the resources with Pricing Tier based in the Subscription level resources - I cannot see any option "Grouping by pricing tier/tier/plan" in the grouping drop down?

I tried Googling whether it is possible with Azure PowerShell or CLI, but no luck.

[ enter image description here

](https://i.stack.imgur.com/i1Krc.png)

SwathiDhanwada-MSFT 19,073 Reputation points Moderator

2023-06-12T06:07:46.7266667+00:00

@krishna572 Thanks for your question. As far as I know, its not possible to group the resources by pricing tier at subscription level as the resources have different pricing tiers and some resources don't have pricing tiers at all.
krishna572 886 Reputation points

2023-06-12T06:55:43.94+00:00

@SwathiDhanwada-MSFT So, as an alternative - we can do only on service level listing. Is it?
krishna572 886 Reputation points

2023-06-20T03:13:19.73+00:00

Hi Swathi, If the above solutions are correct, you can convert it into well-drafted answer so that it would be beneficial to the community who get this requirement in the future and I can accept your answer.

1 answer

Your answer

SwathiDhanwada-MSFT 19,073 Reputation points Moderator

2023-06-12T06:07:46.7266667+00:00

@krishna572 Thanks for your question. As far as I know, its not possible to group the resources by pricing tier at subscription level as the resources have different pricing tiers and some resources don't have pricing tiers at all.
krishna572 886 Reputation points

2023-06-12T06:55:43.94+00:00

@SwathiDhanwada-MSFT So, as an alternative - we can do only on service level listing. Is it?
krishna572 886 Reputation points

2023-06-20T03:13:19.73+00:00

Hi Swathi, If the above solutions are correct, you can convert it into well-drafted answer so that it would be beneficial to the community who get this requirement in the future and I can accept your answer.

Answer 1

@krishna572 Apologies for the late response. Azure Resource Manager currently supports querying over basic fields like Resource name, ID, Type, Resource Group, Subscription and Location. To query extended properties its suggested to use Azure Resource Graph.

Here is sample example of listing the function app resources based on pricing tier.

resources
| where type =~ "Microsoft.Web/sites" and ['kind'] =~ "functionapp"
| extend  skua = properties.sku
| summarize resources = make_list(name) by tostring(skua)

Also, you can query resource graph queries using Azure PowerShell or Azure CLI. Below is sample snapshot executed in my environment.

User's image

Reference documents :

Share via

How to export the resources based on pricing tier in Azure Subscription level?

1 answer

Your answer