Power BI : Power BI SCCM Template from Microsoft

This post runs through the process of setting up Power BI and the SCCM template which will give you detailed information on your System Center Configuration Manager including client and server health, malware protection, software updates, and software inventory across your organisation. First things first, to run the Power BI SCCM template you need to running … Continue reading Power BI : Power BI SCCM Template from Microsoft

SCUP : Managing 3rd Party Updates in SCCM 2012 using SCUP

This guide will show you how to configure SCUP and deploy 3rd party updates(Adobe, Flash Player) With Microsoft Updates via SCCM 2012 using SCUP plus software update catalogs. Managing 3rd Party Updates in SCCM 2012 using SCUP 1- Installing and configuration SCUP 2011 It’s required to publish the updates to WSUS in order to deploy … Continue reading SCUP : Managing 3rd Party Updates in SCCM 2012 using SCUP

New Tool: ConfigMgr Client Notification



Today I whipped-up a very simple tool for ConfigMgr admins and support staff. It allows you to send client notifications (using the so-called fast channel), such as downloading the computer policy, collecting hardware inventory, checking compliance etc, to remote computers from your local workstation independently of the ConfigMgr console.


The tool connects to your ConfigMgr site server using a Cimsession and PSSession, so you need WsMan operational in your environment. You simply provide some computer name/s in the text box, enter your site server name, select which client notification you want to send and click GO. The tool will get the online status of the clients from the SMS Provider to give you an indication of which systems will receive the client notification. Then it will trigger the client notification on online systems from the site server.

The tool is coded in PowerShell / Xaml and uses the MahApps Metro…

View original post 112 more words

Monitor Content Downloads Between an SCCM Distribution Point and a Client


Sometimes you want to monitor the progress of a content download on an SCCM client from a distribution point. You can use the Get-BitsTransfer PowerShell cmdlet, but it doesn’t currently support running on remote computers, so I wrapped the cmdlet in a bit of extra code that lets you get Bits transfer information from a remote computer, and adds a couple of extra values like the transfer size in megabytes and gigabytes as well as a percent complete value. Run it while there’s an active transfer to monitor the progress.

Simply provide a computer name like so:

Get-BitsTransfers -ComputerName PC001

