Servers Backup Status Report Generation and Servers Uptime Report generation


Servers Backup Status Report Generation

 

  1. To Generate the Backup status report for Backups > Go to Azure portal > Recovery Service Vault > Backup vaults (We have 3 vaults for Farm servers)

Here in Vault for example:
Go to Jobs > Backup jobs
Select the filter option to generate the failed jobs report.
Please update the parameters as mentioned below. (Start date end should for the required month.)
Jobs will be filtered, and failed jobs can be captured as below. You can also export the same in CSV format using export Jobs option.
You need to calculate the Backup KPI using below formula.
  • Farm 01 PROD = 10 VMs
  • Total Jobs = 10 Jobs/Day & 300 Jobs/Month
  • Successful backups = 297
  • Failures = 3
  • Service Degradation = 1 %
  • Healthy = 99%


Customers Servers Uptime Report generation
For sample customer Azure VMS uptime reports are generated through a Monitoring solution - OMS (Operations Management suite)
OMS link:   https://Sample customer name-manageservices.portal.mms.microsoft.com   (Required appropriate permission to access)
Once you logged into the OMS, You will be landed in the below workspace.

Please select the logs search option as shown below
Mention the custom date to generate the report for specify period. Ex: Sep 1 – 30th for monthly uptime report.
Run the below command in the search bar to get the uptime report.
search in (Event) "uptime" | project Computer, EventID, RenderedDescription// Oql: Type=Event "uptime" | Select Computer,EventID,RenderedDescription // Args: {OQ: True; WorkspaceId: 0ef8a6db-9937-47af-8137-fee08dbf8b0d} // Settings: {PTT: True} // Version: 0.1.132
Output will be as shown below and same can be exported to CSV format using export option available in the top left corner.
Below is the sample format of output. Uptime is generated in Seconds.
Output needs to be converted from Seconds to days for understandable format.
In case you see multiple entries for same, You need consider the latest entry for the uptime of an VM.  In below example for sample server name, we need to consider 50.27 days as a uptime of the VM.
And the Uptime needs to be update in required format for Customer servers.
Example:










Comments

Popular posts from this blog

NetSH collection commands

Script for Host entry in remote servers