Azure Resource Friendly display names via Api

Question

How can I get friendly Display name (specially for SubscriptionName) via Azure Resource Query graph ? I am running it via API and getting the sys name.

Answer 1

@Pratik Kumar (z) Welcome to Microsoft Q & A Community Forum. You can use below query to retrieve the subscriptions names from management group.

resourcecontainers  
| where type == "microsoft.resources/subscriptions"  
| project name  

Or you can retrieve the list of resources along with the subscription name and resource type using below resource graph query.

resources  
| join kind=inner (  
    resourcecontainers  
    | where type == 'microsoft.resources/subscriptions'  
    | project subscriptionId, subscriptionName = name)  
    on subscriptionId  
| extend rt = split(type,"/")  
| extend resourcetype = rt[1]  
| project subscriptionName, resourceGroup, name, resourcetype  

Let me know if you are looking for something else. If the above queries has helped you, kindly "Accept As Answer" so that it would be beneficial for other community members who are looking for similar solution.