' ============================================================
' GetPhysicalMemoryReportToFile.vbs
'
' Reports Physical Memory Modules via WMI (Win32_PhysicalMemory) and writes the results to a
' timestamped text file next to this script.
'
' Usage: cscript GetPhysicalMemoryReportToFile.vbs
' ============================================================

Option Explicit

Dim objWMIService, colItems, objItem
Dim objFSO, objFile, strOutPath, itemCount

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

Set objFSO = CreateObject("Scripting.FileSystemObject")
strOutPath = objFSO.GetParentFolderName(WScript.ScriptFullName) & "\physicalmemory-report_" & _
             Replace(FormatDateTime(Now, 2), "/", "-") & ".txt"
Set objFile = objFSO.CreateTextFile(strOutPath, True)

itemCount = 0
For Each objItem In colItems
        objFile.WriteLine "BankLabel: " & objItem.BankLabel
        objFile.WriteLine "Capacity: " & objItem.Capacity
        objFile.WriteLine "Speed: " & objItem.Speed
        objFile.WriteLine "Manufacturer: " & objItem.Manufacturer
        objFile.WriteLine String(40, "-")
        itemCount = itemCount + 1
Next

objFile.Close

WScript.Echo itemCount & " Physical Memory Modules written to: " & strOutPath