Question

Downloadable Office 365 Install Worklet Help

  • 11 March 2022
  • 2 replies
  • 438 views

Userlevel 1
Badge

So here is the worklet I have been testing; I can get it to work in Windows but when I try deploying through AUTOMOX always an error. Any help would be appreciated. 

 

So the objective is to Install office 365 from a worklet. The current code over PS will install the latest version of office 365; but fails in AUTOMOX.

 

Remediation Code__________________________________________________________________

[CmdletBinding(DefaultParameterSetName = 'XMLFile')]
param(
  [Parameter(ParameterSetName = 'XMLFile')][String]$ConfigurationXMLFile,
  [Parameter(ParameterSetName = 'NoXML')][ValidateSet('TRUE', 'FALSE')]$AcceptEULA = 'TRUE',
  [Parameter(ParameterSetName = 'NoXML')][ValidateSet('Broad', 'Targeted', 'Monthly')]$Channel = 'Broad',
  [Parameter(ParameterSetName = 'NoXML')][Switch]$DisplayInstall = $False,
  [Parameter(ParameterSetName = 'NoXML')][ValidateSet('Groove', 'Outlook', 'OneNote', 'Access', 'OneDrive', 'Publisher', 'Word', 'Excel', 'PowerPoint', 'Teams', 'Lync')][Array]$ExcludeApps,
  [Parameter(ParameterSetName = 'NoXML')][ValidateSet('64', '32')]$OfficeArch = '64',
  [Parameter(ParameterSetName = 'NoXML')][ValidateSet('O365ProPlusRetail', 'O365BusinessRetail')]$OfficeEdition = 'O365ProPlusRetail',
  [Parameter(ParameterSetName = 'NoXML')][ValidateSet(0, 1)]$SharedComputerLicensing = '0',
  [Parameter(ParameterSetName = 'NoXML')][ValidateSet('TRUE', 'FALSE')]$EnableUpdates = 'TRUE',
  [Parameter(ParameterSetName = 'NoXML')][String]$LoggingPath,
  [Parameter(ParameterSetName = 'NoXML')][String]$SourcePath,
  [Parameter(ParameterSetName = 'NoXML')][ValidateSet('TRUE', 'FALSE')]$PinItemsToTaskbar = 'TRUE',
  [Parameter(ParameterSetName = 'NoXML')][Switch]$KeepMSI = $False,
  [String]$OfficeInstallDownloadPath = 'C:\Scripts\Office365Install',
  [Switch]$CleanUpInstallFiles = $False
)

