Device to Rack Inventory

Run this query to get an inventory of Devices arranged by Rack and see if you have any missing 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