Visual Basic Script | Software Inventory | List and Generate a .CSV report file of all installed software on Windows Local System

Its a usual task for any of Windows Systems administrator to generate an inventory of Software installed on a Windows System.  In most of the enterprises there would be various enterprise Inventory software employed for this purpose.  But still if you wan to generate a quick ( and up-to-date) list from any Windows System, you can use below script that I modified to save the output/report to a .CSV file in the current working directory.

VBScript to List All Installed Software | VBScript for Windows Software Inventory:

[code language=”vb”]
Set objFSO = CreateObject("Scripting.FileSystemObject")
Set objFile = objFSO.CreateTextFile("Software-Inventory.csv", True)

On Error Resume Next

Const HKLM = &H80000002 ‘HKEY_LOCAL_MACHINE
strComputer = "."
strKey = "SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\"
strEntry1a = "DisplayName"
strEntry1b = "QuietDisplayName"
strEntry2 = "InstallDate"
strEntry3 = "VersionMajor"
strEntry4 = "VersionMinor"
strEntry5 = "EstimatedSize"

Set objReg = GetObject("winmgmts://" & strComputer & _
"/root/default:StdRegProv")
objReg.EnumKey HKLM, strKey, arrSubkeys
‘WScript.Echo "Installed Applications" & VbCrLf
For Each strSubkey In arrSubkeys
intRet1 = objReg.GetStringValue(HKLM, strKey & strSubkey, _
strEntry1a, strValue1)
If intRet1 <> 0 Then
objReg.GetStringValue HKLM, strKey & strSubkey, _
strEntry1b, strValue1
End If
‘If strValue1 <> "" Then
‘WScript.Echo VbCrLf & "Display Name: " & strValue1
‘objFile.WriteLine "Display Name: " & strValue1
‘End If
objReg.GetStringValue HKLM, strKey & strSubkey, _
strEntry2, strValue2
If strValue2 <> "" Then
‘WScript.Echo "Install Date: " & strValue2
‘objFile.WriteLine "Install Date: " & strValue2
End If
objReg.GetDWORDValue HKLM, strKey & strSubkey, _
strEntry3, intValue3
objReg.GetDWORDValue HKLM, strKey & strSubkey, _
strEntry4, intValue4
If intValue3 <> "" Then
‘WScript.Echo "Version: " & intValue3 & "." & intValue4
‘objFile.WriteLine "Version: " & intValue3 & "." & intValue4
End If
objReg.GetDWORDValue HKLM, strKey & strSubkey, _
strEntry5, intValue5
If intValue5 <> "" Then
‘WScript.Echo "Estimated Size: " & Round(intValue5/1024, 3) & " megabytes"
‘objFile.WriteLine
End If

If strValue1 <> "" Then
objFile.WriteLine strValue1 & "," & strValue2 & "," & intValue3 & "." & intValue4
End If

Next

[/code]

Reference:

Microsoft Script Center | List All Installed Software

Leave a Reply

Your email address will not be published. Required fields are marked *