Powershell script to install multiple msi on remote machines

Question

Good day, I would ask you to help me with finding the solution how to copy each MSI package to remote machine using link on nas storage.

# Get list of servers
param(
  [ValidateSet('STUDENT_LAB', 'LIBRARY_LAB', 'TEACHER_LAB')]
  [Parameter(Mandatory = $true, 
    HelpMessage = 'Select one of the valid servers by typing one of these names: STUDENT_LAB, LIBRARY_LAB, TEACHER_LAB')]
  [string]$ServerGroup
)
$servers = @{
  STUDENT_LAB      = ('192.168.1.1','192.168.1.2','192.168.1.3')
  LIBRARY_LAB      = ('192.168.10.1','192.168.10.2','192.168.10.3')
  TEACHER_LAB = ('192.168.15.1','192.168.15.2','192.168.15.3')
}[$ServerGroup]
Write-Output "The user chose $ServerGroup"

#this is what I don't know how to implement - download file from nas storage on remote machine

$sourcefiles = '\\NASSTORAGE\MSI\MICROSOFT\Microsoft-ODBCDriver-11-SQLServer-x64\msodbcsql.msi' ; '\\NASSTORAGE\MSI\MICROSOFT\Microsoft-ODBCDriver-17-SQLServr-x64\msodbcsql_17.2.0.1_x64.msi'; '\\NASSTORAGE\MSI\MICROSOFT\Microsoft-OLEDBDriver-SQL Server-x64\msoledbsql_18.1.0.0_x64.msi'

foreach($server in $servers) {
    
  # Destination UNC path changes based on server name 

  $destinationPath = "\\$server\D$\tmp\"

  # Check that full folder structure exists and create if it doesn't

  if(!(Test-Path $destinationPath)) {
    New-Item -ItemType Directory -Force -Path $destinationPath
  }
  # Copy the file across
  Copy-Item $sourcefiles $destinationPath
#list of packages to install  
  $msiList = @(
            'Microsoft-ODBCDriver-11-SQLServer-x64\msodbcsql.msi'
            'Microsoft-ODBCDriver-17-SQLServr-x64\msodbcsql_17.2.0.1_x64.msi'
            'Microsoft-OLEDBDriver-SQL Server-x64\msoledbsql_18.1.0.0_x64.msi'

        )
#now I'm trying to install on remote machine
        foreach ($msi in $msiList) {
            $install = Join-Path -Path $destinationPath -ChildPath $msi
            Start-Process "msiexec.exe" -ArgumentList "/I $install",'/qn' -Wait
            
        }
}

And is there any way how to check if the msi was installed properly?

Thank you for your time.

Answer 1

you can add this at the installation section :

$LaunchMsi = Start-Process "msiexec.exe" -ArgumentList "/I $install",'/qn' -Wait -PassThru
$ReturnCode = $LaunchMsi.ExitCode

if (($ReturnCode -eq "0") -OR ($ReturnCode -eq "3010")) {Write-Host "installation OK, return code : $ReturnCode"}
Else {Write-host "installation KO, return code : $ReturnCode"}