Need to configure Report to check daily backup, patch and Reboot status for azure virtual machine using Powershell script

Himanshu Garg 0

Need to configure Report to check daily backup, patch and Reboot status for azure virtual using Powershell script

Himanshu Garg 0 Reputation points

2024-05-10T18:04:57.2133333+00:00

IMG_20240510_233315544_HDR.jpgNeed to configure Report as per attached snip. Kindly help and suggest.

SadiqhAhmed-MSFT 39,326 Microsoft Employee

@Himanshu Garg Thank you for reaching out to us. To configure a report to check the daily backup - https://learn.microsoft.com/en-us/azure/backup/configure-reports?tabs=recovery-services-vaults#supported-scenarios

https://learn.microsoft.com/en-us/azure/backup/backup-reports-email?tabs=portal

Regarding patch, and reboot status for Azure virtual machines using PowerShell, you can use the following script:

# Connect to Azure
Connect-AzAccount

# Set the subscription context 
Set-AzContext -SubscriptionId <SubscriptionId>

# Get all virtual machines in the subscription $vms = Get-AzVM

# Initialize an array to store the report data $report = @()

# Loop through each virtual machine foreach ($vm in $vms) {
# Get the virtual machine name and resource group name $vmName = $vm.Name $resourceGroupName = $vm.ResourceGroupName

# Get the backup status for the virtual machine $backupStatus = Get-AzRecoveryServicesBackupItem -ContainerType "AzureVM" -FriendlyName $vmName -ResourceGroupName $resourceGroupName | Select-Object -ExpandProperty BackupStatus

# Get the patch status for the virtual machine $patchStatus = Get-AzVM -ResourceGroupName $resourceGroupName -Name $vmName | Select-Object -ExpandProperty OsProfile | Select-Object -ExpandProperty WindowsConfiguration | Select-Object -ExpandProperty PatchSettings | Select-Object -ExpandProperty PatchMode

# Get the last reboot time for the virtual machine $lastRebootTime = Get-AzVM -ResourceGroupName $resourceGroupName -Name $vmName | Select-Object -ExpandProperty InstanceView | Select-Object -ExpandProperty Statuses | Where-Object { $_.Code -eq "PowerState/running" } | Select-Object -ExpandProperty Time

# Add the report data to the array $report += [PSCustomObject]@{ VMName = $vmName ResourceGroupName = $resourceGroupName BackupStatus = $backupStatus PatchStatus = $patchStatus LastRebootTime = $lastRebootTime

}

}

# Export the report to a CSV file $report | Export-Csv -Path "C:\Reports\AzureVMReport.csv" -NoTypeInformation

Hope this helps!

Share via

Need to configure Report to check daily backup, patch and Reboot status for azure virtual machine using Powershell script