!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
Category: Packages
Get Program Execution History from a ConfigMgr Client with PowerShell
Have you ever been in the situation where something unexpected happens on a users computer and people start pointing their fingers at the ConfigMgr admin and asking "has anyone deployed something with SCCM?" Well, I decided to write a PowerShell script to retrieve the execution history for ConfigMgr programs on a local or remote client. … Continue reading Get Program Execution History from a ConfigMgr Client with PowerShell
Downloading the Latest Dell Driver Packs with PowerShell
It was a regular Tuesday morning and I hadn't yet had my 'PowerShell fix' for the week, so when I realised I needed to download a new driver pack from Dell for my ConfigMgr OS deployments, I could hear a faint voice calling out to me: 'Dude, I can make your life easier! Work smarter, not harder!' … Continue reading Downloading the Latest Dell Driver Packs with PowerShell
ConfigMgr Content Distribution Fails with 0x80041001
Today I came across an unusual issue on a couple of SCCM distribution points where two particular software update packages were failing to distribute. Using the distmgr.log and the PkgXferMgr.log on the site server, as well as the Distribution Point Job Queue Manager tool, I could see that these packages were trying to distribute again … Continue reading ConfigMgr Content Distribution Fails with 0x80041001
New Free App – ConfigMgr Deployment Reporter
Just released a new free application for ConfigMgr admins - ConfigMgr Deployment Reporter. I developed this app for use in the organisation I currently work for, and it turned out quite well, so I decided to release a public version to the community! I developed this app as an alternative (and IMO easier) way to … Continue reading New Free App – ConfigMgr Deployment Reporter
Temporarily Increasing the ConfigMgr Client Cache Size for a Large Application
Recently I had to deploy an application whose content files were larger than the default SCCM client cache size (5120 MB). This will return an error in the Software Center, such as: 0x87D01201 (The content download cannot be performed because there is not enough available space in cache or the disk is full.) I didn't … Continue reading Temporarily Increasing the ConfigMgr Client Cache Size for a Large Application
Prompting the End-User during ConfigMgr Application Installs
As a Configuration Manager administrator, from time to time I have to deploy an application where I need to notify the end-user of something before the installation begins. A recent example was a plugin for IE that would fail to install if Internet Explorer was running at the time. I can force-ably kill the running … Continue reading Prompting the End-User during ConfigMgr Application Installs
Redistribute Failed Package Distributions in ConfigMgr with PowerShell
Here's a little script I wrote based on one written by David O'Brien that allows you to redistribute failed package distributions in Configuration Manager by selecting which packages you want to redistribute. First the script queries WMI to find packages that are not in the "installed" state, ie the distribution is not successfully completed. It … Continue reading Redistribute Failed Package Distributions in ConfigMgr with PowerShell
Retrieving Software Inventory for a ConfigMgr Site with PowerShell
In my last post, I demonstrated how we can retrieve software inventory information for a single ConfigMgr client or an array of clients, using PowerShell. In this post, we will change the scope from the client to the entire site. Using this script, you can query for all installations of a specific software/s in your ConfigMgr site, … Continue reading Retrieving Software Inventory for a ConfigMgr Site with PowerShell
Create a Database of Error Codes and Descriptions for Windows and ConfigMgr
In a recent post, I described different ways to translate error codes for Windows and Configuration Manager into their friendly descriptions. In this post, I will show you how to create a SQL database of known error codes and descriptions that you can join to in your SQL queries, to help simplify your troubleshooting, and … Continue reading Create a Database of Error Codes and Descriptions for Windows and ConfigMgr