smsagent.blog
  • docs.smsagent.blog
  • Custom Reporting in Microsoft Intune
    • Delivery Optimization Report
    • Windows Update for Business Custom Reporting
      • Power BI Report Walkthrough
      • Known issues / limitations
      • Change log
      • Deploy the solution
        • Create Azure Resources
        • Configure Azure Resources
        • Deploy the client-side script
        • Deploy the Azure automation runbooks
        • Configure the Power BI report
      • Adding additional language support
      • Table schema reference
    • Automating Data Exports from Microsoft Graph
      • Azure Automation account
        • Create / configure an Azure automation account
        • Grant API permissions
        • Create an Azure automation runbook
      • Azure Storage account
      • Automate Data Export to Azure Storage Account
      • Automate Data Export to Azure Monitor Logs
      • Creating / Troubleshooting Runbooks
      • Power BI
        • Connect Power BI to an Azure storage account data source
        • Connect Power BI to an Azure log analytics workspace as a data source
    • Managed Devices Report
      • Create / configure an Azure automation account
      • Grant API permissions
      • Create / configure an Azure storage account
      • Create an Azure automation runbook
      • Create a PowerBI report
      • MEM Managed Device Report template
      • Bonus! Unhealthy MEMCM Clients email report
    • Intune Assignments Report
      • Create / configure an Azure automation account
      • Grant API permissions
      • Create / configure an Azure storage account
      • Create an Azure automation runbook
      • Create a Power BI report
      • Change log
    • Patch My PC Report
      • A look at the Power BI reports
      • Change log
      • Video guides
      • Things to know
      • Create / configure an Azure automation account
      • Grant API permissions
      • Create / configure an Azure storage account
      • Create an Azure automation runbook
      • Create the Power BI report
      • Feedback
    • Windows 11 Hardware Readiness Report
    • Gathering Custom Inventory with Intune
      • Set up the Azure Resources
      • Create a Proactive remediations script package
      • Create a runbook
  • PowerShell Scripts Online Help
    • Get-AzSubscriptionActivityLog
  • Azure Solutions
    • Automated Azure Table Storage Backups
      • Change log
      • Deploy the solution
        • Create the Azure resources
        • Set the backup schedule
        • Add storage tables to the backup
        • Add role assignments to the storage account/s
        • Create a lifecycle management rule
      • Run a manual backup
      • Restore a backup
Powered by GitBook
On this page

Was this helpful?

  1. Custom Reporting in Microsoft Intune
  2. Windows Update for Business Custom Reporting

Change log

A history of changes

Date
Description

2024-04-09

Published v1.4 of the Power BI template which removes outdated OS versions in the Readiness page and focuses readiness just on Windows 11 23H2.

2024-03-25

Updated the devices KQL query in the summarizer runbook to better handle tables where some of the columns may not be present, or not yet be present, due to an incomplete data set in the source tables. Also update the Power BI template with similar changes to its queries.

2023-11-16

Improved the parsing of the latest regular update release date in the summarizer runbook.

2023-10-20

Updated W10 update history URL in the New-UpdateHistoryTable function in the summarizer runbook as MS broke the existing shortlink URL. You must update this runbook for it and the report to continue working correctly.

2023-05-12

Updated the automation runbook with minor bug fixes for the Get-WUErrorCodes and Get-WindowsSetupErrorCodes functions; for the former handling the removal of duplicated error codes, for the latter excluding a couple of headers added to the web page since initial release that caused non-terminating errors. The Power BI template has also been updated to v1.2, updating the WUErrorCodes query to handle the possibility of duplicate error codes.

2023-02-10

Fixed a bug in the Proactive remediations script that caused the most recent feature update upgrade date to not always be reported.

2023-02-08

Updated the WU error code functions in the summarizer runbook to reflect changes made to the layout of the source web pages. Since the layouts were changes these functions were producing non-critical errors.

2022-12-20

Updated the Power BI template to version 1.1 which fixes an issue where the WU_PolicyUpdate table query may fail if all the required columns are not (or not yet) present in the source log analytics table.

2022-12-01

Improved the way the OS Upgrade date is detected in the client-side script for feature updates

2022-11-29

Initial public release

PreviousKnown issues / limitationsNextDeploy the solution

Last updated 1 year ago

Was this helpful?