Report "No DVD drive" false positives

[wgknowles]

The built in report "No DVD drive" is either:
1) Giving false positives when more then one optical drive is installed
or
2) Not correctly detecting this particular DVD drive:

Caption: HL-DT-ST DVD+-RW GSA-H21N
Description: CD-ROM Drive
DeviceID: IDE\CDROMHL-DT-ST_DVD+-RW_GSA-H21N_______________B109____\5&F2BD12B&0&0.1.0

I'm happy to provide more info if needed...
Respectfully,

[Hemoco]

You are correct to assume #1 (it's a bug)

All our test systems and customers have only one CD-dvd at maximum it seems.

[wgknowles]

Looking at the query, I think it's case #1 when there is more then one optical drive present...
I'm a bit rusty on my SQL syntax, anyone know how to fix this bug?

SELECT TOP 100 PERCENT dbo.tblComputers.Computername AS computer, dbo.tblOperatingsystem.Description, dbo.tblComputers.Domain,
dbo.tblCDROMDrive.Caption
FROM dbo.tblCDROMDrive INNER JOIN
dbo.tblComputers ON dbo.tblCDROMDrive.Computername = dbo.tblComputers.Computername INNER JOIN
dbo.tblOperatingsystem ON dbo.tblComputers.Computername = dbo.tblOperatingsystem.Computername
WHERE (NOT (dbo.tblCDROMDrive.DeviceID LIKE '%DVD%'))
ORDER BY dbo.tblComputers.Computername