I have tried that cable on its own and it has not been working.

In the above comment when you said adapter did you mean this one

https://www.amazon.com/DTECH-Straight-Through-Serial-Female/dp/B07B4VXNLS/

or this thing

https://www.amazon.com/StarTech-com-RS232-Serial-Modem-Adapter/dp/B000DZH4V0/

So plug this into switch console - https://www.amazon.com/StarTech-com-RS232-Serial-Modem-Adapter/dp/B000DZH4V0/ref=pd_lpo_23_t_0/144-5799679-7259003?_encoding=UTF8&pd_rd_i=B000DZH4V0&pd_rd_r=446b189b-500b-4392-9894-e0127eb95168&pd_rd_w=PRDax&pd_rd_wg=fPHKj&pf_rd_p=7b36d496-f366-4631-94d3-61b87b52511b&pf_rd_r=J2745GKB61QAAA84F00F&psc=1&refRID=J2745GKB61QAAA84F00F

And use this cable I already have to plug into adapter https://www.amazon.com/gp/product/B01JWD8L74/ref=ppx_yo_dt_b_asin_title_o02_s00?ie=UTF8&psc=1

Like this?