I recommend using the following report as a starting point: https://www.lansweeper.com/forum/yaf_postst9860_All-switches-and-the-assets-connected-to-them.aspx
The speed of the connection will be scanned from the switch. If you can link the asset that is connected to the switch port you can find what kind of speed it's connection is.