​@CarlB 

Unfortunately that would need to be requested as a feature request.  We currently do not parse the media type into the data model.  Which means that in the short term, you would need to parse it with NQE.

If it is not space separated, then you would need to define a user function to split the data.  Or you could use a glob match that would allow you to use wildcards.  Something like *fx*.

​@CarlB We parse the transceivers from the inventory, so while it isn’t listed under the interface, it does exist in the data model. This NQE will find the interface speed and the associated transceiver, and will fail interfaces with a speed of 100Mbps and a transceiver present. 

foreach device in network.devices
foreach interface in device.interfaces
where isPresent(interface.ethernet.speedMbps)
let partID = max(foreach component in device.platform.components
                 where component.name in interface.aliases
                 select component.partId)
select {
  violation: interface.ethernet.speedMbps == 100 && isPresent(mediaType),
  deviceName: device.name,
  interfaceName: interface.name,
  speedMbps: interface.ethernet.speedMbps,
 "Part ID": partID
}