Compute Devices with OS but no Software captured.
select distinct ds.device_fk ,ds.device_name ,ds.device_type ,ds.device_service_level ,ds.tags ,ds.device_first_added ,ds.device_last_changed ,ds.is_missing_os ,ds.is_missing_software from view_dbb_security_v2 ds where ds.is_missing_software = 'Yes' and ds.device_fk is not null and ds.is_missing_os = 'No'
NOTES
Opportunities to enrich your data by doing a full discovery of devices.