Trying to update Office to acertain version

Rick Someone 411

I'm using PS to generally say, this is my current version. What version do I have, and run the PS to upgrade Office until I get to that current version.

I was using variables

$UpdateToVersion="16.0.13127.xxxx"

$updateEXE="C:\path to OfficeC2Run.exe"

$Update arguments="/update user displaylevel=true"

$version=Get-WmiObject win32_product | where{$_.Name -like "Microsoft Office 365"} | Select-Object -ExpandProperty Version

while($version -lt $UpdateToVersion){

Start-Process $UpdateEXE $UpdateArguments

I've been reading that querying the win32_product is not the proper way to get a version. It completely locks up the pc.

sj 0 Reputation points

2023-05-18T19:22:03.6533333+00:00

for version you can try
(Get-ItemProperty -Path HKLM:\SOFTWARE\Microsoft\Office\ClickToRun\Configuration).VersionToReport

sj 0

i use a function/module for version so i can send objects in and out of it.

[cmdletBinding()]

param(
    [Parameter(Mandatory = $True,
        ValuefromPipeline = $True,
        ValuefromPipelineByPropertyName = $True)]
    [validateNotNullorEmpty()]
    [string[]]$ComputerName,
    [Parameter()]
    [ValidateNotNullOrEmpty()]
    [pscredential]$Credential
)

BEGIN {}

PROCESS{

    foreach ($computer in $ComputerName) {
    try {
        $connParams = @{'ComputerName' = $computer }
        if ($PSBoundParameters.ContainsKey('Credential')) {
            $connParams.Credential = $Credential
        }

        $psRemotingSession = New-PSSession @connParams

        $reg = Invoke-Command -Session $psRemotingSession  {Get-ItemProperty -Path HKLM:\SOFTWARE\Microsoft\Office\ClickToRun\Configuration | select-object VersionToReport,InstallID,CDNBaseUrl,UpdateChannel,UpdateDeadline,pscomputerName}

            $output = foreach ( $r in $reg ) {
            if ($reg.CDNBaseUrl -like '*55336b82-a18d-4dd6-b5f6-9e5095c314a6') {Write-Output 'Monthly Enterprise Channel' }
            if ($reg.CDNBaseUrl -like '*64256afe-f5d9-4f86-8936-8840a6a4f5be') {Write-Output 'Current Channel (Preview)' }
            if ($reg.CDNBaseUrl -like '*492350f6-3a01-4f97-b9c0-c7c6ddf67d60') {Write-Output 'Current Channel' }
            if ($reg.CDNBaseUrl -like '*7ffbc6bf-bc32-4f92-8982-f9dd17fd3114') {Write-Output 'Semi-Annual Enterprise Channel' }
            if ($reg.CDNBaseUrl -like '*b8f9b850-328d-4355-9145-c59439a0c4cf') {Write-Output 'Semi-Annual Enterprise Channel (Preview)' }
            if ($reg.CDNBaseUrl -like '*5440fd1f-7ecb-4221-8110-145efaa6372f') {Write-Output 'Beta Channel' }
            }

            $props = [ordered]@{'ComputerName' = $reg.pscomputerName;
                'O365Channel' = $reg.UpdateChannel;
                'BaseURL' = $reg.CDNBaseUrl;
                'InstallID' = $reg.InstallID;
                'O365Version' = $reg.VersionToReport;
                'Channel' = $output}

            $obj = New-Object -TypeName PSObject -Property $props
            Write-Output $obj


        } catch {$_|out-null}

        Get-PSSession | Remove-PSSession

    } # end foreach
}

END {}

6 answers

sj 0 Reputation points

2023-05-18T19:34:28.9366667+00:00

the output looks like this

ComputerName :

O365Channel :

BaseURL :

InstallID :

O365Version : 16.0.11328.20368

Channel : Semi-Annual Enterprise Channel

...i deleted values that appear to be null. you could use either that created as a function or the oneliner to determine the version if you think it may work for you.

(Get-ItemProperty -Path HKLM:\SOFTWARE\Microsoft\Office\ClickToRun\Configuration).VersionToReport

cheers ;-)
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Trying to update Office to acertain version

Start-Process $UpdateEXE $UpdateArguments

6 answers

Your answer