DSCResources/ROACommon/Src/Get-WindowsInstallerPackageProperty.ps1
|
function Get-WindowsInstallerPackageProperty { <# .SYNOPSIS This cmdlet retrieves product name from a Windows Installer MSI database. .DESCRIPTION This function uses the WindowInstaller COM object to pull all values from the Property table from a MSI package. .NOTES Adapted from http://www.scconfigmgr.com/2014/08/22/how-to-get-msi-file-information-with-powershell/ #> [CmdletBinding()] [OutputType([System.String])] param ( [Parameter(Mandatory, Position = 0, ValueFromPipeline, ValueFromPipelineByPropertyName, ParameterSetName = 'Path')] [ValidateNotNullOrEmpty()] [Alias('PSPath','FullName')] [System.String] $Path, [Parameter(Mandatory, Position = 0, ValueFromPipelineByPropertyName, ParameterSetName = 'LiteralPath')] [ValidateNotNullOrEmpty()] [System.String] $LiteralPath, [Parameter(Position = 1, ValueFromPipelineByPropertyName)] [ValidateSet('ProductCode', 'ProductVersion', 'ProductName', 'UpgradeCode')] [System.String] $Property = 'ProductCode' ) begin { if ($PSCmdlet.ParameterSetName -eq 'Path') { $LiteralPath += $ExecutionContext.SessionState.Path.GetUnresolvedProviderPathFromPSPath($Path); } } #end begin process { $windowsInstaller = New-Object -ComObject WindowsInstaller.Installer; Write-Verbose -Message ($localizedData.OpeningMSIDatabase -f $LiteralPath); try { $msiDatabase = $windowsInstaller.GetType().InvokeMember('OpenDatabase', 'InvokeMethod', $null, $windowsInstaller, @("$LiteralPath", 0)); $query = "SELECT Value FROM Property WHERE Property = '{0}'" -f $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 { throw; } } #end process } #end function Get-WindowsInstallerPackageProperty |