{"id":988,"date":"2016-09-19T15:49:08","date_gmt":"2016-09-19T14:49:08","guid":{"rendered":"https:\/\/www.lieben.nu\/liebensraum\/?p=988"},"modified":"2016-09-19T15:49:08","modified_gmt":"2016-09-19T14:49:08","slug":"ems-case-distributing-office-templates-and-macros-to-your-users-on-windows-10-mobile-managed-azure-ad-joined-devices","status":"publish","type":"post","link":"https:\/\/lieben.nu\/liebensraum\/2016\/09\/ems-case-distributing-office-templates-and-macros-to-your-users-on-windows-10-mobile-managed-azure-ad-joined-devices\/","title":{"rendered":"EMS case: distributing Office templates and macro&#8217;s to your users on Windows 10 mobile managed Azure AD Joined devices"},"content":{"rendered":"<p>Azure AD, Intune and Windows 10 offer an incredibly nice light management option, where your users can use any Windows 10 Pro or higher device and simply join it to your Azure AD on their own.<\/p>\n<p>Intune then allows you to enforce your security policies on those devices, and to distribute AppX and MSI packages to those devices.<\/p>\n<p>Traditionally, IT used to manage devices using GPO&#8217;s or more, allowing a very high degree of granular configuration and remediation. Intune or the Enterprise Mobility Suite don&#8217;t offer good alternatives for Group Policy, and don&#8217;t\u00a0allow scripts to be deployed natively, this greatly limits us.<\/p>\n<p>However, the ability to deploy an MSI can be leveraged to still offer any of the granular management we used to do.<em> I would very, very strongly advocate only using this as a last resort, don&#8217;t swim against the current, let users manage their own device and move to a services based architecture for your organisation&#8217;s IT.<\/em><\/p>\n<p>Today&#8217;s case for a global\u00a0NGO with a fully EMS licensed user base covers the distribution and installation of a large number of templates for Microsoft Word, including a normal.dot, macro&#8217;s and the required group policy settings to make word use these templates.<!--more--><\/p>\n<p>Requirements:<\/p>\n<ul>\n<li>A test user with an EMS licence (or seperate Azure AD Premium and Intune)<\/li>\n<li>Source files<\/li>\n<li>Google<\/li>\n<li><a href=\"http:\/\/www.advancedinstaller.com\/\">Advanced Installer<\/a> (free license)<\/li>\n<\/ul>\n<p>Steps:<\/p>\n<p>First, let&#8217;s start a &#8216;Simple&#8217; project in Advanced Installer, this does not require a license, and drag your files into a new folder under Program Files in the Files and Folders menu:<\/p>\n<p><a href=\"https:\/\/www.lieben.nu\/liebensraum\/wp-content\/uploads\/2016\/09\/ai_templates_1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-989\" src=\"https:\/\/www.lieben.nu\/liebensraum\/wp-content\/uploads\/2016\/09\/ai_templates_1.png\" alt=\"ai_templates_1\" width=\"1042\" height=\"466\" srcset=\"https:\/\/lieben.nu\/liebensraum\/wp-content\/uploads\/2016\/09\/ai_templates_1.png 1042w, https:\/\/lieben.nu\/liebensraum\/wp-content\/uploads\/2016\/09\/ai_templates_1-300x134.png 300w, https:\/\/lieben.nu\/liebensraum\/wp-content\/uploads\/2016\/09\/ai_templates_1-1024x458.png 1024w, https:\/\/lieben.nu\/liebensraum\/wp-content\/uploads\/2016\/09\/ai_templates_1-768x343.png 768w\" sizes=\"auto, (max-width: 1042px) 100vw, 1042px\" \/><\/a><\/p>\n<p>These will then end up in the c:\\program files (x86)\\&lt;chosen foldername&gt; location on the target client.<\/p>\n<p><em><a href=\"http:\/\/gpsearch.azurewebsites.net\/\">Searching for the right registry keys corresponding to a GPO setting?<\/a><\/em><\/p>\n<p>Now create registry keys under the correct Office registry branch (16.0 for Office 2016) to direct Office to the right location. SharedTemplates should point to the folder where your company templates exist. UserTemplates should point to a folder where the user has write-access, usually somewhere in AppData.<\/p>\n<p><a href=\"https:\/\/www.lieben.nu\/liebensraum\/wp-content\/uploads\/2016\/09\/ai_templates_2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-990\" src=\"https:\/\/www.lieben.nu\/liebensraum\/wp-content\/uploads\/2016\/09\/ai_templates_2.png\" alt=\"ai_templates_2\" width=\"1057\" height=\"401\" srcset=\"https:\/\/lieben.nu\/liebensraum\/wp-content\/uploads\/2016\/09\/ai_templates_2.png 1057w, https:\/\/lieben.nu\/liebensraum\/wp-content\/uploads\/2016\/09\/ai_templates_2-300x114.png 300w, https:\/\/lieben.nu\/liebensraum\/wp-content\/uploads\/2016\/09\/ai_templates_2-1024x388.png 1024w, https:\/\/lieben.nu\/liebensraum\/wp-content\/uploads\/2016\/09\/ai_templates_2-768x291.png 768w\" sizes=\"auto, (max-width: 1057px) 100vw, 1057px\" \/><\/a><\/p>\n<p>My templates have a so called <a href=\"https:\/\/support.office.com\/en-us\/article\/Load-or-unload-a-template-or-add-in-program-2479fe53-f849-4394-88bb-2a6e2a39479d\">startup folder<\/a>, if you point word to this folder Word will load all templates in there, our most important one was a normal.dot containing a selector macro, lets set the registry key for that:<\/p>\n<p><a href=\"https:\/\/www.lieben.nu\/liebensraum\/wp-content\/uploads\/2016\/09\/ai_templates_3.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-991\" src=\"https:\/\/www.lieben.nu\/liebensraum\/wp-content\/uploads\/2016\/09\/ai_templates_3.png\" alt=\"ai_templates_3\" width=\"1027\" height=\"348\" srcset=\"https:\/\/lieben.nu\/liebensraum\/wp-content\/uploads\/2016\/09\/ai_templates_3.png 1027w, https:\/\/lieben.nu\/liebensraum\/wp-content\/uploads\/2016\/09\/ai_templates_3-300x102.png 300w, https:\/\/lieben.nu\/liebensraum\/wp-content\/uploads\/2016\/09\/ai_templates_3-1024x347.png 1024w, https:\/\/lieben.nu\/liebensraum\/wp-content\/uploads\/2016\/09\/ai_templates_3-768x260.png 768w\" sizes=\"auto, (max-width: 1027px) 100vw, 1027px\" \/><\/a><\/p>\n<p>And don&#8217;t forget to add a few keys to ensure the locations we&#8217;ll be making word access are trusted locations:<\/p>\n<p><a href=\"https:\/\/www.lieben.nu\/liebensraum\/wp-content\/uploads\/2016\/09\/ai_templates_4.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-992\" src=\"https:\/\/www.lieben.nu\/liebensraum\/wp-content\/uploads\/2016\/09\/ai_templates_4.png\" alt=\"ai_templates_4\" width=\"1108\" height=\"351\" srcset=\"https:\/\/lieben.nu\/liebensraum\/wp-content\/uploads\/2016\/09\/ai_templates_4.png 1108w, https:\/\/lieben.nu\/liebensraum\/wp-content\/uploads\/2016\/09\/ai_templates_4-300x95.png 300w, https:\/\/lieben.nu\/liebensraum\/wp-content\/uploads\/2016\/09\/ai_templates_4-1024x324.png 1024w, https:\/\/lieben.nu\/liebensraum\/wp-content\/uploads\/2016\/09\/ai_templates_4-768x243.png 768w\" sizes=\"auto, (max-width: 1108px) 100vw, 1108px\" \/><\/a><\/p>\n<p>Now that our files and settings are configured, we&#8217;ll set the Build Parameter to <em>&#8220;Per machine if user is administrator, per user otherwise&#8221;<\/em>. This is the first requirement that will cause the registry keys to end up in the right location (HKCU):<\/p>\n<p><a href=\"https:\/\/www.lieben.nu\/liebensraum\/wp-content\/uploads\/2016\/09\/ai_templates_5.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-993\" src=\"https:\/\/www.lieben.nu\/liebensraum\/wp-content\/uploads\/2016\/09\/ai_templates_5.png\" alt=\"ai_templates_5\" width=\"1260\" height=\"467\" srcset=\"https:\/\/lieben.nu\/liebensraum\/wp-content\/uploads\/2016\/09\/ai_templates_5.png 1260w, https:\/\/lieben.nu\/liebensraum\/wp-content\/uploads\/2016\/09\/ai_templates_5-300x111.png 300w, https:\/\/lieben.nu\/liebensraum\/wp-content\/uploads\/2016\/09\/ai_templates_5-1024x380.png 1024w, https:\/\/lieben.nu\/liebensraum\/wp-content\/uploads\/2016\/09\/ai_templates_5-768x285.png 768w\" sizes=\"auto, (max-width: 1260px) 100vw, 1260px\" \/><\/a><\/p>\n<p>Now just press the build button in the top left and you&#8217;ll end up with a single, clean and working MSI file. Log in to the <a href=\"https:\/\/manage.microsoft.com\/microsoftIntune\/\">Intune console<\/a>, and go to the Apps section.<\/p>\n<p>Click Add Apps and load the on demand configuration tool:<\/p>\n<p><a href=\"https:\/\/www.lieben.nu\/liebensraum\/wp-content\/uploads\/2016\/09\/ai_templates_6.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1001\" src=\"https:\/\/www.lieben.nu\/liebensraum\/wp-content\/uploads\/2016\/09\/ai_templates_6.png\" alt=\"ai_templates_6\" width=\"415\" height=\"133\" srcset=\"https:\/\/lieben.nu\/liebensraum\/wp-content\/uploads\/2016\/09\/ai_templates_6.png 415w, https:\/\/lieben.nu\/liebensraum\/wp-content\/uploads\/2016\/09\/ai_templates_6-300x96.png 300w\" sizes=\"auto, (max-width: 415px) 100vw, 415px\" \/><\/a><\/p>\n<p>Ensure you have selected &#8220;Windows Installer through MDM&#8221;, the other methods won&#8217;t work.<\/p>\n<p><a href=\"https:\/\/www.lieben.nu\/liebensraum\/wp-content\/uploads\/2016\/09\/ai_templates_7.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1002\" src=\"https:\/\/www.lieben.nu\/liebensraum\/wp-content\/uploads\/2016\/09\/ai_templates_7.png\" alt=\"ai_templates_7\" width=\"947\" height=\"656\" srcset=\"https:\/\/lieben.nu\/liebensraum\/wp-content\/uploads\/2016\/09\/ai_templates_7.png 947w, https:\/\/lieben.nu\/liebensraum\/wp-content\/uploads\/2016\/09\/ai_templates_7-300x208.png 300w, https:\/\/lieben.nu\/liebensraum\/wp-content\/uploads\/2016\/09\/ai_templates_7-768x532.png 768w\" sizes=\"auto, (max-width: 947px) 100vw, 947px\" \/><\/a><\/p>\n<p>Accept all other default settings or configure as you please and press Upload.<\/p>\n<p>Once the upload completes, you&#8217;ll see the app in the Intune Console, but this won&#8217;t distribute the application yet, for that you&#8217;ll have to click &#8216;Manage Deployment&#8221; and configure a user based deployment:<\/p>\n<p><a href=\"https:\/\/www.lieben.nu\/liebensraum\/wp-content\/uploads\/2016\/09\/ai_templates_8.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1003\" src=\"https:\/\/www.lieben.nu\/liebensraum\/wp-content\/uploads\/2016\/09\/ai_templates_8.png\" alt=\"ai_templates_8\" width=\"1319\" height=\"263\" srcset=\"https:\/\/lieben.nu\/liebensraum\/wp-content\/uploads\/2016\/09\/ai_templates_8.png 1319w, https:\/\/lieben.nu\/liebensraum\/wp-content\/uploads\/2016\/09\/ai_templates_8-300x60.png 300w, https:\/\/lieben.nu\/liebensraum\/wp-content\/uploads\/2016\/09\/ai_templates_8-1024x204.png 1024w, https:\/\/lieben.nu\/liebensraum\/wp-content\/uploads\/2016\/09\/ai_templates_8-768x153.png 768w\" sizes=\"auto, (max-width: 1319px) 100vw, 1319px\" \/><\/a><\/p>\n<p><a href=\"https:\/\/www.lieben.nu\/liebensraum\/wp-content\/uploads\/2016\/09\/ai_templates_9.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1004\" src=\"https:\/\/www.lieben.nu\/liebensraum\/wp-content\/uploads\/2016\/09\/ai_templates_9.png\" alt=\"ai_templates_9\" width=\"1542\" height=\"330\" srcset=\"https:\/\/lieben.nu\/liebensraum\/wp-content\/uploads\/2016\/09\/ai_templates_9.png 1542w, https:\/\/lieben.nu\/liebensraum\/wp-content\/uploads\/2016\/09\/ai_templates_9-300x64.png 300w, https:\/\/lieben.nu\/liebensraum\/wp-content\/uploads\/2016\/09\/ai_templates_9-1024x219.png 1024w, https:\/\/lieben.nu\/liebensraum\/wp-content\/uploads\/2016\/09\/ai_templates_9-768x164.png 768w, https:\/\/lieben.nu\/liebensraum\/wp-content\/uploads\/2016\/09\/ai_templates_9-1536x329.png 1536w\" sizes=\"auto, (max-width: 1542px) 100vw, 1542px\" \/><\/a><a href=\"https:\/\/www.lieben.nu\/liebensraum\/wp-content\/uploads\/2016\/09\/ai_templates_10.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1005\" src=\"https:\/\/www.lieben.nu\/liebensraum\/wp-content\/uploads\/2016\/09\/ai_templates_10.png\" alt=\"ai_templates_10\" width=\"1334\" height=\"197\" srcset=\"https:\/\/lieben.nu\/liebensraum\/wp-content\/uploads\/2016\/09\/ai_templates_10.png 1334w, https:\/\/lieben.nu\/liebensraum\/wp-content\/uploads\/2016\/09\/ai_templates_10-300x44.png 300w, https:\/\/lieben.nu\/liebensraum\/wp-content\/uploads\/2016\/09\/ai_templates_10-1024x151.png 1024w, https:\/\/lieben.nu\/liebensraum\/wp-content\/uploads\/2016\/09\/ai_templates_10-768x113.png 768w\" sizes=\"auto, (max-width: 1334px) 100vw, 1334px\" \/><\/a><\/p>\n<p>And voila, within the hour your devices will have their templates deployed straight from Intune.<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Azure AD, Intune and Windows 10 offer an incredibly nice light management option, where your users can use any Windows 10 Pro or higher device and simply join it to your Azure AD on their own. Intune then allows you to enforce your security policies on those devices, and to distribute AppX and MSI packages &hellip; <a href=\"https:\/\/lieben.nu\/liebensraum\/2016\/09\/ems-case-distributing-office-templates-and-macros-to-your-users-on-windows-10-mobile-managed-azure-ad-joined-devices\/\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">EMS case: distributing Office templates and macro&#8217;s to your users on Windows 10 mobile managed Azure AD Joined devices<\/span> <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_crdt_document":"","footnotes":""},"categories":[22],"tags":[],"class_list":["post-988","post","type-post","status-publish","format-standard","hentry","category-intune"],"_links":{"self":[{"href":"https:\/\/lieben.nu\/liebensraum\/wp-json\/wp\/v2\/posts\/988","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/lieben.nu\/liebensraum\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/lieben.nu\/liebensraum\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/lieben.nu\/liebensraum\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/lieben.nu\/liebensraum\/wp-json\/wp\/v2\/comments?post=988"}],"version-history":[{"count":0,"href":"https:\/\/lieben.nu\/liebensraum\/wp-json\/wp\/v2\/posts\/988\/revisions"}],"wp:attachment":[{"href":"https:\/\/lieben.nu\/liebensraum\/wp-json\/wp\/v2\/media?parent=988"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/lieben.nu\/liebensraum\/wp-json\/wp\/v2\/categories?post=988"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/lieben.nu\/liebensraum\/wp-json\/wp\/v2\/tags?post=988"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}