strComputer = "."
Set objWMIService = GetObject( _
"winmgmts:\\" & strComputer & "\root\cimv2")
Set colItems = objWMIService.ExecQuery( _
"Select * from Win32_CDROMDrive")
For Each objItem in colItems
Wscript.Echo "Media Type " & objItem.MediaType
Next
S:\Test\>cscript //nologo CDROM-MediaType.vbs
Media Type DVD Writer
Returns this when tray is empty and with CD-R, CD-RW, DVD+R, DVD+RW media in tray.