0

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?

Yogesh Sharma
  • 49,870
  • 5
  • 26
  • 52
koly86
  • 165
  • 2
  • 11
  • What you need as the output. – Pawan Kumar May 22 '18 at 09:22
  • I need TCP, 192.168.1.13/10001, 192.168.1.10/30475 – koly86 May 22 '18 at 09:48
  • 1
    something like this - SELECT LTRIM(REPLACE(REPLACE(REPLACE(value ,'(',''),')',''),'ethKASSY:','')) 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 LIKE '%192.168.1%' – Pawan Kumar May 22 '18 at 10:45

0 Answers0