smsagent.blog
Search…
Windows 11 Hardware Readiness Report
Overview
This Power BI report is more or less a mirror of what is available in Endpoint Analytics and is built from the same data. It allows you to see which devices in Intune are ready for Windows 11 and which are not and the reasons why.
The report uses the same process as the other reports in this site, ie an Azure automation account runbook exports the data from Microsoft Graph and sends it in CSV format to an Azure storage account container. The Power BI report then connects to the storage account and uses the CSV file as the source for the report. Scheduling the runbook to run regularly and scheduling a refresh on the Power BI report will keep the data up-to-date.
Configure Azure Resources
If you've already created any of my other reports in this site or used the same process, ie Azure automation runbook > Azure blob storage, you'll already have the Azure resources in place to run this report. Otherwise you'll need to create them using the guides below.
For API permissions for the managed identity of the automation account, the following minimum are needed for this report:
- DeviceManagementConfiguration.Read.All
- DeviceManagementManagedDevices.Read.All
- DeviceManagementManagedDevices.ReadWrite.All
Make sure that the Az.Accounts and Az.Storage modules have been imported into the automation account.
Azure automation runbook
Download the runbook script below and create a runbook in your automation account. Set a recurring schedule for the runbook as needed, eg once a day.
MEM/Export-Windows11ReadinessData.ps1 at main · SMSAgentSoftware/MEM
GitHub
Parameters
You'll need to set the following parameters in the top of the runbook script:
- $ResourceGroup - the name of the resource group containing the storage account you are using
- $StorageAccount - the name of the storage account that will contain the exported data
- $Container - the name of the container in the storage account
Power BI Template
Once you have executed the runbook and got data in your storage account, download the open the Power BI template below.
MEM/Windows 11 Hardware Readiness.pbit at main · SMSAgentSoftware/MEM
GitHub
Upon opening, you'll be prompted for your storage account name and the container name:
If you haven't connected to the storage account with Power BI before, you'll be prompted for the account key, which you can find under Access keys in the storage account.
Once the data has loaded in, you can publish your report to the Power BI service and set a refresh schedule. Make sure there is an offset between when the automation runbook is scheduled and when the Power BI report is scheduled to refresh.
Feedback
Feel free to send any feedback here.
Last modified 3mo ago