Microsoft Office 365 Release Channels

JT.Phillips

September 22, 2023 at 8:55 pm UTC

#reporting#patches

Hello,

I noticed in our Automox environment that we have a lot of client devices reporting they still need to update Microsoft Office 365 to latest version. However, we use the Semi-Annual Enterprise release channel and Automox is showing the Office version for the Current Release channel. Is there a setting or configuration I can change to make the Automox agent use a different release channel?

https://learn.microsoft.com/en-us/officeupdates/update-history-microsoft365-apps-by-date

This discussion is archived and closed to replies. Continue it in the Automox Community Slack.

Discuss on Slack

Replies (1)

JT.PhillipsOctober 16, 2023

I worked with an Automox Support Agent and came up with this as a work around. Thought I would share incase any other users are having the same issue.

Evaluation Code

powershell83 lines

<#
.SYNOPSIS
    Sets the Office Release Channel to the desired Channel. 
    OS Support: Windows 10  and above
    Required modules: NONE
.DESCRIPTION
    This worklet will set the Office Update Channel and the CDNBaseURL to the one specified by the admin.
    By setting the correct CDNBaseURL, this will configure the Automox Agent to pull patches from the correct office release channel. 

    ---------------------------------------Office Release Channels-------------------------------------------------------------------

    Current: Provides users with new Office features as soon as they are ready, but on no set schedule.
    FirstReleaseCurrent: Preview release of Current channel.
    MonthlyEnterprise: Provides users with new Office features only once a month and on a predictable schedule.
    Deferred: For select devices in your organization, where extensive testing is needed before deploying new Office features.
    FirstReleaseDeferred: Preview release of Deferred channel.
    InsiderFast: Beta release channel. Frequent updates. Stable builds are sent to FirstReleaseChannel.

    ---------------------------------------------------------------------------------------------------------------------------------

    $Channel is the software update channel you would like Office to update from
.EXAMPLE
    $Channel = "Current"
.NOTES
    Author: John Phillips
    Date: September 29th, 2023

    This script is a fork of the "Configure Office Update Channel" Worklet Created by:
    Author: Ben Rillie
    Date: May 13, 2021 
#>

########--Set Your Release Channel Below--###############
$ReleaseChannel = "Deferred"
#########################################################

#Registry Items
$OfficeUpdateBranch = "HKLM:\SOFTWARE\Policies\Microsoft\office\16.0\Common\officeupdate"
$OfficeUpdateURL = "HKLM:\SOFTWARE\Microsoft\Office\ClickToRun\Configuration"

$scriptBlock = {

    param($RC, $REGKEY)

    $CDNBaseURL = "" 
    switch ($RC)
    {
        "Current"              {$CDNBaseURL = "http://officecdn.microsoft.com/pr/492350f6-3a01-4f97-b9c0-c7c6ddf67d60"; Break}
        "FirstReleaseCurrent"  {$CDNBaseURL = "http://officecdn.microsoft.com/pr/64256afe-f5d9-4f86-8936-8840a6a4f5be"; Break}
        "MonthlyEnterprise"    {$CDNBaseURL = "http://officecdn.microsoft.com/pr/55336b82-a18d-4dd6-b5f6-9e5095c314a6"; Break}
        "Deferred"             {$CDNBaseURL = "http://officecdn.microsoft.com/pr/7ffbc6bf-bc32-4f92-8982-f9dd17fd3114"; Break}
        "FirstReleaseDeferred" {$CDNBaseURL = "http://officecdn.microsoft.com/pr/b8f9b850-328d-4355-9145-c59439a0c4cf"; Break}
        "InsiderFast"          {$CDNBaseURL = "http://officecdn.microsoft.com/pr/5440fd1f-7ecb-4221-8110-145efaa6372f"; Break}
        Default 
        {
            Write-Output "STOPPING WORKLET: $RC is an invalid Office channel - **No Changes Made!**"
            return 1
        }
    }

    if((Get-ItemProperty -Path $REGKEY -Name CDNBaseUrl -ErrorAction SilentlyContinue).CDNBaseUrl -eq $CDNBaseURL)
    {
        return 0
    }
    else
    {
        return 1
    }
}

