How to get MSI file information with PowerShell

How to get MSI file information with PowerShell

If you’re an ConfigMgr administrator like me, you will often find yourself in the situation where you may want to get the Product Code from a MSI file. Or perhaps you’re interested in the Product Version or simply just the Product Name. A while back I wrote a simple PowerShell script that can assist with just that, for some reason I forgot to post about it so here goes. As this is going to be a short post, I’ll not go much into detail on how it works, instead I’ll just give you the script.

Script

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

param( [parameter(Mandatory=$true)] [IO.FileInfo]$Path, [parameter(Mandatory=$true)] [ValidateSet("ProductCode","ProductVersion","ProductName")] [string]$Property ) try {     $WindowsInstaller = New-Object -ComObject WindowsInstaller.Installer     $MSIDatabase = $WindowsInstaller.GetType().InvokeMember("OpenDatabase","InvokeMethod",$Null,$WindowsInstaller,@($Path.FullName,0))     $Query = "SELECT Value FROM Property WHERE Property = '$($Property)'"     $View = $MSIDatabase.GetType().InvokeMember("OpenView","InvokeMethod",$null,$MSIDatabase,($Query))     $View.GetType().InvokeMember("Execute", "InvokeMethod", $null, $View, $null)     $Record = $View.GetType().InvokeMember("Fetch","InvokeMethod",$null,$View,$null)     $Value = $Record.GetType().InvokeMember("StringData","GetProperty",$null,$Record,1)     return $Value } catch {     Write-Output $_.Exception.Message }

Save the above script as Get-MSIFileInformation.ps1 to C:\Scripts.

1. Open a PowerShell console and browse to C:\Scripts.
2. Run the following command:

1	.\Get-MSIFileInformation.ps1 -Path "D:\Source$\Apps\7-zip\7z920-x64.msi" -Property ProductCode

Note! You should specify a valid path to a MSI file in your environment.

I hope this helps!

Original post:

http://www.scconfigmgr.com/2014/08/22/how-to-get-msi-file-information-with-powershell/