automate some reports from Azure portal weekly basis

Question

automate some reports from Azure portal weekly basis

Mostafa 45

Hello ,

how can i automate some tasks in azure portal that will be exported as csv files

Example of tasks :

Navigate to Business Continuity Center > Jobs

Change time range from default “Last 6 hours” to “Last 2 weeks”

Export to CSV

Thank you

Pranay Reddy Madireddy 6,180 Reputation points Microsoft External Staff Moderator

2025-06-19T20:59:21.2366667+00:00

Hi Mostafa

To automate tasks in the Azure portal that will export reports as CSV files, you can utilize the capabilities of Azure services like Microsoft Defender for Cloud. Here’s a general approach:

Verify that you have Microsoft Defender for Cloud enabled on your Azure subscription.

Navigate to the Microsoft Defender for Cloud section in the Azure portal.

You can export alerts or recommendations to a CSV file by selecting the appropriate option:

For alerts, go to Security alerts and select Download CSV report.

For recommendations, go to Recommendations and select Download CSV report.

https://learn.microsoft.com/en-us/azure/defender-for-cloud/export-alerts-to-csv#export-recommendations-to-a-csv-file

To automate this process, you can create a scheduled task using Azure Logic Apps or Power Automate that triggers the export process at your desired frequency.

Kindly let us know if the above helps or you need further assistance on this issue.

Please do consider to “up-vote” wherever the information provided helps you, this can be beneficial to other community members.
Ashok Gandhi Kotnana 10,115 Reputation points Microsoft External Staff Moderator

2025-06-20T01:59:55.2+00:00

@Mostafa

Just want to check if the above answer worked for you or else please let us know if any help, we are always here to help whenever you need us.

Please do not forget to "Accept the answer” wherever the information provided helps you, this can be beneficial to other community members.it would be greatly appreciated and helpful to others.
Mostafa 45 Reputation points

2025-06-20T08:00:44.7833333+00:00

Hello @Pranay Reddy Madireddy

Thank you for your update

When I navigate to Azure logic Apps , I got this screen asking to create a user account for application

is Azure logic Apps enabled by default for all account ?

is there any cost If I enable this apps for our account and create an Id ?

Thank you
Naveena Patlolla 3,605 Reputation points Microsoft External Staff Moderator

2025-06-23T02:49:07.8766667+00:00

Hi Mostafa
Just checking in to see if the below answer provided by @Mark Thwaite helped.

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know

1 answer

Your answer

Pranay Reddy Madireddy 6,180 Reputation points Microsoft External Staff Moderator

2025-06-19T20:59:21.2366667+00:00

Hi Mostafa

To automate tasks in the Azure portal that will export reports as CSV files, you can utilize the capabilities of Azure services like Microsoft Defender for Cloud. Here’s a general approach:

Verify that you have Microsoft Defender for Cloud enabled on your Azure subscription.

Navigate to the Microsoft Defender for Cloud section in the Azure portal.

You can export alerts or recommendations to a CSV file by selecting the appropriate option:

For alerts, go to Security alerts and select Download CSV report.

For recommendations, go to Recommendations and select Download CSV report.

https://learn.microsoft.com/en-us/azure/defender-for-cloud/export-alerts-to-csv#export-recommendations-to-a-csv-file

To automate this process, you can create a scheduled task using Azure Logic Apps or Power Automate that triggers the export process at your desired frequency.

Kindly let us know if the above helps or you need further assistance on this issue.

Please do consider to “up-vote” wherever the information provided helps you, this can be beneficial to other community members.
Ashok Gandhi Kotnana 10,115 Reputation points Microsoft External Staff Moderator

2025-06-20T01:59:55.2+00:00

@Mostafa

Just want to check if the above answer worked for you or else please let us know if any help, we are always here to help whenever you need us.

Please do not forget to "Accept the answer” wherever the information provided helps you, this can be beneficial to other community members.it would be greatly appreciated and helpful to others.
Mostafa 45 Reputation points

2025-06-20T08:00:44.7833333+00:00

Hello @Pranay Reddy Madireddy

Thank you for your update

When I navigate to Azure logic Apps , I got this screen asking to create a user account for application

is Azure logic Apps enabled by default for all account ?

is there any cost If I enable this apps for our account and create an Id ?

Thank you
Naveena Patlolla 3,605 Reputation points Microsoft External Staff Moderator

