Get CD/DVD Drives Report (VBScript)

' ============================================================
' GetCDROMDriveReport.vbs
'
' Reports CD/DVD Drives via WMI (Win32_CDROMDrive).
'
' Usage: cscript GetCDROMDriveReport.vbs
' ============================================================

Option Explicit

Dim objWMIService, colItems, objItem, strOutput

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

strOutput = ""
For Each objItem In colItems
    strOutput = strOutput & "Name: " & objItem.Name & vbCrLf
    strOutput = strOutput & "Drive: " & objItem.Drive & vbCrLf
    strOutput = strOutput & "MediaType: " & objItem.MediaType & vbCrLf
    strOutput = strOutput & String(40, "-") & vbCrLf
Next

If strOutput = "" Then
    WScript.Echo "No CD/DVD Drives found."
Else
    WScript.Echo strOutput
End If