I would like to know if there is any way to find out the ESXi Host Network Adapter's SFP/Transceiver details ( Model, Serial # etc) from ESXCLI ?. Thanks in advance.
Unfortunately, there is no a way to get the SFP transceiver module from an ESXi host.
You can use esxcli network nic get -n vmnicX to get some basic Layer 1 informations like, Port Speed, Link Status and Firmware/Driver information.
Ethtool is very limited on an ESXi host and does not allow the "-m" switch to get the SFP information.
You must always check both sides. iDRAC or iLO together with the switch values can provide information about the error.