Azure Resource Grah Explorer query CSV results automation

Question

hello,

I have recently picked up a use case as follows,

1) I need to run a query from the Azure Resource graph and export those results on daily basis to the Azure database

2) I'm currently running query (KQL to know about resources in Azure) and exporting into CSV file, sending them manually

how I can achieve this automatically where my query runs a daily basis and send that CSV file to Database?

Answer 1

Hi @SPK545 ,

AFAIK you should be able to achieve it with the help of Az PowerShell cmdlet Search-AzGraph or Az CLI command az graph query or Az REST API Resources - Query and then exporting the output and sending it to a destination or (to a database as in your case).

For example, below is the Az PowerShell command to export all resources details.

Search-AzGraph -Query "Resources" -first 1000 | epcsv .\testgraph.csv -NoType  

Note that, by default this procedure returns only 100 records but it can return maximum up to 5000 records so with the help of -First parameter you may explicitly mention the number of records that you wanted to return.

Along with it, you may come up with code snippet to send the output to required destination (say database) and schedule it to run on daily basis by saving the complete code as script in a Azure Automation runbook or Azure Logic App, etc.

On the other hand as shown in below screenshot, portal way provides options to download the csv and pin to dashboard but not an option to export data to external sources like PowerBI, EventHub, DB, etc. so if interested, you may raise a feature request for it here. In general, Azure feature or product team would check feasibility of a feature request, prioritize against existing feature backlog, add in roadmap as appropriate and would announce and/or update the related Azure document once a feature request is addressed.

Answer 2

Thanks, @tbgangav-MSFT ,

In fact, I'm trying to use a graphical runbook (don't know much about Powershell) to automate this process and designed a flow as well, I am getting an error, not sure what I'm missing here