$OfficeUpdateURLResult = & "$env:SystemRoot\sysnative\WindowsPowerShell\v1.0\powershell.exe" -ExecutionPolicy Bypass `
                       -WindowStyle Hidden -NoProfile -NonInteractive -Command $scriptBlock -args $ReleaseChannel,$OfficeUpdateURL 

if((Get-ItemProperty -Path $OfficeUpdateBranch -Name updatebranch -ErrorAction SilentlyContinue).updatebranch -eq $ReleaseChannel -and
    $OfficeUpdateURLResult -eq 0)
{
    Write-Output "Office Update Branch and CDN-BASE-URL are correct. - **No Changes Made!**"
    exit 0
}
else
{
    exit 1
}

Remediation Code

powershell103 lines

<#
.SYNOPSIS
    Sets the Office Release Channel to the desired Channel.
    OS Support: Windows 10  and above
    Required modules: NONE
.DESCRIPTION
    This worklet will set the Office Update Channel and the CDNBaseURL to the one specified by the admin.
    By setting the correct CDNBaseURL, this will configure the Automox Agent to pull patches from the correct office release channel.
    ---------------------------------------Office Release Channels-------------------------------------------------------------------
    Current: Provides users with new Office features as soon as they are ready, but on no set schedule.
    FirstReleaseCurrent: Preview release of Current channel.
    MonthlyEnterprise: Provides users with new Office features only once a month and on a predictable schedule.
    Deferred: For select devices in your organization, where extensive testing is needed before deploying new Office features.
    FirstReleaseDeferred: Preview release of Deferred channel.
    InsiderFast: Beta release channel. Frequent updates. Stable builds are sent to FirstReleaseChannel.    
    ---------------------------------------------------------------------------------------------------------------------------------
    $Channel is the software update channel you would like Office to update from
.EXAMPLE
    $Channel = "Current"
.NOTES
    Author: John Phillips
    Date: September 29th, 2023

    This script is a fork of the "Configure Office Update Channel" Worklet Created by:
    Author: Ben Rillie
    Date: May 13, 2021 
#>

########--Set Your Release Channel Below--###############
$ReleaseChannel = "Deferred"
#########################################################

#Registry Items
$OfficeUpdateBranch = "HKLM:\SOFTWARE\Policies\Microsoft\office\16.0\Common\officeupdate"
$OfficeUpdateURL = "HKLM:\SOFTWARE\Microsoft\Office\ClickToRun\Configuration"

$scriptBlock = {

    param($RC, $REGKEY)

    $CDNBaseURL = "" 
    switch ($RC)
    {
        "Current"              {$CDNBaseURL = "http://officecdn.microsoft.com/pr/492350f6-3a01-4f97-b9c0-c7c6ddf67d60"; Break}
        "FirstReleaseCurrent"  {$CDNBaseURL = "http://officecdn.microsoft.com/pr/64256afe-f5d9-4f86-8936-8840a6a4f5be"; Break}
        "MonthlyEnterprise"    {$CDNBaseURL = "http://officecdn.microsoft.com/pr/55336b82-a18d-4dd6-b5f6-9e5095c314a6"; Break}
        "Deferred"             {$CDNBaseURL = "http://officecdn.microsoft.com/pr/7ffbc6bf-bc32-4f92-8982-f9dd17fd3114"; Break}
        "FirstReleaseDeferred" {$CDNBaseURL = "http://officecdn.microsoft.com/pr/b8f9b850-328d-4355-9145-c59439a0c4cf"; Break}
        "InsiderFast"          {$CDNBaseURL = "http://officecdn.microsoft.com/pr/5440fd1f-7ecb-4221-8110-145efaa6372f"; Break}
        Default 
        {
            Write-Output "STOPPING WORKLET: $RC is an invalid Office channel - **No Changes Made!**"
            return 1
        }
    }

    if(!(Test-Path $REGKEY))
    {
        $Results = "Registry Key Path Created: $REGKEY"
        New-Item -Path $REGKEY -Force | Out-Null
    }

    if((Get-ItemProperty -Path $REGKEY -Name CDNBaseUrl -ErrorAction SilentlyContinue).CDNBaseUrl -eq $CDNBaseURL)
    {
        $Results = "Office CDN-BASE-URL is already set to $CDNBaseURL. - **No Changes Made!**"
    }
    else
    {
        $Results = "Office CDN-BASE-URL set to: $CDNBaseURL"
        Set-ItemProperty -Path $REGKEY -Name CDNBaseUrl -Value $CDNBaseURL -Force | Out-Null
    }

    return $Results
}

$OfficeUpdateURLResult = & "$env:SystemRoot\sysnative\WindowsPowerShell\v1.0\powershell.exe" -ExecutionPolicy Bypass `
                       -WindowStyle Hidden -NoProfile -NonInteractive -Command $scriptBlock -args $ReleaseChannel,$OfficeUpdateURL 

if($OfficeUpdateURLResult -eq 1)
{
    Write-Output $OfficeUpdateURLResult
    exit 1
}
else
{
    Write-Output $OfficeUpdateURLResult
}

if(!(Test-Path $OfficeUpdateBranch))
{
    Write-Output "Registry Key Path Created: $OfficeUpdateBranch"
    New-Item -Path $OfficeUpdateBranch -Force | Out-Null
}

if((Get-ItemProperty -Path $OfficeUpdateBranch -Name updatebranch -ErrorAction SilentlyContinue).updatebranch -eq $ReleaseChannel)
{
    Write-Output "Office Release Channel Policy is already set to $ReleaseChannel. - **No Changes Made!**"  
}
else
{
    Write-Output "Office Release Channel Policy set to: $ReleaseChannel"
    Set-ItemProperty -Path $OfficeUpdateBranch -Name updatebranch -Value $ReleaseChannel -Force | Out-Null
}

Thanks,
John Phillips

Back to all discussions