Python Forum
time difference bettwenn logs
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
time difference bettwenn logs
#7
I put the years in, just for fun:

# if you want to repeat, reset file seek to zero: log.seek(0)
log = StringIO(
    """<150>2022 Nov  7 07:38:33 DrayTek: Local User (MAC=B0-8C-75-C0-FF-8F): 172.16.91.7:57422 -> 17.57.172.11:443 (TCP)
<150>2023 Nov  7 07:38:43 DrayTek: Local User (MAC=B0-8C-75-C0-FF-8F): 172.16.91.7:57423 -> 17.57.172.11:443 (TCP)
<150>2023 Nov  7 08:38:33 DrayTek: Local User (MAC=B0-8C-75-C0-FF-8F): 172.16.91.7:57424 -> 17.57.13.65:443 (TCP)
<150>2024 Nov  8 07:38:33 DrayTek: Local User (MAC=B0-8C-75-C0-FF-8F): 172.16.91.7:57425 -> 17.57.13.65:443 (TCP)"""
)
Then just do what deanhystad said:

prev = None
for line in log:
    dt = datetime.strptime(line[5:25], "%Y %b %d %H:%M:%S")
    if prev is not None:
        print(dt - prev)
    prev = dt
# need this to repeat reading the log
log.seek(0)
Output:
365 days, 0:00:10 0:59:50 366 days, 23:00:00
Reply


Messages In This Thread
time difference bettwenn logs - by enkliy - Nov-20-2023, 09:25 AM
RE: time difference bettwenn logs - by snippsat - Nov-20-2023, 10:32 AM
RE: time difference bettwenn logs - by rob101 - Nov-20-2023, 11:33 AM
RE: time difference bettwenn logs - by enkliy - Nov-20-2023, 01:18 PM
RE: time difference bettwenn logs - by deanhystad - Nov-20-2023, 08:43 PM
RE: time difference bettwenn logs - by Larz60+ - Nov-21-2023, 10:32 AM
RE: time difference bettwenn logs - by Pedroski55 - Nov-21-2023, 11:04 AM
RE: time difference bettwenn logs - by enkliy - Nov-21-2023, 02:05 PM
RE: time difference bettwenn logs - by rob101 - Nov-21-2023, 02:26 PM
RE: time difference bettwenn logs - by enkliy - Nov-21-2023, 02:41 PM
RE: time difference bettwenn logs - by rob101 - Nov-21-2023, 03:00 PM
RE: time difference bettwenn logs - by enkliy - Nov-21-2023, 03:36 PM
RE: time difference bettwenn logs - by rob101 - Nov-21-2023, 03:39 PM
RE: time difference bettwenn logs - by deanhystad - Nov-21-2023, 04:43 PM
RE: time difference bettwenn logs - by rob101 - Nov-21-2023, 04:51 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Hard time trying to figure out the difference between two strings carecavoador 2 756 Aug-16-2023, 04:53 PM
Last Post: carecavoador
  Sum up Time difference tester_V 10 2,850 Apr-06-2023, 06:54 AM
Last Post: Gribouillis
  Bot refuses to count logs. M1racle 0 1,306 Dec-13-2021, 06:42 PM
Last Post: M1racle
  Get Azure activity logs using python script raham3406 4 3,682 Apr-27-2021, 05:10 AM
Last Post: raham3406
  How to get indices of minimum time difference Mekala 1 2,229 Nov-10-2020, 11:09 PM
Last Post: deanhystad
  How to calculate time difference between each row of dataframe in seconds Mekala 1 2,669 Jul-16-2020, 12:57 PM
Last Post: Larz60+
  python realtime parsing logs anna 2 2,972 Jul-05-2020, 06:36 AM
Last Post: anna
  capture logs on specific port anna 1 1,822 Jun-27-2019, 03:47 PM
Last Post: Larz60+
  Correlation of Incidents using time difference Rajhesh 1 1,894 Jun-27-2019, 03:44 PM
Last Post: Larz60+
  Time Difference in Epoch Microseconds then convert to human readable firesh 4 11,758 Feb-27-2018, 09:08 AM
Last Post: firesh

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020