This SQL can be applied to a dcTrack SQL Widget to report all items in all cabinets sorted by Location, Cabinet, and U position. Each cabinet u position is indicated with the device that occupies that position or with a note that indicates that the position is open.

To use this sql on your dcTrack dashboard, download the txt file below and paste the contents into a dcTrack SQL Widget.