Download Office 2016 Updates Easier

I am a firm believer of keeping your Office installation source fully patched. This can reduce your deployment time and increase security while improving the end user experience. I have written a simple script that downloads all required Office 2016 x86 software updates using a list of updates I have published and data pulled from ConfigMgr based on entries in that list. I have a previous blog post on how to do this using ConfigMgr to search for available software updates download them to a deployment package, remove any problem updates and then extract the MSP files. This works great, but I wanted to create a script that can do the same thing but with far fewer steps.

The script can be located here

Requirements

All the software updates defined in this file must be synced with ConfigMgr software updates. i.e. you should see them under “All Software Updates” They don’t have to be downloaded or deployed though.

You need to run this script as a user who has permissions to ConfigMgr.

Internet access.

How it Works

This script will query ConfigMgr and determine the URL to download the updates cab file.

The cab files are downloaded and any MSP files are extracted.

The MSP files are named KBXXXXXXX-[GUID].msp and saved to wherever you specified with the StagingLocation variable. Why the GUID? Some of the cab files downloaded have multiple MSP files.

I will be updating this file semi regularly. Follow my GitHub repository notifications of when I update it or do it yourself and send me a pull request.

Update Office Source

Copy the files to your Office2016 Installation source\Updates folder.

If you are using ConfigMgr to deploy these updates refresh the content on deployment type(s) for your Office application.

If you want avoid this nonsense in the future start using Office 365 Click-to-Run.

Usage Example

 

Enjoy your nicely updated Office 2016 x86 installation source.

 

This is a very simple script that can be extended pretty easily for increase automation. I purposely made this as simple as possible.

Windows Update Analytics not syncing with ConfigMgr (1610 fast ring)

Problem

After configuring ConfigMgr to integrate with Windows Update Analytics no data appears in the console after potentially days and days.

Upon inspection the DMPDownloader.log has the following:

And the SMS_CLOUDCONNECTION.log:

Resolution

After way too much troubleshooting I found my problem.  I opted into the CM 1610 fast ring and that release was a little raw at first.  After installing Configuration Manager 1610 Hotfix (KB3214042)  this problem resolved almost immediately.  This was thankfully my lab, but this is another reason why the fast ring is probably not a good idea for your production environment.

The data was visible in the console minutes after the KB installation completed.

Functioning DMPDownloader.log

Moved OMS Page

Functioning SMS_CLOUDCONNECTION.LOG

Working Dashboard –

Finding and Removing Unused ConfigMgr Drivers

This is this the third and final part of my series on driver management in ConfigMgr.  Part 1 can be found here. Part 2 can be found here.

The script can be found here.

Driver Cleanup

Have you ever tried to clean up old or unused drivers in ConfigMgr and quickly became overwhelmed?  It can become pretty hard to determine what drivers are truly not in use since if you attempt to import drivers that already exist, which is pretty common, you can quickly run into drivers that are in several driver packages and driver categories which can make for a challenging puzzle to unravel.  Or at least it can be pretty time consuming.  Unfortunately it is not as easy as simply deleting driver packages for unused hardware models.

“In Use” Drivers

So, how do we determine what drivers are actually no in use?  Let me first define what “in use” means as far as drivers in ConfigMgr are concerned.  If any of these conditions are true a driver is consider “in use”:

  1. The driver is in a Driver Package that is referenced by a Apply Drivers step of a task sequence.
  2. The driver is in a Driver Category that is referenced by an Auto Apply Drivers step of the task sequence.
  3. The driver is imported into existing boot media.

There is a caveat if you are using an auto apply drivers step utilizing all available drivers as your primary method of deploying drivers during OSD this script probably isn’t of too much use to you and will generate a warning during execution that can be ignored if so desired.  There is really no way to logically determine which drivers are not in use if they are applied in this manner since you are technically using them all.  The script will still run and report back unused drivers, it just can’t be trusted.  If you are using an auto apply drivers step but scoping it to particular categories, this script will work just fine.

Warning
Sometimes it is just tempting to delete the driver source files and neglect the driver content ConfigMgr.  This could be done to free up space on a site server for example.  This is bad idea.  Don’t do this.  You have to delete the drivers from the console first before deleting the source.  Trust me.

The Script

Requirements –

  • Windows Management Framework (PowerShell) 5.0 – I use custom classes, because they are awesome.
  • The ConfigurationManager PowerShell module. This is available anywhere the ConfigMgr console is installed.

Before using this script it is highly recommended to clean and/or delete any legacy task sequences.  At the very least remove any apply drivers steps from existing task sequences you know are not being used.

Notes

  • This script can take a while to run depending on your environment.  (45+ minutes)
  • This heavily utilizes PowerShell verbose output and creates a very detailed transcript file.
  • An HTML report will be created when the HtmlReport parameter is provided. It defaults to UnusedDrivers.html.
  • This script makes use of the “WhatIf” functionality of PowerShell. Use this if you want to report on missing drivers without deleting them.

Usage –

Discover what drivers are not in use but do not delete them. (WhatIf)

Delete unused drivers ignore warnings for auto apply all drivers steps.

 

Delete unused drivers with warnings when auto apply all drivers steps are found.

 

ConfigMgr Client Push Installation Failing

Retrieved package version ’23’. But it is smaller than the expected version ’24’. Content is not ready yet.
GetDPLocations failed with error 0x87d00215
Failed to get DP locations as the expected version from MP ‘server.domain.local’. Error 0x87d00215

You can find this in the ccmsetup.log on a client device.

clientcontentnotready

This happened to me after a 2012 r2 to Current Branch upgrade. (SQL, OS, everything)  At some point the client package got out of whack apparently.  To resolve refresh the content of the Configuration Manager Client  Package and this error goes away. Viola!

