{"id":65,"date":"2012-11-22T03:06:00","date_gmt":"2012-11-22T01:06:00","guid":{"rendered":"http:\/\/workplace.skyworker.de\/?p=65"},"modified":"2023-08-22T10:39:23","modified_gmt":"2023-08-22T08:39:23","slug":"tool-zum-auslesen-von-msi-informationen","status":"publish","type":"post","link":"http:\/\/workplace.skyworker.de\/?p=65","title":{"rendered":"Powershell: Tool zum auslesen von MSI Informationen"},"content":{"rendered":"
\r\n
\r\n \r\n <\/i>\r\n <\/a>\r\n 0 <\/span>\r\n<\/div>
\r\n \r\n <\/i>\r\n <\/a>\r\n 0<\/span>\r\n<\/div><\/div>
\n

Oft schon stand ich vor dem Problem, das ich gerne die MSI-GUID, MSI-InstallerID und die Version einer neuen MSI Datei auslesen wollte, ohne gleich den Empirum Packaging Wizard zur Hand zu nehmen. Zum Beispiel bei Empirum Paketen, die aus mehreren MSI Dateien bestehen, oder nur um eine neuere Versionen einer Applikation, die \u00fcber einen MSI Installer installiert wird einbinden zu wollen.<\/p>\n

<\/p>\n<\/div>\n

Hierf\u00fcr habe ich mir ein PowerShell Skript geschrieben, welches die relevanten Daten f\u00fcr mich direkt aus einer MSI Datei ausliest.<\/p>\n

\"mx42_getmsiinfo\"<\/a><\/p>\n

Das PowerShell Skript aufrufen, die MSI Datei ausw\u00e4hlen und schon werden die entsprechenden Daten angezeigt.<\/p>\n

Powershell Skript:\u00a0\u00a0 [ddownload id=174]<\/p>\n

Hinweis:<\/strong> Um das PowerShell Skript ausf\u00fchren zu k\u00f6nnen, muss die PowerShell ExecutionPolicy<\/strong> herabgesetzt werden. Hierzu ein PowerShell Fenster \u00f6ffnen und den Befehl set-executionpolicy remotesigned eingeben und mit J \u2013 Ja, oder Y \u2013 Yes best\u00e4tigen.
\nDanach kann das Skript \u00fcber die rechte Maustaste > Mit PowerShell ausf\u00fchren gestartet werden.<\/p><\/blockquote>\n

[php]function Get-MsiVersion {
\nparam (
\n[IO.FileInfo] $FilePath
\n)<\/p>\n

try {
\n$windowsInstaller = New-Object -com WindowsInstaller.Installer<\/p>\n

$database = $windowsInstaller.GetType().InvokeMember(
\n\u201cOpenDatabase\u201d, \u201cInvokeMethod\u201d, $Null,
\n$windowsInstaller, @($FilePath.FullName, 0)
\n)<\/p>\n

$q = "SELECT Value FROM Property WHERE Property = ‚ProductVersion’"
\n$View = $database.GetType().InvokeMember(
\n\u201cOpenView\u201d, \u201cInvokeMethod\u201d, $Null, $database, ($q)
\n)<\/p>\n

$View.GetType().InvokeMember(\u201cExecute\u201d, \u201cInvokeMethod\u201d, $Null, $View, $Null)<\/p>\n

$record = $View.GetType().InvokeMember(
\n\u201cFetch\u201d, \u201cInvokeMethod\u201d, $Null, $View, $Null
\n)<\/p>\n

$global:productVersion = $record.GetType().InvokeMember(
\n\u201cStringData\u201d, \u201cGetProperty\u201d, $Null, $record, 1
\n)<\/p>\n

} catch {
\nthrow "Failed to get MSI file version the error was: {0}." -f $_
\n}
\n}<\/p>\n

function Get-MsiProductCode {
\nparam (
\n[IO.FileInfo] $FilePath
\n)<\/p>\n

try {
\n$windowsInstaller = New-Object -com WindowsInstaller.Installer<\/p>\n

$database = $windowsInstaller.GetType().InvokeMember(
\n\u201cOpenDatabase\u201d, \u201cInvokeMethod\u201d, $Null,
\n$windowsInstaller, @($FilePath.FullName, 0)
\n)<\/p>\n

$q = "SELECT Value FROM Property WHERE Property = ‚ProductCode’"
\n$View = $database.GetType().InvokeMember(
\n\u201cOpenView\u201d, \u201cInvokeMethod\u201d, $Null, $database, ($q)
\n)<\/p>\n

$View.GetType().InvokeMember(\u201cExecute\u201d, \u201cInvokeMethod\u201d, $Null, $View, $Null)<\/p>\n

$record = $View.GetType().InvokeMember(
\n\u201cFetch\u201d, \u201cInvokeMethod\u201d, $Null, $View, $Null
\n)<\/p>\n

$global:ProductCode = $record.GetType().InvokeMember(
\n\u201cStringData\u201d, \u201cGetProperty\u201d, $Null, $record, 1
\n)<\/p>\n

} catch {
\nthrow "Failed to get MSI file version the error was: {0}." -f $_
\n}
\n}<\/p>\n

function convert1 {
\nparam (
\n$codeID,
\n$i)
\n$global:convert1 = ""<\/p>\n

do {
\n$code = $codeID.Substring($i,1)
\n$global:convert1 = $global:convert1 + $code
\n$i = $i – 1
\n}
\nwhile ($i -ne -1)
\nreturn $global:convert1
\n}<\/p>\n

function convert2 {
\nparam (
\n$codeID,
\n$i)
\n$c = 0
\n$global:convert2 = ""
\ndo {
\n$code1 = $codeID.Substring($c,1)
\n$c++
\n$code2 = $codeID.Substring($c,1)<\/p>\n

$global:convert2 = $global:convert2 + $code2 + $code1
\n$c++
\n}
\nwhile ($c -ne $i)
\nreturn $global:convert2
\n}<\/p>\n

Function Get-FileName($initialDirectory)
\n{
\n[System.Reflection.Assembly]::LoadWithPartialName("System.windows.forms") |
\nOut-Null<\/p>\n

$OpenFileDialog = New-Object System.Windows.Forms.OpenFileDialog
\n$OpenFileDialog.ShowHelp = $True
\n$OpenFileDialog.initialDirectory = $initialDirectory
\n$OpenFileDialog.filter = "All files (*.msi)| *.msi"
\n# $OpenFileDialog.filter = "All files (*.*)| *.*"
\n$OpenFileDialog.ShowDialog() | Out-Null
\n$global:msifile = $OpenFileDialog.filename
\n} #end function Get-FileName
\n#######################################################################################################################<\/p>\n

#—–GUI——————————————————————-
\n[void] [System.Reflection.Assembly]::LoadWithPartialName("System.Drawing")
\n[void] [System.Reflection.Assembly]::LoadWithPartialName("System.Windows.Forms")<\/p>\n

$objForm = New-Object System.Windows.Forms.Form
\n$objForm.Text = "MSI Info Tool"
\n$objForm.Size = New-Object System.Drawing.Size(600,240)
\n$objForm.StartPosition = "CenterScreen"<\/p>\n

$objForm.KeyPreview = $True
\n$objForm.Add_KeyDown({if ($_.KeyCode -eq "Enter")
\n{$x=$objTextBox.Text;$objForm.Close()}})
\n$objForm.Add_KeyDown({if ($_.KeyCode -eq "Escape")
\n{$objForm.Close()}})<\/p>\n

$CancelButton = New-Object System.Windows.Forms.Button
\n$CancelButton.Location = New-Object System.Drawing.Size(485,170)
\n$CancelButton.Size = New-Object System.Drawing.Size(80,23)
\n$CancelButton.Text = "Cancel"
\n$CancelButton.Add_Click({$objForm.Close()})
\n$objForm.Controls.Add($CancelButton)<\/p>\n

$OpenButton = New-Object System.Windows.Forms.Button
\n$OpenButton.Location = New-Object System.Drawing.Size(10,20)
\n$OpenButton.Size = New-Object System.Drawing.Size(120,23)
\n$OpenButton.Text = "MSI Datei ausw\u00e4hlen"
\n$OpenButton.Add_Click({
\nGet-FileName -initialDirectory "c:\\"<\/p>\n

If ($global:msifile) {
\n$objTextBox1.Text = $global:msifile<\/p>\n

Get-MsiVersion $global:msifile
\nGet-MsiProductCode $global:msifile<\/p>\n

$global:MSIInstallerID = $global:productCode.replace("{","")
\n$global:MSIInstallerID = $global:MSIInstallerID.replace("}","")
\n$global:MSIInstallerID_split = $global:MSIInstallerID.split("-")<\/p>\n

$block0 = convert1 $global:MSIInstallerID_split[0] 7
\n$block1 = convert1 $global:MSIInstallerID_split[1] 3
\n$block2 = convert1 $global:MSIInstallerID_split[2] 3
\n$block3 = convert2 $global:MSIInstallerID_split[3] 4
\n$block4 = convert2 $global:MSIInstallerID_split[4] 12<\/p>\n

$global:MSIInstallerID = $block0 + $block1 + $block2 + $block3 + $block4<\/p>\n

$objTextBox3.Text = $global:productVersion
\n$objTextBox4.Text = $global:productCode
\n$objTextBox5.Text = $global:MSIInstallerID<\/p>\n

$objForm.Update()
\n}
\nElse{
\n[System.Reflection.Assembly]::LoadWithPartialName(\u201cSystem.Windows.Forms\u201d)
\n[Windows.Forms.MessageBox]::Show(\u201cEs wurde keine Datei ausgew\u00e4hlt!\u201d, \u201cError\u201d, [Windows.Forms.MessageBoxButtons]::OK, [Windows.Forms.MessageBoxIcon]::Information)
\n}
\n})
\n$objForm.Controls.Add($OpenButton)<\/p>\n

$objTextBox1 = New-Object System.Windows.Forms.TextBox
\n$objTextBox1.Location = New-Object System.Drawing.Size(140,22)
\n$objTextBox1.Size = New-Object System.Drawing.Size(400,20)
\n$objTextBox1.Text = "MSI Datei ausw\u00e4hlen"
\n$objForm.Controls.Add($objTextBox1)<\/p>\n

$objForm.Controls.Add($InfoButton)<\/p>\n

$objLabel2 = New-Object System.Windows.Forms.Label
\n$objLabel2.Location = New-Object System.Drawing.Size(10,90)
\n$objLabel2.Size = New-Object System.Drawing.Size(120,20)
\n$FontBold = new-object System.Drawing.Font("Arial",8,[Drawing.FontStyle]’Bold‘ )
\n$objLabel2.Font = $fontBold
\n$objLabel2.Text = "MSI Info"
\n$objForm.Controls.Add($objLabel2)<\/p>\n

$objLabel3 = New-Object System.Windows.Forms.Label
\n$objLabel3.Location = New-Object System.Drawing.Size(10,110)
\n$objLabel3.Size = New-Object System.Drawing.Size(160,20)
\n$objLabel3.Text = "MSI Version: "
\n$objForm.Controls.Add($objLabel3)<\/p>\n

$objTextBox3 = New-Object System.Windows.Forms.TextBox
\n$objTextBox3.Location = New-Object System.Drawing.Size(170,110)
\n$objTextBox3.Size = New-Object System.Drawing.Size(250,20)
\n$objForm.Controls.Add($objTextBox3)<\/p>\n

$objLabel4 = New-Object System.Windows.Forms.Label
\n$objLabel4.Location = New-Object System.Drawing.Size(10,135)
\n$objLabel4.Size = New-Object System.Drawing.Size(160,20)
\n$objLabel4.Text = "MSI ProductCode: "
\n$objForm.Controls.Add($objLabel4)<\/p>\n

$objTextBox4 = New-Object System.Windows.Forms.TextBox
\n$objTextBox4.Location = New-Object System.Drawing.Size(170,135)
\n$objTextBox4.Size = New-Object System.Drawing.Size(250,20)
\n$objForm.Controls.Add($objTextBox4)<\/p>\n

$objLabel5 = New-Object System.Windows.Forms.Label
\n$objLabel5.Location = New-Object System.Drawing.Size(10,160)
\n$objLabel5.Size = New-Object System.Drawing.Size(160,20)
\n$objLabel5.Text = "MSIInstallerID: "
\n$objForm.Controls.Add($objLabel5)<\/p>\n

$objTextBox5 = New-Object System.Windows.Forms.TextBox
\n$objTextBox5.Location = New-Object System.Drawing.Size(170,160)
\n$objTextBox5.Size = New-Object System.Drawing.Size(250,20)
\n$objForm.Controls.Add($objTextBox5)<\/p>\n

$objForm.Topmost = $True<\/p>\n

$objForm.Add_Shown({$objForm.Activate()})
\n[void] $objForm.ShowDialog()<\/p>\n

[\/php]<\/p>\n","protected":false},"excerpt":{"rendered":"

0 0 Oft schon stand ich vor dem Problem, das ich gerne die MSI-GUID, MSI-InstallerID und die Version einer neuen MSI Datei auslesen wollte, ohne gleich den Empirum Packaging Wizard zur Hand zu nehmen. Zum Beispiel bei Empirum Paketen, die aus mehreren MSI Dateien bestehen, oder nur um eine neuere Versionen einer Applikation, die \u00fcber … \u201ePowershell: Tool zum auslesen von MSI Informationen\u201c<\/span> weiterlesen<\/a><\/p>\n","protected":false},"author":1,"featured_media":1829,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1,3,38],"tags":[5,6,7,8,10,9],"_links":{"self":[{"href":"http:\/\/workplace.skyworker.de\/index.php?rest_route=\/wp\/v2\/posts\/65"}],"collection":[{"href":"http:\/\/workplace.skyworker.de\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/workplace.skyworker.de\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/workplace.skyworker.de\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/workplace.skyworker.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=65"}],"version-history":[{"count":15,"href":"http:\/\/workplace.skyworker.de\/index.php?rest_route=\/wp\/v2\/posts\/65\/revisions"}],"predecessor-version":[{"id":1836,"href":"http:\/\/workplace.skyworker.de\/index.php?rest_route=\/wp\/v2\/posts\/65\/revisions\/1836"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/workplace.skyworker.de\/index.php?rest_route=\/wp\/v2\/media\/1829"}],"wp:attachment":[{"href":"http:\/\/workplace.skyworker.de\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=65"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/workplace.skyworker.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=65"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/workplace.skyworker.de\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=65"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}