Ethernet issues.

Thanks guys, its on its way for repair.

Out of interest do the wired and wireless interfaces share a NIC? If not it is odd that both failed at the same time

This has to do with the fact that the Xbox needs certain ports do communicate with(being in wired position too).
It want to communicate using the same ports the UPnP protocols of the router, which can be given by the ISP, used to assign the correct port numbers in use with the network device.

Source: https://answers.microsoft.com/xbox/...rd-wired/3ea011d9-83ae-4936-98ce-69317d7ad11b

Have you tried running the "Restore to factory defaults" function on your Xbox. It is located in the Network Settings under additional settings. Then see if it will connect. If not, then I would say your Network Port in your Xbox is bad and you will
need to send it in for repair.

That's pretty much the norm. When I did it opened to open visually but didn't work and reverted to unavailable after restarting again

Yes ask them about the port-forwarding. To let your Xbox console communicate with the Xbox network, you need to open or forward ports, which means you'll be making a configuration change to your router.

These are the ports which you need to open in your router:

Port 88 (UDP)
Port 3074 (UDP and TCP)
Port 53 (UDP and TCP)
Port 80 (TCP)
Port 500 (UDP)
Port 3544 (UDP)
Port 4500 (UDP)

Source: https://support.xbox.com/en/help/hardware-network/connect-network/network-ports-used-xbox-live

Kind regards