Get CD/DVD Drives Report to File (VBScript)

' ============================================================
' GetCDROMDriveReportToFile.vbs
'
' Reports CD/DVD Drives via WMI (Win32_CDROMDrive) and writes the results to a
' timestamped text file next to this script.
'
' Usage: cscript GetCDROMDriveReportToFile.vbs
' ============================================================

Option Explicit

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

Set objWMIService = GetObject("winmgmts:\\.\root\cimv2")
Set colItems = objWMIService.ExecQuery("SELECT Name, Drive, MediaType FROM Win32_CDROMDrive")

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

itemCount = 0
For Each objItem In colItems
        objFile.WriteLine "Name: " & objItem.Name
        objFile.WriteLine "Drive: " & objItem.Drive
        objFile.WriteLine "MediaType: " & objItem.MediaType
        objFile.WriteLine String(40, "-")
        itemCount = itemCount + 1
Next

objFile.Close

WScript.Echo itemCount & " CD/DVD Drives written to: " & strOutPath