Hello Team, we have an NQE that

1. searches all L2 switches
2. obtains each interface status
3. obtains speed
4. obtains sfp information

for all ports in up state. So far, we have the following:

foreach device in network.devices
foreach item in device.platform.components
where item.partType == DevicePartType.TRANSCEIVER

let interface = (foreach interface in device.interfaces
    where isPresent(findInterface(device, item.name))
    where interface.name == findInterface(device, item.name).interface.name
	select interface)
where length(interface) == 1
let int = min(interface)
select {
  deviceName: device.name,
  iface: int.name,
  speed: int.ethernet.negotiatedPortSpeed,
  partType: item.partType,
  partName: item.name,
}

Is there a way we could extract and add the below underlined in BLUE as additional columns as well? 

Thanks in advance for your time and help