This is likely something that’ll be rolled out in our organisation soon which is why I wanted to try this out in my lab beforehand.
We’ll start off with a high level overview of how I plan to meet the pre-requisites for this application and then proceed to implementing that in SCCM. This will probably be a pretty long post so I won’t be providing step by step instructions. Part 2 will cover creating the Box for Office Integration application, setting the application dependencies and testing our deployment.
Let’s take a look at the Box for Office integration pre-requisites:
- Windows 7 or higher
- Microsoft Office 2010 or higher
- Windows Installer 3.1, 4.5, or greater
- NET Framework 4.0
- Visual Studio 2010 Tools for Office v10.0.50701 or greater
Now, let’s take a look at how we plan on meeting these prerequisites for the deployment:
- We’ll create three device collections to identify computers with office 2010 or higher, each limited to Windows 7, Windows 8.1 and Windows 10 computer collections respectively. This will allow us to deploy the application to one collection at a time. Each collection will only contain computers with Windows 7 or higher AND Office 2010 or higher.
- We can safely disregard the Windows Installer requirement since the installer version is greater than 4.5 on all our operating systems in our collections by default
- We’ll create separate applications for the .NET Framework 4.0 and the Visual Studio 2010 Tools for Office Runtime in SCCM. For each application we’ll set the detection rule to check for the presence of specific registry keys/values in order to detect if the application is installed or not.
This will effectively meet all the prerequisites and we can proceed with deploying the application in Part 2. Now, let’s get onto implementing this in SCCM.
1) Create the Collections to Deploy the Application To
We’ll start off by creating separate device collections for Windows 7, Windows 8.1 and Windows 10 computers. We’ll then create three collections with Office 2010 or higher installed and limit each to the Windows 7, Windows 8.1 and Windows 10 device collections respectively.
a) Create a device collection each for Windows 7, Windows 8.1 and Windows 10:
The WQL queries to use for each OS version is provided below:
Windows 7 Continue reading