Function Get-BitsTransfers { [CmdletBinding()] Param ( [Parameter(Mandatory=$true, ValueFromPipelineByPropertyName=$true, Position=0)] $ComputerName ) Invoke-Command -ComputerName $ComputerName -ScriptBlock { $BitsTransfers = Get-BitsTransfer -AllUsers Foreach ($BitsTransfer in $BitsTransfers) { [pscustomobject]@{ DisplayName = $BitsTransfer.DisplayName JobState = $BitsTransfer.JobState OwnerAccount = $BitsTransfer.OwnerAccount FilesTotal = $BitsTransfer.FilesTotal FilesTransferred = $BitsTransfer.FilesTransferred BytesTotal = $BitsTransfer.BytesTotal MegaBytesTotal = [Math]::Round(($BitsTransfer.BytesTotal / 1MB),2) GigaBytesTotal…

View original post 24 more words

SCCM WSUS Sync errors/WSUS cleanup

When Rebooting Is Not The Answer

As an SCCM administrator it is easy to install SCCM and simply forget about WSUS being an integral part of SCCM and forgetting its even there.   That is until you start getting synchronization errors or other WSUS errors.  So to fix or prevent that from happening you should really go to the wsus server cleanup wizard which can be found in the wsus console under options.  What do you do though if you haven’t been running it and the wsus server cleanup wizard fails.
wsus error

Well to start you can rerun the wsus server cleanup wizard with all but the first option and then rerun with only the first option but that won’t always work especially if you are really behind on wsus cleanup.  So your options are to reinstall the wsus database or do a manual cleanup.  In the past when I had seen issues with this occur I had…

View original post 135 more words

SCCM Package not distributing

When Rebooting Is Not The Answer

So I had to delete a package off a distribution point and redistribute yesterday and ran into an issue where it would not distribute.  I continued to read my logs and noticed that the distmgr.log continually retried the package but never actually distributed it.  It just kept saying no action specified for package.  Well after a ton of research I came across a blog post detailing how resolve that.

First check your action and updatemask

This particular distribution point had an update mask and action totally different than any of the other servers.


I then deleted that record.

Once I did that I was able to finally redistribute the content.

Thanks a bunch to Daniel Eyer’s blog.


View original post

Getting email alert and smsts log when imaging fails via PowerShell

When Rebooting Is Not The Answer

So in follow up to my last post I have been testing a script to look for the smsts log when the task sequence fails and send me an email with the smsts.log as attachment.

I set this up in my MDT task sequence under the gather logs and statestore on failure section so that way whenever the task sequence has an error I get the logs.

I have a nice array of locations of the smsts log and a foreach loop to look through them test if they exist using Test-Path cmdlet and attach them to my email.

Seems to work well from what I have seen so far.

View original post

No software updates available after ConfigMgr site upgrade

SCCMentor - Paul Winstanley

I helped out a good friend of mine recently when he reported that the All Software Updates node in the SCCM console reported ‘No items found’ after a site upgrade from 1710 to 1802.


We attempted a few troubleshooting methods before hitting on the source of the problem and the smsprov.log provided the nugget of information that we could work from.

The following error occured:

Execute WQL =SELECT ci.* FROM SMS_SoftwareUpdate ci WHERE ci.CI_ID NOT IN ( SELECT CI_ID FROM SMS_CIAllCategories WHERE CategoryInstance_UniqueID=’UpdateClassification:3689bdc8-b205-4af4-8d4a-a63924c5e9d5′) AND ci.CI_ID NOT IN (SELECT CI_ID FROM SMS_CIAllCategories WHERE CategoryInstance_UniqueID=’Product:30eb551c-6288-4716-9a78-f300ec36d72b’) ORDER BY DateRevised DESC SMS Provider 23/04/2018 23:14:06 5900 (0x170C)
Execute SQL =select all ci.CI_ID,ci.LocaleID,ci.ApplicabilityCondition,ci.ArticleID,ci.BulletinID,ci.CI_ID,ci.CI_UniqueID,ci.CIType_ID,ci.CIVersion,ci.CMTag,ci.CMTagName,ci.ConfigurationFlags,ci.CreatedBy,ci.CustomSeverity,ci.CustomSeverityName,ci.DateCreated,ci.DateLastModified,ci.DatePosted,ci.DateRevised,ci.EffectiveDate,ci.EULAAccepted,ci.EULAExists,ci.EULASignoffDate,ci.EULASignoffUser,ci.IsUserCI,ci.InUse,ci.IsBroken,ci.IsBundle,ci.IsChild,ci.IsContentProvisioned,ci.IsDeployable,ci.IsDeployed,ci.IsEnabled,ci.IsExpired,ci.IsHidden,ci.IsLatest,ci.IsMetadataOnlyUpdate,ci.IsOfflineServiceable,ci.IsQuarantined,ci.IsSuperseded,ci.IsUserDefined,ci.LastModifiedBy,ci.LastStatusTime,ci.Description,ci.DisplayName,ci.CIInformativeURL,ci.LocaleID,ci.MaxExecutionTime,ci.ModelID,ci.ModelName,ci.NumMissing,ci.NumNotApplicable,ci.NumPresent,ci.NumTotal,ci.NumUnknown,ci.ObjectPath,ci.PercentCompliant,ci.PermittedUses,ci.PlatformType,ci.RequiresExclusiveHandling,ci.RevisionNumber,ci.SDMPackageVersion,ci.SedoObjectVersion,ci.Severity,ci.SeverityName,ci.SourceSite from fn_ListUpdateCIs(2057) AS ci where (ci.ModelName not in (select all Folder##Alias##810314.InstanceKey from vFolderMembers AS Folder##Alias##810314 where Folder##Alias##810314.ObjectTypeName = N’SMS_SoftwareUpdate’) AND (ci.CI_ID not in (select all SMS_CIAllCategories.CI_ID from fn_ListCICategoriesAll(2057) AS SMS_CIAllCategories where SMS_CIAllCategories.CategoryInstance_UniqueID = N’UpdateClassification:3689bdc8-b205-4af4-8d4a-a63924c5e9d5′) AND ci.CI_ID not in (select all SMS_CIAllCategories.CI_ID from…

View original post 269 more words

Syncing your Microsoft Store for Business apps with Intune

SCCMentor - Paul Winstanley

I recently published a guide on how to deploy a Store app via Intune to a Windows 10 device. I found the mechanism to get a valid Appstore URL a little messy to say the least and the Microsoft documentation didn’t add anything to assist. So how could we make life easier and what if we had a whole bunch of apps that we need to bring into Intune?

Thankfully, we can sync our Microsoft Store for Business (MSfB) apps with Intune (and other management tools) and make all your purchased applications available for assignment in minutes.

Conditions to consider

  • Intune must be the MDM authority within your organisation
  • You must have a MSfB account and this account cannot be changed post link.
  • Once the link is in place, apps purchased cannot be manually added or remove and must be synced.
  • Your devices must be Active Azure Directory or workplace joined…

View original post 397 more words