Azure Proactive Resiliency Library v2
Tools Glossary GitHub GitHub Issues Toggle Dark/Light/Auto mode Toggle Dark/Light/Auto mode Toggle Dark/Light/Auto mode Back to homepage

Reports Cmdlet

Overview

The Reports cmdlet serves as the final step in a Well-Architected Reliability Assessment (WARA) engagement. It takes the Excel spreadsheet generated by the Data Analyzer cmdlet and converts it into Microsoft PowerPoint and Excel formats. The Reports cmdlet automates the process of creating comprehensive reports from the analyzed data, making it easier to share insights and recommendations.

Requirements

  • Windows Environment Only (Cloud Shell is not supported)
  • PowerShell 7.4
  • ImportExcel PowerShell Module
    • If you do not have this module, then it is installed automatically when you run the Start-WARAReport cmdlet.
  • Microsoft Excel and PowerPoint installed
  • Role Based Access Control: Reader role to access to resources to be evaluated. Although access to the Azure Subscriptions is not required to run the script, the access will be required for the user to complete some manual validations of configurations of Azure resources after the script generates the Excel file.

Quick Start (Local Windows Machine only - Cloud Shell is not supported)

Start-WARAReport

The Start-WARAReport cmdlet is used to generate the WARA reports.

Whatever directory you run the Start-WARAReport cmdlet in, the PowerPoint and Excel files will be created in that directory. For example: if you run the Start-WARAReport cmdlet in the C:\Temp directory, the PowerPoint and Excel files will be created in the C:\Temp directory.

You can review all of the parameters of Start-WARAReport here.

Examples

Create the PowerPoint and Excel reports from the Action Plan Excel output

Start-WARAReport -ExpertAnalysisFile 'C:\WARA\Expert-Analysis-v1-2025-02-04-11-14.xlsx'

Create the PowerPoint and Excel reports from the Action Plan Excel output using the alias ExcelFile for the parameter

Start-WARAReport -ExcelFile 'C:\WARA\Expert-Analysis-v1-2025-02-04-11-14.xlsx'

Create the PowerPoint and Excel reports from the Action Plan Excel output specifying the customer name and workload name

Start-WARAReport -ExpertAnalysisFile 'C:\WARA\Expert-Analysis-v1-2025-02-04-11-14.xlsx' -CustomerName "Contoso" -WorkloadName "Contoso Web App"

Document Review

After the documents have been created, review the PowerPoint presentation and the Excel file to ensure that the data is accurate and that the recommendations are appropriate for the workload. Not all slides are updated by the automation and require manual review and updates.

Frequently asked questions

I get errors when running the script that .Copy() or .Paste() has no data or the clipboard cannot be used

The script uses the clipboard to copy and paste data between Excel and PowerPoint. We are aware that this can cause issues when running the script and using your clipboard at the same time. We plan on having a fix for this released soon, however, in the meantime, please ensure that you are not using your clipboard while the script is running. There is also a known issue with clipboard history enabled. The cmdlet will check to see if the clipboard history feature is enabled and throw an error. To disable clipboard history, follow the steps below:

  • Open the Settings app.
  • Go to System > Clipboard.
  • Turn off the Clipboard history toggle switch.

The specified Excel file may be encrypted. If a sensitivity label is applied to the file, please change the sensitivity label to the label without encryption temporarily

The specified Excel file may have a sensitivity label (encrypted). The Start-WARAReport script does not support encrypted Excel file currently. To avoid this issue, you need to change the sensitivity label to the label without encryption temporarily. For example, Confidential/Any User (No Protection) sensitivity. After running the command, you can re-apply the original sensitivity label (recommended). You can change the sensitivity label on the file by Excel or Information Protection File Labeler.