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. Patch My PC Report

Change log

PreviousA look at the Power BI reportsNextVideo guides

Last updated 1 year ago

Was this helpful?

2024-04-26

Major rewrite. - Custom apps are now supported - Redesigned the report visually - Two separate reports are now available - the Overview report and the Detailed report. - A number of code improvements in the runbook - Moved the solution resources into its own GitHub repository

2024-04-17

Bug fix on the way app data is loaded into an array in the runbook.

2024-02-19

Cast dates into "s" (sortable) format to provide consistency and correct interpretation of dates by the PowerBI report. Increased the timeout for 429 http status codes from 5 minutes to 10 minutes.

2024-02-01

Removed the "Write-Output" command from the Get-PmpAppsList function because the results are sent to a variable and any additional output would break the list of apps returned.

2023-11-17

Added retry logic with a 5-minute timeout on the Get-DeviceInstallStatusReport function in the runbook, to handle non-success return codes.

2023-02-03

Updated both the runbook and the Power BI template to handle the scenario where they may be either no app or no updates deployed.

2023-01-18

Added code to the Azure automation runbook to fix a bug where the PowerBI report would error if there were no data returned for the statusoverview or deviceinstallstatus reports.

2022-07-08

Updated the Power BI template with a new-look dark theme. Added an "Application counts" chart on the installs report pages, as well as device and install counts, and an "install state" filter.

2022-07-08

Updated the Remove-MSGraphExportJobDuplicates function with some more efficient code that (in testing) is around 30% quicker. Thanks to for the tip on this!

2022-05-27

Major rewrite to move away from the reports/exportJobs Graph endpoint due to much tighter limits put in place by MS for frequent requests for jobs. Switched back to the reports/getDeviceInstallStatusReport endpoint again and used looping to overcome the current 50 item limit per request.

2022-05-12

Added a filter to the Request-ExportJobs function in the automation runbook to only include install states that are NOT 'not applicable'. This significantly reduces the overall processing time of the runbook where apps are targeted to a large number of devices for which the app is not applicable to that device.

2021-09-27

Added some retry logic to the Request-ExportJobs function in the runbook to handle when Graph returns a bad request response. This is in response to changes made to service limits in MS Graph around 2021-09-24.

2021-08-23

Switched from using the deviceManagement/reports/getDeviceInstallStatusReport Graph endpoint to exportJobs for the device installation status data due to the limitation of the endpoint only returning 50 results per call.

2021-08-23

Added a function in the runbook to create a unique result set for the device installation status data by including only the most recent entry per device

2021-08-23

Released version 1.1 of the Power BI report template removing the 'Not applicable' status from the donut charts for a better view.

2021-08-17

Fixed an issue with the automation runbook where it would fail if the number of apps or updates in an export job was a multiple of 20.

2021-07-07

Updated the runbook script to include better error handling and some retry logic in case the http 504 error (gateway timeout) is returned.

2021-07-01

Initial release

Yannick Van Landeghem