function Set-XMLFile {

  if ($ExcludeApps) {
    $ExcludeApps | ForEach-Object {
      $ExcludeAppsString += "<ExcludeApp ID =`"$_`" />"
    }
  }

  if ($OfficeArch) {
    $OfficeArchString = "`"$OfficeArch`""
  }

  if ($KeepMSI) {
    $RemoveMSIString = $Null
  }
  else {
    $RemoveMSIString = '<RemoveMSI />'
  }

  if ($Channel) {
    $ChannelString = "Channel=`"$Channel`""
  }
  else {
    $ChannelString = $Null
  }

  if ($SourcePath) {
    $SourcePathString = "SourcePath=`"$SourcePath`"" 
  }
  else {
    $SourcePathString = $Null
  }

  if ($DisplayInstall) {
    $SilentInstallString = 'Full'
  }
  else {
    $SilentInstallString = 'None'
  }

  if ($LoggingPath) {
    $LoggingString = "<Logging Level=`"Standard`" Path=`"$LoggingPath`" />"
  }
  else {
    $LoggingString = $Null
  }

  $OfficeXML = [XML]@"
  <Configuration>
    <Add OfficeClientEdition=$OfficeArchString $ChannelString $SourcePathString  >
      <Product ID="$OfficeEdition">
        <Language ID="MatchOS" />
        $ExcludeAppsString
      </Product>
    </Add>  
    <Property Name="PinIconsToTaskbar" Value="$PinItemsToTaskbar" />
    <Property Name="SharedComputerLicensing" Value="$SharedComputerlicensing" />
    <Display Level="$SilentInstallString" AcceptEULA="$AcceptEULA" />
    <Updates Enabled="$EnableUpdates" />
    $RemoveMSIString
    $LoggingString
  </Configuration>
"@

  $OfficeXML.Save("$OfficeInstallDownloadPath\OfficeInstall.xml")
  
}
function Get-ODTURL {

  [String]$MSWebPage = Invoke-RestMethod 'https://www.microsoft.com/en-us/download/confirmation.aspx?id=49117'

  $MSWebPage | ForEach-Object {
    if ($_ -match 'url=(https://.*officedeploymenttool.*\.exe)') {
      $matches[1]
    }
  }

}

$VerbosePreference = 'Continue'
$ErrorActionPreference = 'Stop'

$CurrentPrincipal = New-Object Security.Principal.WindowsPrincipal([Security.Principal.WindowsIdentity]::GetCurrent())
if (!($CurrentPrincipal.IsInRole([Security.Principal.WindowsBuiltInRole]::Administrator))) {
#  Write-Warning 'Script is not running as Administrator'
  Write-Output "Script is not running as Administrator" >> C:\temp\Logs\office.txt
#  Write-Warning 'Please rerun this script as Administrator.'
  Write-Output "Please rerun this script as Administrator." >> C:\temp\Logs\office.txt
  exit
}

if (-Not(Test-Path $OfficeInstallDownloadPath )) {
  New-Item -Path $OfficeInstallDownloadPath -ItemType Directory | Out-Null
}

if (!($ConfigurationXMLFile)) {
  Set-XMLFile
}
else {
  if (!(Test-Path $ConfigurationXMLFile)) {
#    Write-Warning 'The configuration XML file is not a valid file'
    Write-Output "The configuration XML file is not a valid file" >> C:\temp\Logs\office.txt
#    Write-Warning 'Please check the path and try again'
    Write-Output "Please check the path and try again" >> C:\temp\Logs\office.txt
    exit
  }
}

$ConfigurationXMLFile = "$OfficeInstallDownloadPath\OfficeInstall.xml"
$ODTInstallLink = Get-ODTURL

#Download the Office Deployment Tool
# Write-Verbose 'Downloading the Office Deployment Tool...'
Write-Output "Downloading the Office Deployment Tool..." >> C:\temp\Logs\office.txt
try {
  Invoke-WebRequest -Uri $ODTInstallLink -OutFile "$OfficeInstallDownloadPath\ODTSetup.exe"
}
catch {
#  Write-Warning 'There was an error downloading the Office Deployment Tool.'
  Write-Output "There was an error downloading the Office Deployment Tool." >> C:\temp\Logs\office.txt
#  Write-Warning 'Please verify the below link is valid:'
  Write-Output "Please verify the below link is valid:" >> C:\temp\Logs\office.txt
  Write-Warning $ODTInstallLink
  Write-Output $ODTInstallLink >> C:\temp\Logs\office.txt
    exit
}

#Run the Office Deployment Tool setup
try {
#  Write-Verbose 'Running the Office Deployment Tool...'
  Write-Output "Running the Office Deployment Tool..." >> C:\temp\Logs\office.txt
  Start-Process "$OfficeInstallDownloadPath\ODTSetup.exe" -ArgumentList "/quiet /extract:$OfficeInstallDownloadPath" -Wait
}
catch {
#  Write-Warning 'Error running the Office Deployment Tool. The error is below:'
Write-Output "Error running the Office Deployment Tool. The error is below:" >> C:\temp\Logs\office.txt
  Write-Warning $_
  Write-Output $_ >> C:\temp\Logs\office.txt
}

#Run the O365 install
try {
#  Write-Verbose 'Downloading and installing Microsoft 365'
  Write-Output "Downloading and installing Microsoft 365" >> C:\temp\Logs\office.txt
  $Silent = Start-Process "$OfficeInstallDownloadPath\Setup.exe" -ArgumentList "/configure $ConfigurationXMLFile" -Wait -PassThru
}
catch {
#  Write-Warning 'Error running the Office install. The error is below:'
  Write-Output "Error running the Office install. The error is below:" >> C:\temp\Logs\office.txt
  Write-Warning $_
  Write-Output $_ >> C:\temp\Logs\office.txt
}

#Check if Office 365 suite was installed correctly.
$RegLocations = @('HKLM:\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall',
  'HKLM:\SOFTWARE\WOW6432Node\Microsoft\Windows\CurrentVersion\Uninstall'
)

$OfficeInstalled = $False
foreach ($Key in (Get-ChildItem $RegLocations) ) {
  if ($Key.GetValue('DisplayName') -like '*Microsoft 365*') {
    $OfficeVersionInstalled = $Key.GetValue('DisplayName')
    $OfficeInstalled = $True
  }
}

if ($OfficeInstalled) {
#  Write-Verbose "$($OfficeVersionInstalled) installed successfully!"
  Write-Output "$($OfficeVersionInstalled) installed successfully!" >> C:\temp\Logs\office.txt
}
else {
#  Write-Warning 'Microsoft 365 was not detected after the install ran'
  Write-Output "Microsoft 365 was not detected after the install ran" >> C:\temp\Logs\office.txt
}

if ($CleanUpInstallFiles) {
  Remove-Item -Path $OfficeInstallDownloadPath -Force -Recurse
}


2 replies

Userlevel 1
Badge

I found a work around; I know the script works, the one work around is to compile the script into a executable, and install it as a software and not as a script.

Userlevel 1
Badge

Looks like I found another part of the issue; since my environment; the policy isnt defined; it would need to be defined; prior to running the script.

Set-ExecutionPolicy -ExecutionPolicy RemoteSigned

Reply