Looking for a way in a SQL query to extract the IP address from a string and then rename it.
For example I have a date field called Date_Time and field called "message" and it contains data such as
TCP connection 72260 for Outside:22.214.171.124/4717 to Inside:0.0.0.0/650 duration 0:00:00 bytes 0 TCP Reset-I ()
TCP connection 7260 for Outside:126.96.36.199/4718 to Inside:10.10.10.10/60 duration 0:00:00 bytes 0 TCP Reset-I ()
I want to grab the IP address of 188.8.131.52 and return something like
2008-10-17 10:48:48 NewHostName <---- based on the IP of 123.123129.145
2008-10-17 10:50:17 AnotherHostName <---- based on the IP of 123.123123.19