Azure Backup Reports
A new feature is in public preview, the Azure Backup Reports. Now we can have the Azure Backup Reports at the OMS Workspace, Event Hub and Power Bi. You can use Power BI to view report dashboard, download reports and create custom reports
The configuration has two steps, one to configure the Azure Backup Reports connection with each service and the other is to get the data at each service.
First go to a Recovery Services vault and select Backup Reports. Next press the Configure button.
The Diagnostic settings blade will open. Change the Status to “On” and select the desired services to collect the Azure Backup Logs.
For the Power Bi integration we need a Storage account. So check the “Archive to storage account” option and select a storage account. The storage account must be at the same region as the Azure Backup account.
To integrate with OMS check the “Send to Log Analytics” option and select an OMS Workspace.
An other option is to stream the Azure Backup logs to event hub. To configure it check the “Stream to an event hub” and select the event hub namespace and policy name.
At the bottom part of the configuration blade select the Logs that you want to get. The retention days option is only for the Storage Account configuration.
Press save and return to the Backup reports blade. Now press the “Sign in” to connect to Power Bi to configure the Service.
At the lower left corner of the Power Bi Portal press “Get Data”
At the AppSource press the “Get” button under the Services.
Search and select the “Azure Backup”
At the connect to Azure Backup page enter the Storage Account name. This is the storage account that we selected at the Azure Backup Reports configuration.
Press next and Save. Now the Azure Backup workspace is ready. Be patient, it needs time to start reporting data.
If you go back to the Azure Portal, the Backup Reports blade has changed and it only has the option to connect to your Power Bi dashboard.
If you browse to your Power Bi dashboard, you can view the Azure Backup Reports Workspace as the below image.
For the OMS integration, you only need to go to the Log Search and query “Category=”AzureBackupReport” and you will have all the Azure Backup Report logs. Following the OMS logic you can create a custom View, you can follow this post: Azure Log Analytics
Azure Log Analytics | CPU Performance Monitor
In this article we will create a CPU Performance monitor View for our servers at the Azure Log Analytics (OMS) Portal.
At the Microsoft Operations Management Suite (OMS) portal press the + button to create a new View
The View Designer workspace will open. Select the “Line chart & callout”
At the Properties blade enter a Name, something like “CPU Performance Monitor”, add the below query and press Apply
Type:Perf CounterName=“% Processor Time” InstanceName=“_Total” | measure avg(CounterValue)by Computer Interval 10Minutes
Pressing Apply you will see at the Preview window the “Name” and the CPU Performance of all the Windows servers that are monitored by OMS agent.
The next step is to press the “+ View” tab and add a “Stack of line charts
The “Stack of line charts” will add three charts per row and we can use it to add our servers. We will create something like that:
So, at the Properties blade add a name and a query for each server needs to be monitored and press Apply. For more than three servers add more “Stack of line charts”.
The query is the below, just change the Computer = “server.domain.local” with your servers.
Type:Perf CounterName=“% Processor Time” InstanceName=“_Total” AND Computer =“server.domain.local” | measure Avg(CounterValue) as ‘CPU_Percentage’ by Computer Interval10Minutes
Finally press “Save” at the View Designer
The result is a CPU Performance monitor for all servers at the OMS Portal.
And when you press it you have the CPU Performance Monitor of all added servers.
Stay tuned for the next part