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%"
Get new posts by email
Practical articles on Intune, Windows and endpoint security, plus Workplace Ninja meetups. No spam, unsubscribe anytime.