How to generate a log file with version number appending to msi verbose log.
Symptoms
When ever we install a msi the logfile will be created without the version number of installer, it will be helpful if the log file has version number append to the log file.
Resolution
You can execute the below vbscript code to set delete the unused component from your project ism file. You can also write the same code using PowerShell also
You can run the script using vbs editor or you can run the script using “wscript.exe” in cmdlet.
Path to wscript.exe “C:\Windows\System32>wscript.exe”
Here is my sample script to install a msi package and generate log with version number,
Const msiOpenDatabaseModeReadOnly = 0
Dim msi, db, view, Test, strLog
Set oShell = WScript.CreateObject( "WScript.Shell" )
Set msi = CreateObject("WindowsInstaller.Installer")
Set db = msi.OpenDataBase("<Path to msi package>", msiOpenDatabaseModeReadOnly)
Set view = db.OpenView("SELECT `Value` FROM `Property` WHERE `Property` = 'ProductVersion'")
Call view.Execute()
GetVersion = view.Fetch().StringData(1)
Test = GetVersion
Wscript.Echo Test
CStr(Test)
Wscript.Echo Test
oShell.CurrentDirectory = "C:\Users\Administrator\Downloads\"
strLog = "C:\SetupMsilog_" & Test & ".log"
oShell.Run "TestComponent.msi /l*v " & chr(34) & strLog,0,True
