Hi Huaraz
To extract the ips you can try to add this to your search:
| rex field=_raw "User:\s+(?<src>\d{1,3}\.\d{1,3}\.\d{1,3}\.\d{1,3}).*\s+->\s+(?<dst>\d{1,3}\.\d{1,3}\.\d{1,3}\.\d{1,3})"
Splunk doesn't tell you that the regex you apply to a search is not working the way you want, because it can only detect syntax errors.
There are different ways to get the desired result:
Check if the fields you just tried to create appear in the List if you click on "Pick fields" to the left of your search results (check the values that were found)
Splunk can help you generate the regex if you select "Extract Fields" from the context menu of an event that contains the values you want to extract into fields/variables. You can then test and save field extractions
You could also use 3rd party tool to help you with your regexes (http://regex.larsolavtorvik.com/)
Once you have your fields you can append a reporting command to your search (then click on show report to format the report):
Popular destinations(pie chart:
| chart count(src) by dst
Active Sources (pie chart):
| chart count(dst) by src
Show when a source is active (line chart):
| timechart count(src) by src
Or you could also just create a table of your sources and destination tuples:
| rex field=_raw "User:\s+(?<src>\d{1,3}\.\d{1,3}\.\d{1,3}\.\d{1,3}).*\s+->\s+(?<dst>\d{1,3}\.\d{1,3}\.\d{1,3}\.\d{1,3})" | where isnotnull(src) | table src dst | sort src
... View more