Get Physical Memory Modules Report (VBScript)

' ============================================================
' GetPhysicalMemoryReport.vbs
'
' Reports Physical Memory Modules via WMI (Win32_PhysicalMemory).
'
' Usage: cscript GetPhysicalMemoryReport.vbs
' ============================================================

Option Explicit

Dim objWMIService, colItems, objItem, strOutput

Set objWMIService = GetObject("winmgmts:\\.\root\cimv2")
Set colItems = objWMIService.ExecQuery("SELECT BankLabel, Capacity, Speed, Manufacturer FROM Win32_PhysicalMemory")

strOutput = ""
For Each objItem In colItems
    strOutput = strOutput & "BankLabel: " & objItem.BankLabel & vbCrLf
    strOutput = strOutput & "Capacity: " & objItem.Capacity & vbCrLf
    strOutput = strOutput & "Speed: " & objItem.Speed & vbCrLf
    strOutput = strOutput & "Manufacturer: " & objItem.Manufacturer & vbCrLf
    strOutput = strOutput & String(40, "-") & vbCrLf
Next

If strOutput = "" Then
    WScript.Echo "No Physical Memory Modules found."
Else
    WScript.Echo strOutput
End If