Create Microsoft Office mobile apps in ConfigMgr 2012 R2 SP1 with PowerShell
Now that everyone is looking at the excellent MDM capabilities in ConfigMgr 2012 R2 SP1, many will most likely deploy the Microsoft Office mobile apps to their corporate devices. I’ve done this myself a couple of times at various customers, and it’s quite time consuming to create the same applications in ConfigMgr over and over again. So I decided to create a script that would let me decide what Microsoft Office mobile apps to create, or simply the whole set of apps.
Download the script
I’ve made the script available on TechNet Gallery.
This script has a set of parameters that is required for it to function properly. Below you’ll find a description of those and if they’re required or not:
|True / True||String||This should reflect the Primary Site server where the SMS Provider is installed. If the SMS Provider is installed on a remote Site server, specify that remote server instead.|
|AppName||Single||True||String Array||This parameters accepts a set of predefined app names, e.g. Word, Excel etc as a string array, or simply a single app.|
|All||All||True||Switch||When this switch is specified, all of the Microsoft Office mobile apps will be created as applications in ConfigMgr.|
Using the script
You can run the script either locally on your Primary Site server or on a remote machine where the ConfigMgr console (or Configuration Manager Cmdlet Library) is installed. I’ve not tested the script remotely, so let me know if you run into any issues with that. The below instructions will show you how to use the script to create all of the Microsoft Office mobile apps.
1. Download the script from the TechNet Gallery and unpack it to e.g. C:\Scripts on your Primary Site server.
2. Open an elevated PowerShell console and run the following command:
.\New-CMOfficeMobileApp.ps1 -SiteServer CAS01 -All -Verbose
3. Once the script has successfully completed, open the ConfigMgr console and check the Applications node.
If you have any questions or suggestions for improvements to this script, let me know.
Principal Consultant and Enterprise Mobility MVP since 2016. Nickolaj has been in the IT industry for the past 10 years specializing in Enterprise Mobility and Security, Windows devices and deployments including automation. Currently working for TrueSec as a Principal Consultant. Awarded as PowerShell Hero in 2015 by the community for his script and tools contributions. Creator of ConfigMgr Prerequisites Tool, ConfigMgr OSD FrontEnd, ConfigMgr WebService to name a few. Frequent speaker at conferences and user groups.