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%"
About Author
Ronni Pedersen
My name is Ronni Pedersen and I'm currently working as a Cloud Architect at APENTO in Denmark. My primary focus is Enterprise Client Management solutions, based on technologies like AzureAD, Intune, EMS and System Center Configuration Manager. I'm is also a Microsoft Certified Trainer and Microsoft MVP in Enterprise Mobility.