PowerShell to get any successful Azure object deployment or creation in the past 24 hours

Hello EnterpriseArchitect,

You're looking for ways to automate the deployment report daily and send it via email. The PowerShell you provided is PowerShell script that queries the activity log for the past 24 hours, Filters for successful operations like write, create, or deploy, and sorts and display relevant details.

To resolve this issue, follow these steps:

1. Create an Azure Automation Account resource in your azure portal
   • Go to Azure Portal
   • Create a resource > Automation Account
2. To Send an email, you can integrate it into an Azure Automation Runbook and use SendGrid for email delivery. Create SendGrid account, verify a Sender Identity, create a SendGrid API Key with "Mail Send" permission and assign necessary permission. Please follow the below doc to Send an email from an Azure Automation runbook | Microsoft Learn
3. Create and Publish the Runbook
   • Go to Azure Portal
   • Select the Automation Account which you previously created
   • Click on Create the Runbooks > Create a new PowerShell Runbook

Before publishing your runbook, modify your PowerShell Script to convert your logs to html format to send through email

# Make sure the Az module is installed & imported
# Install-Module Az -Scope CurrentUser
 Connect-AzAccount
 
# Define time range
 $startTime = (Get-Date).AddDays(-1)
$endTime = Get-Date
 
# Query the activity log
$logs = Get-AzActivityLog -StartTime $startTime -EndTime $endTime -Status Succeeded -WarningAction SilentlyContinue |
 Where-Object {
# OperationName usually contains verbs like 'write', 'create', 'deploy'
 $_.OperationName.Value -match 'write|create|deploy'
} |
Select-Object `
EventTimestamp,
ResourceGroupName,
ResourceId,
@{Name='Operation';Expression={$_.OperationName.LocalizedValue}},
Caller,
Status |
 Sort-Object EventTimestamp -Descending
# Convert results to HTML
$htmlBody = $logs | ConvertTo-Html -Property EventTimestamp, ResourceGroupName, ResourceId, Operation, Caller, Status -Title "Azure Deployment Report" | Out-String

Implement your email functionality via SendGrid in your PowerShell script. Please follow the below document for your reference: Send an email from an Azure Automation runbook | Microsoft Learn

Final step is to schedule and publish your runbook based on your convenience time.

• Go to your azure automation account
• Open the runbooks list (Under process automation > runbooks)
• Select the runbook which you created previously
• Paste your PowerShell script > Publish the Runbook
• Go to Schedules and create a new one
• Link the schedule to your Runbook

If you prefer using Microsoft 365 SMTP Instead of SendGrid, here is the working example and setup guide on GitHub’s Azure Automation SMTP sample.

Please let me know if you face any challenge here, I can help you to resolve this issue further.

Thank you @Bharath Y P ,
If I run this script once every 1 hour, I wonder what the charge or the costing will be ?

Hello EnterpriseArchitect, Azure Automation pricing is based on how long each job runs and how often it's executed. When scheduled to run hourly, especially with short execution times, the overall expense remains low. Using a PowerShell script in an Azure Automation Runbook on an hourly schedule is a cost-efficient approach under the standard pricing model.

You can verify this on the Azure Automation Pricing page

Hello EnterpriseArchitect, We wanted to follow up and see if the answer provided was helpful in resolving your issue. If you need any further assistance you, feel free to reach out if you have any more questions.Thanks

@Bharath Y P ,
OK, so this Azure Automation, do I need to run or install the PowerShell module somewhere to make it work with the AzMonitor https://learn.microsoft.com/en-us/powershell/module/az.monitor/get-azactivitylog?view=azps-14.3.0&viewFallbackFrom=azps-14.1.0?