This SMS query will, list all PCs without a DVD.
select * from SMS_R_System inner join SMS_G_System_CDROM on SMS_G_System_CDROM.ResourceID = SMS_R_System.ResourceId where SMS_G_System_CDROM.DeviceID not like "%DVD%"
This SMS query will, list all PCs without a DVD.
select * from SMS_R_System inner join SMS_G_System_CDROM on SMS_G_System_CDROM.ResourceID = SMS_R_System.ResourceId where SMS_G_System_CDROM.DeviceID not like "%DVD%"