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.