Query to identify the presence of a DVD drive

Content Authoring
1

(imported topic written by jclark91)

I am looking for a way to detect the presence of a DVD drive on an endpoint. I have been using the following query, but it seems to miss a fair number of DVD drives out there:

if( name of operating system starts with “Win” ) then (if (exists active device whose (friendly name of it as lowercase contains “dvd”)) then “Yes” else “No”) else “Not Applcable”

2

(imported comment written by Lee Wei)

Maybe you can try the following:

string values of selects "name from win32_pnpentity where service = ‘cdrom’ " of wmi

Then to get a True/False

exists string values of selects "name from win32_pnpentity where service = ‘cdrom’ " of wmi

Lee Wei