How to parse MSsql string

51 Views Asked by koly86 At 04 April 2025 at 22:30

Help please I need to get from this string

SELECT value 
FROM STRING_SPLIT('<166>%ASA-6-302013: Built outbound TCP connection 322558458 for ethKASSY:192.168.1.13/10001 (10.21.8.13/10001) to ethASK_EXT_TSSM:10.43.8.24/5508 (192.168.1.10/30475) ', ' ') 
where value in('ethKASSY:192.168.1.13/10001')

Ip address 192.168.1.13 and port 192.168.1.13

Maybe Anybody knows?

There are 0 best solutions below