It generates a report on a daily basis and distributes it to management to reflect the status of the environment across platforms.
With Excel VBA (Visual Basic for Applications) you can automate tasks in Excel by writing macros.
Information is gathered from different platforms in depending on the format in which the environment supplies it. Most data is collected from the SCOM Data Warehouse by importing reports generated by SCOM in .csv format and then analyzing it in Excel.
 |
| A snapshot of the report. A scrolling matrix shows the status of the last 10 days. Drill down is possible when more information is required about specific environments. |
The process is fully automated except for comments that engineers need to add in order to explain the failures/issues and action plans. This ensures that problems are highlighted and dealt with and management stays informed.
 |
The backup results is achieved via monitoring event logs with SCOM |
