Physical Devices by Customer Department

Inventory of Physical Devices grouped by Customer Department.

Click to expand the code block

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.