How to increase output rows in Resource Graph Query in Azure

Question

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?

score 0 · Accepted Answer · answered Nov 14 '22 at 13:56

0

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

answered Nov 14 '22 at 13:56

RithwikBojja

5,069
2
3
7

Thanks, Can't we get more than 1000 from powershell? – Mallikarjuna Reddy Nov 15 '22 at 09:12
Yes we can get, you can use your required number and you can use Resource graph explorer as given in answer as alternative. – RithwikBojja Nov 15 '22 at 09:32
Yes, since I am new, unable to upvote it. – Mallikarjuna Reddy Nov 17 '22 at 07:25
I am glad it worked for you. – RithwikBojja Nov 17 '22 at 07:32

How to increase output rows in Resource Graph Query in Azure

1 Answers1