From your discovery output, the target still seems to be there, which is a good start. The docs have a section for the SR part: https://docs.xcp-ng.org/storage/manage-srs#reattach-a-forgotten-sr (with xe sr-probe just below it to find the IQN and LUN, though I haven't tried it on iSCSI myself).
Before you go further, though, there's something Olivier explained in a similar thread: the VM definitions (name, CPU, RAM, which disks) live in the host's database, not on the SR, so after a reinstall the disks can come back, but the VMs as they were only return with a metadata backup; otherwise it means recreating them and attaching the disks (https://xcp-ng.org/forum/post/93504).
Did you have an XCP-ng metadata backup job in XO, or one from the host console? Also, from what I read in the LVM storage driver, creating a new SR on that LUN would wipe it, so I'd be careful not to click through anything that offers to create one. Your post got cut off at "Other things d", could you tell us what else you tried?
@Team-Storage, could someone check I haven't steered okynnor wrong here?