Get MSITable
Selects records from a table or custom query from a product or patch package.
Get-MSITable [-Path] <String[]> [[-Table] <String>] [-Patch <String[]>] [-Transform <String[]>]
[<CommonParameters>]
Get-MSITable [-Path] <String[]> -Query <String> [-Patch <String[]>] [-Transform <String[]>]
[<CommonParameters>]
Get-MSITable -LiteralPath <String[]> [[-Table] <String>] [-Patch <String[]>] [-Transform <String[]>]
[<CommonParameters>]
Get-MSITable -LiteralPath <String[]> -Query <String> [-Patch <String[]>] [-Transform <String[]>]
[<CommonParameters>]
Get-MSITable [-Product] <ProductInstallation[]> [[-Table] <String>] [-IgnoreMachineState] [<CommonParameters>]
Get-MSITable [-Product] <ProductInstallation[]> -Query <String> [-IgnoreMachineState] [<CommonParameters>]
You can query all records from a table or records matching a custom query from a product or patch package. The Windows Installer SDK has more information about custom queries, since the SQL-like syntax is rather constrained.
When no table or query is provided all tables from the package are displayed. Specifying a patch or transform will cause tables added by the patch or transform to be displayed, along with the operation performed on that table by the patch or transform in the MSIOperation property.
Records are returned with properties matching column names. If records are selected from a single table, the table name is also part of the type name queryable from the PSTypeNames object property. If the column name is prefixed with the table name - required to disambiguate names, or optional otherwise - a property is returned as typed in the original query string. Note that Windows PowerShell allows periods in property names but may require in some scenarios that a property name with periods is contained in quotes, like 'File.Attributes'.
For attribute columns in standard Windows Installer tables, you may also query for specific attribute values by specifying a special property name on the end of the attribute column name, like 'File.Attributes'.HasVital, to query for any columns that have the attribute value set. You can define an $MsiAttributeColumnFormat variable to control the display format of attribute columns, though the underlying value will not be changed. Run 'help about_MSI' for more information.
Note that patch packages do not typically have more than a couple of tables. The patch has to be applied to a product package to view any changes it has made. When applying a patch or transforms, records will contain an operation performed on the record by the patch or transform in the MSIOperation property.
get-msitable .\example.msi -table Property
Gets all records from the Property table.
$productCode = get-msitable .\example.msi -table Property | where-object { $_.Property -eq "ProductCode" } | select-object -expand Value
Selects just the ProductCode property from the example.msi package and assigns the value to a variable.
get-childitem -filter *.msi | get-msitable -query "SELECT ComponentId, FileName, FileSize FROM Component, File WHERE Component_ = Component"
Selects the component GUID, file name, and file size for all files in all packages in the current directory.
get-msitable .\example.msi -query "SELECT ComponentId, FileName, File.Attributes FROM Component, File WHERE Component_ = Component" | where-object { $_.'File.Attributes'.HasVital }
Selects all vital files and displays the component GUID, file name, and all file attribtes from the example.msi package.
Note that in the query filter the 'File.Attributes' column is contained in quotes; otherwise, Windows PowerShell will attempt to filter based on an Attributes property of a File property of the current pipeline object. The 'File.Attributes' column is contained in quotes in the original query because the Component table also contains a column named Attributes. Windows Installer requires that you disambiguate column names.
get-msitable .\example.msi -patch .\example.msp | get-msitable | where-object { $_.MSIOperation -ne 'None' }
Gets all records in the example.msi package added or modified by the example.msp patch package.
get-msiproductinfo '{877EF582-78AF-4D84-888B-167FDC3BCC11}' | get-msitable -table Property
Selects records from the installed product along with any patches currently installed.
Whether to apply any patches current installed to the product.
Type: SwitchParameter
Parameter Sets: Installation,Table, Installation,Query
Aliases:
Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: FalseThe path to a product package to open. The value of -LiteralPath is used exactly as typed. No characters are interpreted as wildcards.
Type: String[]
Parameter Sets: LiteralPath,Table, LiteralPath,Query
Aliases: PSPath
Required: True
Position: Named
Default value: None
Accept pipeline input: True (ByPropertyName)
Accept wildcard characters: FalseThe path to a patch package to apply to the product package. Multiple patches are applied in authored sequence order.
Wildcards are permitted. You can specify * in any part of the path to select all matching files.
Type: String[]
Parameter Sets: Path,Table, Path,Query, LiteralPath,Table, LiteralPath,Query
Aliases:
Required: False
Position: Named
Default value: None
Accept pipeline input: True (ByPropertyName)
Accept wildcard characters: TrueThe path to a product package to open. Wildcards are permitted. You can specify * in any part of the path to select all matching files.
Type: String[]
Parameter Sets: Path,Table, Path,Query
Aliases:
Required: True
Position: 1
Default value: None
Accept pipeline input: True (ByPropertyName, ByValue)
Accept wildcard characters: TrueAn installed product to query.
Type: ProductInstallation[]
Parameter Sets: Installation,Table, Installation,Query
Aliases:
Required: True
Position: 1
Default value: None
Accept pipeline input: True (ByValue)
Accept wildcard characters: FalseA custom query for which records are selected. Ambiguous column names must be prefixed with the table name to which they belong.
Type: String
Parameter Sets: Path,Query, LiteralPath,Query, Installation,Query
Aliases:
Required: True
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: FalseThe table from which all records are selected. If no table name is provided all tables in the database are displayed.
Type: String
Parameter Sets: Path,Table, LiteralPath,Table, Installation,Table
Aliases:
Required: False
Position: 0
Default value: None
Accept pipeline input: True (ByPropertyName)
Accept wildcard characters: FalseThe path to a transform to apply to the product package.
Wildcards are permitted. You can specify * in any part of the path to select all matching files.
Type: String[]
Parameter Sets: Path,Table, Path,Query, LiteralPath,Table, LiteralPath,Query
Aliases:
Required: False
Position: Named
Default value: None
Accept pipeline input: True (ByPropertyName)
Accept wildcard characters: TrueThis cmdlet supports the common parameters: -Debug, -ErrorAction, -ErrorVariable, -InformationAction, -InformationVariable, -OutVariable, -OutBuffer, -PipelineVariable, -Verbose, -WarningAction, and -WarningVariable. For more information, see about_CommonParameters (http://go.microsoft.com/fwlink/?LinkID=113216).
Copyright (C) Microsoft Corporation. All rights reserved. Licensed under the MIT license. See LICENSE.txt in the project root for license information.
Commands
- Add-MSISource
- Clear-MSISource
- Edit-MSIPackage
- Export-MSIPatchXml
- Get-MSIComponentInfo
- Get-MSIComponentState
- Get-MSIFeatureInfo
- Get-MSIFileHash
- Get-MSIFileType
- Get-MSILoggingPolicy
- Get-MSIPatchInfo
- Get-MSIPatchSequence
- Get-MSIProductInfo
- Get-MSIProperty
- Get-MSIRelatedProductInfo
- Get-MSISharedComponentInfo
- Get-MSISource
- Get-MSISummaryInfo
- Get-MSITable
- Install-MSIAdvertisedFeature
- Install-MSIPatch
- Install-MSIProduct
- Measure-MSIProduct
- Remove-MSILoggingPolicy
- Remove-MSISource
- Repair-MSIProduct
- Set-MSILoggingPolicy
- Test-MSIProduct
- Uninstall-MSIPatch
- Uninstall-MSIProduct
Examples