Ability to query Virtual Machine resource type by state of the VM.

I can today make querys and export to visualize in Power BI. It would be nice to somehow easier connect from Power BI to Resource Graph to visualize Resources.

I am able to filter out resources by provider (e.g., 'Microsoft.Network'), higher-level types (e.g., 'Microsoft.Network/dnszones'), and some level-2 resource types (e.g., 'Microsoft.Compute/virtualMachines/extensions'). However, not all resource types are supported by Resource Graph. For example, DNS Zone record types aren't supported. I would like to get a response for a query like this one:

az graph query -q "where type =~ 'microsoft.network/dnszones/cname'"

Resource graph queries are great at returning SubscriptionId. But a GUID is unfriendly. Provide a function or means for retrieving the subscription display name. For example:

where type contains 'publicIPAddresses' and properties.ipAddress != ''
| summarize count () by subscriptionName(subscriptionId)

For scenarios where we need the resources to be synced into an external store, we want the history so that I don't need to scan all the resources again.

Currently, the Resource Graph API expect a list of subscription IDs to be passed in as part of the request body. This is very troublesome when you need to query all subscriptions in a tenant or a management group. Please add support for allowing wildcard for the subscriptions value i.e. "*", and extend the support for management groups.

For faster and more complex queries I need to find Resource Groups using Graph. E.g. show me all Resource Groups with tag X across my tenant. Looping through 200 subscriptions is very time consuming. Also hope that it will allow more complex queries comparing resource tag values to Resource Group tag values.

The resource graph query is limited to ARM resources, it would be very useful to add the ability to query the child objects of a resource.

I am able to filter out resources by provider (e.g., 'Microsoft.Network') and higher-level types (e.g., 'Microsoft.Network/dnszones'). However, not all resource types are supported by Resource Graph. For example, DNS Zone record types aren't supported. I would like to get a response for a query like this one:

az graph query -q "where type =~ 'microsoft.network/dnszones/cname'"

In the same way that Log Analytics displays the Kusto query when filters are applied, it would be great if Resource Graph could do this too so the queries could be saved and used via API calls, etc.

Provide a way to get a description of each type in the resource graph, much like the first "Type" field (display name of resource type) in the "All resources" pane in the Azure portal

Allow more than 100 items to be exported in azure resource graph
If a limit is needed, 100 seems a bit small

The category type Meter category, which is available at billing modul is not available at resource graph.
It is only the resource type category available, that is not the same as meter category.
So it is not possible to make billing queries in billing modul and compare this with counts from resources in resource graph.

Please add support for type :

Microsoft.Sql/servers/firewallRules

https://docs.microsoft.com/en-us/azure/templates/microsoft.sql/2015-05-01-preview/servers/firewallrules

Please introduce new operators like all_of() & any_of() for array members query.

Today I have to specify an index if I want to query alertRules with a specific property value, ie:

where type =~ 'microsoft.insights/alertrules'
| where properties.actions[0].sendToServiceOwners == "true"

I would like a way to query if any or all items in the array are matching

Please add support for listing all role assignments

Resource Type: Microsoft.Authorization/roleAssignments

https://docs.microsoft.com/en-us/azure/templates/microsoft.authorization/2017-09-01/roleAssignments

Please add support for listing all custom role definitions

Resource Type: Microsoft.Authorization/roleDefinitions

https://docs.microsoft.com/en-us/azure/templates/microsoft.authorization/2017-09-01/roledefinitions

It would be great to add ability to capture the user/owner information for all resource types in Resource Graph. Currently, for a lot of resource types, e.g., Machine Learning Services Workspace, etc., the user/owner information is not available in the resource graph. Which is a critical information a lot of customers are looking for.

Customers would like to get all the virtual machines across different types.