Device to Rack Inventory

Returns a physical device inventory organized by location hierarchy — building, room, row, rack, and U position. Use this to verify rack assignments and spot gaps in your physical inventory data.

Click to expand the code block

select
     dc.device_type
     ,dc.server_location
     ,dc.building_name
     ,dc.building_address
     ,dc.room_name
     ,dc.row_name
     ,dc.chassis_u_location
     ,dc.chassis_device_name
     ,dc.rack_name
     ,dc.u_position
     ,dc.device_name
     ,dc.asset_number
     ,dc.manufacturer
     ,dc.hardware_model
     ,dc.service_level
     ,dc.in_service
     ,dc.customer_department
     ,dc.device_type
     /* / used if renting bare-metal machine from a cloud provider.*/
     ,dc.cloud_service_provider
from view_dbb_compute_v2 dc
where lower(dc.device_type) = 'physical' and  dc.rack_name is not null
order by dc.server_location, dc.building_name, dc.room_name,
dc.storage_room, dc.row_name, dc.rack_name, dc.u_position