smsagent.blog
Search…
smsagent.blog
docs.smsagent.blog
Custom Reporting in Microsoft Intune
Automating Data Exports from Microsoft Graph
Managed Devices Report
Patch My PC Report
Windows 11 Hardware Readiness Report
Gathering Custom Inventory with Intune
PowerShell Scripts Online Help
Get-AzSubscriptionActivityLog
Powered By GitBook
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.
Previous
Feedback
Next
Gathering Custom Inventory with Intune
Last modified 11mo ago
Copy link
Outline
Overview
Configure Azure Resources
Azure automation runbook
Parameters
Power BI Template
Feedback