Search code examples
azureazure-devopsazure-active-directoryazure-powershellazure-resource-graph

How to increase output rows in Resource Graph Query in Azure


I am using Resource Graph Powershell module to query all the recent change details in my Subscription.

https://learn.microsoft.com/en-us/azure/governance/resource-graph/how-to/get-resource-changes?tabs=azure-powershell

But though there are many changes happened, the query is returning at max 100 at a time. So is there a way to get the complete records?

Is there a way to get all available records from Resource Graph module?


Solution

  • I have reproduced in my environment and got expected results as below and I followed Microsoft-Document:

    $count= Search-AzGraph -Query 'resourcechanges | project properties.changeAttributes.timestamp, properties.changeType, properties.targetResourceId, properties.targetResourceType, properties.changes' -First 1000
     $count | Measure-Object     
    

    enter image description here

    So you need to use -First Paramter

    Or you can use the query directly in Azure Resource graph Explorer as below:

    enter image description here