-
Notifications
You must be signed in to change notification settings - Fork 0
/
Update_Office.ps1
34 lines (27 loc) · 1.15 KB
/
Update_Office.ps1
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
<#
.Description
Using a Tenable CSV export, update remote machines using the "Click to Run" version of Office.
.Notes
This enters a PS Session, admin credentials may be required.
#>
$Date = Get-Date -UFormat "%Y%m%d"
Start-Transcript -Path logs\$Date-Office_Update.txt -Append
# Pull list of names from a docuemnt
$Collection = Import-Csv .\Tenable.csv
# Option to use an admin account
$sesh = Get-Credential
Foreach ($item in $Collection.'asset.name') {
# test to see if computer in list is online
$online = Test-Connection $item -quiet -count 2
if ($online) {
# Open a remote session on the named computer and run the update.
Invoke-Command -ComputerName $item -Credential $sesh -scriptblock {
& 'C:\Program Files\Common Files\microsoft shared\ClickToRun\OfficeC2RClient.exe' /changesetting Channel=Current;
& 'C:\Program Files\Common Files\microsoft shared\ClickToRun\OfficeC2RClient.exe' /update user
}
Resolve-DnsName $item | Select-Object -ExpandProperty IPaddress | Out-File -FilePath .\$date_Office_rescan.txt -Append
} else {
Write-Warning "$item is not reachable."
}
}
Stop-Transcript