Flattened device → port → FDP → strand view with decoded lookups for connection tracing. The port's far end comes from device_link (lowest link_id if several): connected_device_name = the linked device's display_name, else the Tier-1 text in device_port.connected_device_name; connected_device_type = the linked device's type; uplink_device_name / uplink_port_label = the linked device and port when the link lands on a specific far port (mig 20260926_030).
cabinet_id cabinet_name cable_id cable_name connected_device_name connected_device_type device_id device_name device_type_label fdp_panel_name fdp_port_id fdp_port_num ip_address manufacturer model port_id port_label port_media_label port_number port_status_label port_type_label serial_number strand_id strand_order uplink_device_name uplink_port_label