Identify Office Products with its architecture using SCCM report

Benoit LecoursConfiguration Manager, OFFICE, REPORT, Reports, SCCM, SSRS17 Comments

I did blog post year ago on Microsoft office product versions with its architecture type and count. But lately, my blog readers have requested to add Office 365 ProPlus product into the report. The Original Office Product report was created to include all Microsoft Office products from Office 2007 to Office 2016 but it doesn’t have any click-to-run (C2R) products which are Office 365. So we started looking around and developed the report for you. This free report will have all Microsoft Office products information with its architecture type (x86 or x64) and the count. The report can be run on a specific collection which is useful to scope specific group of machines. This can be used as all-in-one SCCM report for Microsoft Office product versions with architecture type. This report comes with a drill-down feature to see the list of all devices with the selected product. You’ll need our … Read More

SCCM Office 365 Inventory Report

Benoit LecoursHardware Inventory, OFFICE, REPORT, SCCM98 Comments

This post describes how to inventory Office 365 using SCCM 1606. We will also provide a free report at the end of the post that you could use on your Reporting Point to easily display Office 365 inventory data. SCCM 1606 introduces new hardware inventory classes for Office 365 configurations. You no longer need to edit your MOF files to gather Office 365 inventory. If you are using SCCM 1602 or below, follow Jason Sandys post which describes Office 365 inventory process using a MOF customization. If your goal is to deploy Office 365 updates, refer to our post on how to manage Office 365 updates using SCCM. SCCM Office 365 inventory report post summary : SCCM Office 365 Inventory Report – Direct Download link If you don’t want to read the whole post, you can download the RDL file directly using this link : Office 365 Inventory Data Office 365 is using new update channels and update mechanisms. Tracking versions and update … Read More

Create Office 365 Installer using SCCM

Jonathan LefebvreApplication, OFFICE, SCCM15 Comments

There have been many different posts about deploying Office 365 with SCCM. The majority of them used the Office Configuration tool in a more or less creative way. An easier method has been available for awhile to help SCCM admins to create the “perfect” Office 365 package. The SCCM Office 365 Installer is a new feature released in SCCM 1702. SCCM Office 365 Installer provides an easy-to-use wizard to define every related item for an Office 365 application. Whether you are new to creating Office 365 package or simply want to refresh an older package, this solution will ease every step of creating an Office 365 package. In this post, we will detail how to use the Office 365 Installer creation wizard. If you are looking for How to Update Office 365 using SCCM, see our previous post. Prerequisites SCCM Current Branch 1702 and up Create SCCM Office 365 Installer Package Browse … Read More

Install Specific Office 365 Version using SCCM

Benoit LecoursOFFICE, SCCM2 Comments

Managing Office 365 with SCCM is becoming a popular task among SCCM administrators. Depending of your company policy and Office 365 Channel, you may have to manage/install/uninstall specific version on client computers no matter the available version in your assigned channel. For example, you may want to downgrade an up-to-date Monthly version (v1711) to a Deferred version(v1705). This procedure also works to upgrade a Deferred version to an up-to-date version. Please note that this procedure is not meant to change Office Channel on a client, use this to install a specific version no matter the Channel. Package Creation The first thing to understand is that to update an Office installation, you need to use the OfficeC2RClient.exe program that resides on the client. This command support various command line and switches. In our example, we will use Updatetoversion to specify the version 7766.2119 (1701) and forceappshutdown to force Office applications to close. The tricky … Read More

How to setup Telemetry Dashboard for Office 2016

Jonathan LefebvreOFFICE13 Comments

