are you looking for the part#? 

I used the built in components instead of show interface. 

foreach device in network.devices

let platform = device.platform

foreach component in platform.components

where component.partType == DevicePartType.TRANSCEIVER

select {
    deviceName: device.name,
    componentName: component.name,
    PID: component.partId,
    serialNumber: component.serialNumber,
    model: device.platform.model,
    OS: device.platform.osVersion,
}

As for the media type I ended up using the PIDs and a lookup table in Excel.

if you are looking for specific transceivers, also check out AricaFN’s answer for a question I had looking for 100Mbps fiber transceivers:

Thanks for the details, these are not working for cisco nexus devices and i am only looking specifics to Nexus. Can you suggest another option if possible please?

Cisco Nexus - this may have to be a custom command because they are not in the inventory from what I can tell - I think ‘show transceivers’ but need to test.

Thanks, custom command (“show interface status”) run successfully & shows the SPF details. Requirement is to check the possibility to pull these info through NQE.