Physical Devices Without Hardware Model
Lists physical devices missing hardware information to see if you have any missing data.
Click to expand the code block
select
dc.device_fk
,dc.device_name
,dc.manufacturer
,dc.hardware_model
,dc.device_type
,dc.service_level
,[dc.in](http://dc.in/)_service
,dc.customer_department
,dc.server_location
,dc.building_address
,dc.room_name
,dc.row_name
,dc.rack_name
,dc.u_position
,dc.last_discovered
,dc.tags
,[dc.in](http://dc.in/)_service
from view_dbb_compute_v2 dc
where lower(dc.device_type)= 'physical' and dc.hardware_model is null
order by 2