2025-06-23T02:49:07.8766667+00:00

Hi Mostafa
Just checking in to see if the below answer provided by @Mark Thwaite helped.

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know

Answer 1

Hi Mostafa,

I agree with Pranay's approach, but to solve your challenge of recurring automation I'd recommend using Azure Logic Apps.

I've working with automated reporting and exporting as xlsx and csv recently, and there are a few ways you can achieve this - but my recommendations depend on you having Azure Log Analytics enabled for your subscription and needing to learn or already be familiar with Kusto Query Language (KQL).

Method 1: Use Azure Logic Apps and Azure Automation -
Once you've established Log Analytics, navigate to the log analytics console and enter Kusto query similar to below:

AzureDiagnostics

| where Resource == "AzureBackup"

| where OperationName == "BackupJob"

| where TimeGenerated > ago(14d)

| project TimeGenerated, JobStatus, JobType, ResourceGroup, Resource

*You will need to adjust the query to your specific resource, timeframe and what you want to display ('project')

When you have a suitable query, create an Azure Logic App (recommended over Power Automate flows due to better at handling critical business processes, and no 'premium' connectors).

Trigger - A recurrence (eg. 8am each day or specific day of the week),
Action 1 - Use the Azure Monitor Logs connector to run your KQL query,
Action 2 - Use create CSV table to convert the query results
Action 3 - Use a create file action (OneDrive, SharePoint, or Blob storage connector), to output your csv table as a csv file. Alternatively you can put the csv table output into a send an email action (Outlook)

Method 2: Use Azure Logic Apps and an Azure Automation Runbook (more complex than method 1) -
A similar method that will still need your KQL query, you can create a similar Logic App workflow, but call an Azure Automation runbook ***create job ***action to execute your KQL query in PowerShell.

Please note: You won't be able to just paste your query into PowerShell, from experience I needed to format it slightly to work in PowerShell. Ideally you should also return the data in JSON format.
Also: You will need specify on the create job action, that it needs to wait for the process to finish - see the additional options on the connector.

Your Logic App workflow will be identical to method one, except instead of the Azure Log Analytics action, you'll be using 2 Azure Automation actions - one to create the job and one to get job output - and then a Parse JSON action to collate the data.

The rest of your workflow will be the same as method one (csv table, create file).

I hope this helps, best of luck!

Mostafa 45 Reputation points

2025-06-20T08:12:16.8533333+00:00

Hello @Mark Thwaite Thank you for your update

When I tried to navigate to Use Azure Logic Apps or Azure Automation -

I got a screen "provision user accounts" ?

Provision User Accounts

You'll need to create user accounts in the application

Are these two applications included by default in all subscriptions?

Will creating this user account incur any costs for our company?

Thank you ,
Mark Thwaite 10 Reputation points

2025-06-20T08:27:09.6933333+00:00

Hi Mostafa,

As with all Azure products, there will definitely be costs incurred unfortunately.

From my work with Azure Automation and Logic Apps, the costs don't seem to be very high (particularly if you opt for consumption Logic Apps rather than Standard) - as with all things it's entirely dependent on your contract with Microsoft, your usage, even the frequency at which you are planning to run automation (Consumption logic apps are charged per action and per run).

Since costs are subjective, I'd recommend using the Microsoft Azure Pricing Calculator: https://azure.microsoft.com/en-us/pricing/calculator/

Note: Make sure you select the correct region and currency to get a more accurate estimate. This will allow you and your business to budget for any Op-Ex costs related to this.

I've not seen the 'Provision User Accounts' message before, but did a quick google on it:
Here are the possible causes:

First-Time Setup or Permissions Issue:

If you're accessing these services for the first time, Azure might prompt you to provision or assign user roles.

You may not have the necessary permissions (like Contributor or Owner) on the Azure subscription or resource group.

Azure Active Directory (AAD) Integration:

Azure Logic Apps and Automation often require integration with Azure AD.

If your account isn’t properly provisioned in AAD or lacks the right roles, Azure may redirect you to a provisioning screen.

Enterprise or School Account:

If you're using a work or school account, your organization might enforce provisioning policies before allowing access to certain services.

Azure Portal Glitch or Misrouting:

Occasionally, the Azure portal may misroute you due to session issues or cached data.

I hope the above helps!

Share via

automate some reports from Azure portal weekly basis

1 answer

Your answer