Devices Missing Device_Type or Service_Level

Returns devices where service_level or device_type is missing, unknown, or set to a placeholder value. Note that service_level is set manually and is not directly discovered.

Click to expand the code block

select
     dc.device_fk
     ,dc.device_name
     ,dc.service_level
     ,dc.device_type
     ,dc.device_subtype
     ,dc.virtual_subtype
     ,dc.cloud_service_provider
     ,dc.cloud_service_name
     ,dc.device_serial
     ,dc.device_type
from view_dbb_compute_v2 dc
where lower(dc.service_level) in (null, 'missing', 'tbd')
     or lower(dc.device_type) in (null, 'unknown')