Netstat time of Established connections between LocalAddress/Port and ForeignAddress/Port


Source is the Splunk NIX netstat output which typically includes details:
LocalAddress ForeignAddress Statue
tcp 0 0 10.X.X.X:7443 10.X.X.X:18068 ESTABLISHED
tcp 0 0 10.X.X.1:7443 10.X.X.2:18069 ESTABLISHED
tcp 0 0 10.X.X.1:7443 10.X.X.3:18070 ESTABLISHED
tcp 0 0 10.X.X.1:7443 10.X.X.4:18071 ESTABLISHED

Goal is to measure how long each LocalAddress and ForeignAddress has been in a established state.

So from the first time in the event stream that the two combinations are seen till the last time they are seen.

And output similar to
LocalAddress ForeignAddress Duration
10.X.X.1:7443 10.X.X.4:18068 30 seconds

Tried different ways to correlate the two fields but have not been able to get a duration time between the two combinations.

Any input on getting the results would be appreciated.

Tags (1)
0 Karma
State of Splunk Careers

Access the Splunk Careers Report to see real data that shows how Splunk mastery increases your value and job satisfaction.

Find out what your skills are worth!