Removing ConfigMgr Drivers with missing source files

You can find the drivers with missing source files removal script here.  This is the second article in a series a driver articles. You can find part 1 here.

Driver management with ConfigMgr can be a bear at times.  Without some attention to detail towards organizing your driver source locations it is not uncommon for driver source files to be deleted before the driver is removed from ConfigMgr, by accident or otherwise.  This can end up being a real pain in the long run.  If source files are missing you can have problems with distributing, deploying drivers as well as maintaining boot images.

Notes

  • An HTML report will be created when the HtmlReport parameter is provided. It defaults to UnusedDrivers.html.
  • This script makes use of the “WhatIf” functionality of PowerShell. Use this if you want to report on missing drivers without deleting them.
  • This heavily utilizes PowerShell verbose output and creates a very detailed transcript file.
  • This requires PowerShell 5.0 or higher.

Usage

Discover what drivers are missing source files but do not delete them. (WhatIf)

 

Delete drivers with missing source files.

 

 

Delete drivers with missing source files and create a html report named “MyUnusedDrivers.html”.

 

Keep your driver repository clean!

Import boot image drivers from existing boot image

With the new “Current Branch” model of ConfigMgr and Windows 10 we can expect a faster release cycle of the ADK, which means new boot images pretty regularly!   Creating new boot media is really simple.  However, reimporting all of your required drivers into that boot image can be a real chore.  Here is a script that that identifies the drivers in a source boot image and imports them into a destination image.  This should reduce time to create usable boot media significantly.  Give it a spin and give me some feedback.

The script can be found here .

Usage –

Enjoy!

“Mfc120u.dll is missing from your computer” when viewing Status Message Queries in ConfigMgr Console

When trying to view status message queries from the ConfigMgr console –

mfc120udll

The program can’t start because mfg120u.dll is missing from your computer.  Try reinstalling the program to fix this problem.

You are missing the VCRuntime 2013 x86.  The installer can be normally be found at \\primarysiteserver\sms_xxx\client\i386\vcredist_x86.exe or from Microsoft

vcredisInstall

Maintaining Your Office 2016 Installation Source

Deploying an updated Office installation has always been an annoyance of mine.  It is ideal to be able to deploy a fully updated Office installation so you don’t have to run a software update scan and then wait for all the office patches to download and install.  Having to install less software updates can reduce your deployment or build and capture times significantly.

Side Note –  To avoid all of this legacy overhead, use Office 365 Click to Run edition.   It is easier to deploy and manage the click to run editions of Office because there is built in functionality to keep your installation source up to date without having to identify, download and test each individual update.

Fred has joined Now Micro and is passionate about PowerShell and how it can make life so much easier.  The solution laid out below can reduce your deployment time and complexity around deploying and managing Office.

The Updates Folder

To install Microsoft Office software updates as part of the Office suite deployment you can download the applicable updates and place them in the updates folder of the Office source installation.  These are in the form of MSP files.  This is a well-documented process that hasn’t changed for a while.

MaintainingOffice1

The biggest challenge with this has always been locating all the available updates for your particular Office installation.  Sifting through the windows update catalog is a real chore and I am lazy, so I looked to enlist the help of ConfigMgr and PowerShell.

In the site settings for your software update point be sure that you have selected the Office 2016 product.  Do this and then synchronize your software updates point if you haven’t already.

MaintainingOffice2

Download all Office 2016 Software Updates, that are not expired, not superseded and for the appropriate architecture (32 or 64 bit) to a new Software Updates Deployment Package. Filter your search results to just include the architecture you are looking for.  (64-bit or 32-bit)

MaintainingOffice3

Select all updates (ctrl-a), right click and select Download.

MaintainingOffice4

Create a new Deployment Package when prompted. Take note of the Package Source folder. It will be referenced later.

MaintainingOffice5

This will download all the source files to wherever you specified when you created the Software Updates Deployment Package.  A unique directory (sometimes more than one) is created for each software update in the Deployment Package.

MaintainingOffice6

Remove the problematic updates –

Remove the following updates from your Deployment Package before proceeding.  These updates for reasons unknown will fail to install during the deployment and will cause the installation to return a failure error code.  These can be removed directly from the Deployment Package using the ConfigMgr console. (Right click each update and select delete)

64-Bit

KB3114861

KB2920726

KB3101512

KB3114511

KB3114518

KB3114527

32-Bit

KB2910978

KB2920726

KB3101512

KB3114527

KB3114861

KB3114511

KB3114518

Each folder created during the software update download will have a .cab file that contains the Office update MSP you are interested in.  If you start extracting these archives you will quickly notice that all the software updates for Excel are named the same. This behavior is the same for all products in the suite.  (Word, OneNote, etc.).  PowerShell to the rescue!

This script will extract the MSP files from each cab archive, save them with a unique name, copy them to the updates folder of the Office installation and then clean up .  To use this script modify the parameters of the Get-Office2016MSPsFromCab function to match your environment or specify them explicitly when running the function.

MaintainingOffice7MaintainingOffice7

The script in its entirety can be found here.

I hope you find this useful!   Contact me at @FredBainbridge with specific questions.

Enable Isolated User Mode in Windows 10

UPDATE –
This for any Windows 10 release pre 1607 (Anniversary Edition).  With 1607 this functionality is baked into Hyper-V.
—-
You need to enable Isolated User Mode in Windows 10 if you want to, among other things, utilize the virtual TPM chip in generation 2 virtual machines.  If you try to start a gen 2 virtual machine with the TPM chip enabled but without Isolated User Mode enabled you get this error message –
VirtualTPMErrorFirst, own and activate your TPM chip and then run the following PowerShell commands –

Did you reboot after doing this and expect it to work but it didn’t?  Check out the event log and then activate your TPM chip!

TPMActivationNeeded