An area that is hard for IT admins to get feedback is how Office is doing in their environment. Unless users call in for support, there is not much more information easily available. A less known Office feature is available for free as part of the Office suite. The Office Telemetry Dashboard can help assess all kind of compatibility issues that could happen as part of a major upgrade and help to identify the potential risk ahead of an upgrade. The Office Telemetry dashboard was first introduced with Office 2013. It was released to replace the previous solution Office Migration Planning Manager (OMPM). The Office telemetry could be used in the following scenarios : Planning a major upgrade to Office 2016 from older versions Monitor your Semi-Annual Channel (Targeted)  installations as they received newer major build ahead of the Semi-annual Channel In this post, we will describe how to plan, install … Read More

Switch from Office 365 Deferred Channel to Current Channel using SCCM

Benoit LecoursOFFICE, SCCM9 Comments

Today, I’ve been ask to switch a couple of hundred Office 365 Deferred Channel to Current Channel. At first, I wasn’t sure if there was a supported way to do that. I start googling around and I ran into this Microsoft support article. Before going technical, you maybe wondering why you would want to do this. Well, for a couple of reason : You just installed Office 365, and you’re on the Deferred Channel and want to change to Current Channel A fix has been released and you want to move to the Current Channel to receive it A new feature has been released and you want to move to the Current Channel to receive it All actions in this blog post has been executed on a Windows 10 64-bits computer and Office 365 32-bits (Deferred Version 1602  – build 6741.2071). Create SCCM Office 365 Switch Channel Script The script provided by … Read More

Office 365 2016 Activation Problem after Upgrade from Office 365 2013

Jonathan LefebvreOFFICE, SCCM1 Comment

In a previous post, we covered how to upgrade Office 365 2013 to Office 365 2016. We came across an issue after the upgrade is completed. Once you start any Office application, Office 365 2016 ask for activation, which will fail if attempted and then ask for repair. This can be quite confusing for user.   [su_box title=”Error message” style=”glass” title_color=”#F0F0F0″] We’re sorry, but Excel has run into an error that is preventing it from working correctly. Excel will need to be closed as a result. Would you like us to repair now? [/su_box]   Following the activation try, an error prompts : In this post, we will detail how to fix this activation issue as part of the upgrade process. Problem While the Office 365 upgrade is running, the UserOperations registry key is removed. Solution Re-create the registry key after the upgrade of Office 365 is completed. We will use … Read More

How to upgrade Office 365 2013 to Office 365 2016 Click-to-run

Jonathan LefebvreOFFICE, SCCM2 Comments

With the end of support for Office 365 2013 on Febuary 28 2017, administrators must take action to upgrade Office 365 2013 to Office 365 2016. In previous posts, we covered how to manage updates for Office 365 2016 with SCCM and describe the Office 365 dashboard. Those posts applies to the 2016 version of Office 365. This post will cover everything you need to know to upgrade Office 365 2013 to Office 365 2016 with SCCM. Upgrade Office 365 2013 Prerequisites Latest Office 365 2016 version : Version 16.0.6965.2117 from January 2017 was used for this post We selected the Deferred Channel Latest Office deployment tool SCCM 2012 and later Create Download.xml and Configuration.xml File Office 365 Click-to-run installations, are controlled by XML files. We will create and use one XML file to download the Office 365 bits for an offline installation/upgrade and another XML for the configuration. The download.xml specify the Channel to be used, the product  and language : … Read More

Managing Office 365 Updates with SCCM

Jonathan LefebvreOFFICE, SCCM59 Comments

SCCM Office 365 updates management is finally integrated to the standard software update process (since the release of SCCM 1602). Prior to this release it was announced as a new features, but it was not completely managed. It was necessary to add Office 365 updates to WSUS manually in order to manage them trough SCCM software update afterward. It’s now manageable natively with the release of SCCM 1602. The integration of Office 365 Updates to SCCM will ease overall management of updates with these key features : Centralized management Standard Software Update Ability to use Automatic Deployment Rules Easier distribution to branch offices with Software Update packages Applications can run while updating Before this integration, Office 365 Updates needed to : Manually downloaded Manually distributed or to create a package than distribution on Distribution Point Application need to be shut down before the update This post will explain how to natively manage Office 365 desktop client … Read More