Inventory of Devices arranged by Rack
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
NOTES
Gives the ability to manage your assets to see if you have any missing data.