Inventory of Physical Devices grouped by Customer Department.
select dc.customer_department ,dc.asset_number ,dc.last_discovered ,dc.device_name ,dc.device_type ,dc.device_serial ,dc.in_service ,dc.building_name ,dc.room_name ,dc.row_name ,dc.rack_name ,dc.u_position from view_dbb_compute_v2 dc where lower(dc.device_type)= 'physical' order by 1,2,4
NOTES
Asset number (asset tag) is set by customer and not directly discovered.
Use this to assist with physical inventory by customer department.