On Error Resume Next strComputer = "." Set objWMIService = GetObject("winmgmts:\\" strComputer "\root\CIMV2") Set colItems = objWMIService.ExecQuery( _ "associators of {win32_logicaldisk.deviceid='G:'} WHERE ResultClass=Win32_DiskPartition") For Each objItem in colItems TargetIndex = objItem.DiskIndex Set Items = objWMIService.ExecQuery( _ "SELECT * FROM Win32_DiskDrive Where DeviceID Like '%" objItem.DiskIndex "'",,48) For Each Item in Items Wscript.Echo "Model: " Item.Model Next