Devices with OS but No Software
Compute Devices with OS but no Software captured.
Click to expand the code block
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.