Enhance Update Compliance Reporting with Microsoft Endpoint Manager

If you're using Windows Update for Business in Microsoft Endpoint Manager you're probably also using Microsoft's Update Compliance solution for reporting. Update Compliance contains some useful data and I know the team are working on additional improvements. A while back I created my own "Update Compliance" solution in part because I wasn't happy with the … Continue reading Enhance Update Compliance Reporting with Microsoft Endpoint Manager

Strategies for Dealing with Load and Concurrency in PowerShell Azure Functions

In this blog I'm documenting some of my experiences and recommendations for dealing with high load and concurrent invocations in Azure Functions - specifically for PowerShell functions. It's not exhaustive and if you have some recommendations of your own, please do comment. I use Azure functions quite a bit for things like serverless APIs, reporting … Continue reading Strategies for Dealing with Load and Concurrency in PowerShell Azure Functions

Why you may want to add a full synchronization schedule on ConfigMgr collections synced with AAD groups

Let me start with a little story behind the reason for this post 🙂 This morning I was happily working away when my VPN connection dropped. I noticed the icon of the VPN software disappear from the notification area and I immediately recognised the behaviour - the VPN client was getting an upgrade. As it … Continue reading Why you may want to add a full synchronization schedule on ConfigMgr collections synced with AAD groups

Purging Table Data from a log Analytics Workspace

I was working on a solution recently that uses Log Analytics to store data so I can easily chart the data changes over time, but on one particular date I got some bad data added and this caused my time chart to looked skewed: So I looked into how I could remove the data from … Continue reading Purging Table Data from a log Analytics Workspace

Create an HTML Report for Proactive Remediations Issues and Errors

Have you ever wanted to get a quick overview of issues or errors or remediations occurring in your Intune Proactive remediations scripts? I wrote a script that will gather this info for you and generate an HTML report. You can optionally send the report by email and even set up automation to send it out … Continue reading Create an HTML Report for Proactive Remediations Issues and Errors

Creating Compatibility Collections for Windows 11 in MEMCM

The other day I tweeted a screenshot of collections I had created in MEMCM for Windows 11 based off custom inventoried data - this post is just to explain how they were created and provide scripts and files for you to do the same if you wish. https://twitter.com/SMSagentTrevor/status/1446523800246489089 The data is inventoried from Windows 10 … Continue reading Creating Compatibility Collections for Windows 11 in MEMCM

Windows 11 Hardware Readiness Report for Power BI

So, Windows is 11 is out and Microsoft recently added Windows 11 hardware readiness insights to Endpoint Analytics in Microsoft Endpoint Manager allowing you to identify which devices in your Intune tenant are eligible for upgrade and which are not and why. Read the official announcement here. To supplement this report, I've created a Power … Continue reading Windows 11 Hardware Readiness Report for Power BI

MEMCM Client Content Downloads Report for Power BI

!Update 2022-03-08! Fixed an issue with the Power BI template where the following SQL error may be returned for large boundary group strings: STRING_AGG aggregation result exceeded the limit of 8000 bytes. Use LOB types to avoid result truncation. I was checking out some reports recently for client data sources (DP, BranchCache etc) for MEMCM … Continue reading MEMCM Client Content Downloads Report for Power BI

Report on Overlapping Boundaries in MEMCM

Having boundaries that overlap with other boundaries can be a royal pain in MEMCM if those boundaries are in different locations - unless identified and sorted out you can potentially have clients getting content from undesired sources - across the continent or even across the world in some cases! I prepared the following script that … Continue reading Report on Overlapping Boundaries in MEMCM

Use Proactive remediations to report on or install the Microsoft Update Health tools

Microsoft recently made a download available for their Update Health tools - if you're using Microsoft Endpoint Manager and enrolling or co-managing Windows devices these tools need to be installed to make use of the capability for expediting quality updates. For devices connected to Windows Update or Windows Update for Business these tools should already … Continue reading Use Proactive remediations to report on or install the Microsoft Update Health tools