Devices with No OSs

Compute Devices with no OS captured.

Click to expand the code block

select
     ds.device_name
     ,device_fk
     ,ds.device_type
     ,ds.physicalsubtype_name
     ,ds.serial_number
     ,ds.device_service_level
     ,ds.tags
     ,ds.device_first_added
     ,ds.device_last_changed
     ,ds.is_missing_os
     ,ds.ip_address
from view_dbb_security_v2 ds
where ds.is_missing_os = 'Yes' and ds.device_fk  is not null

NOTES

Opportunities to enrich your data by doing a full discovery of devices.