Python Forum
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Parsing a syslog file
#6
Do a test to make sure username is in line,as your regex dos not test that.
Use enumerate and not range(len(data)).
Then it will be like this.
import re
import json
from ast import literal_eval

filename = "systemfile.log"
# strip unneeded text from json format and save audit lines only
re_line= re.compile("audit")
data = []
with open(filename, "r") as in_file:
    # Loop over each log line
    for line in in_file:
        if re_line.search(line):
            data.append(line)

#print(data)

for index,line in enumerate(data):
    if 'username' in line:
        res = data[index].strip().split('[audit] ')[1]
        result = literal_eval(res)
        #print(result)
        timestamp = result['timestamp']
        user = result['user']['username']
        print(timestamp)
        print(user)
Output:
1633848664540 admin 1633848914062 admin
ebolisa likes this post
Reply


Messages In This Thread
Parsing a syslog file - by ebolisa - Oct-10-2021, 08:48 AM
RE: Parsing a syslog file - by snippsat - Oct-10-2021, 10:33 AM
RE: Parsing a syslog file - by ebolisa - Oct-10-2021, 10:49 AM
RE: Parsing a syslog file - by ndc85430 - Oct-10-2021, 10:53 AM
RE: Parsing a syslog file - by ebolisa - Oct-10-2021, 10:56 AM
RE: Parsing a syslog file - by snippsat - Oct-10-2021, 11:25 AM
RE: Parsing a syslog file - by ebolisa - Oct-10-2021, 11:43 AM
RE: Parsing a syslog file - by ebolisa - Oct-10-2021, 12:37 PM
RE: Parsing a syslog file - by snippsat - Oct-10-2021, 01:46 PM
RE: Parsing a syslog file - by ebolisa - Oct-10-2021, 03:14 PM
RE: Parsing a syslog file - by ebolisa - Oct-10-2021, 04:11 PM
RE: Parsing a syslog file - by snippsat - Oct-10-2021, 05:15 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
Video doing data treatment on a file import-parsing a variable EmBeck87 15 3,101 Apr-17-2023, 06:54 PM
Last Post: EmBeck87
  Modify values in XML file by data from text file (without parsing) Paqqno 2 1,800 Apr-13-2022, 06:02 AM
Last Post: Paqqno
  Parsing xml file deletes whitespaces. How to avoid it? Paqqno 0 1,090 Apr-01-2022, 10:20 PM
Last Post: Paqqno
Thumbs Up Parsing a YAML file without changing the string content..?, Flask - solved. SpongeB0B 2 2,338 Aug-05-2021, 08:02 AM
Last Post: SpongeB0B
  Syslog server Fifoux082 5 2,871 Sep-15-2020, 07:08 PM
Last Post: Fifoux082
  File Name Parsing millpond 5 3,739 Aug-26-2020, 08:04 AM
Last Post: bowlofred
  Error while parsing tables from docx file aditi 1 3,845 Jul-14-2020, 09:24 PM
Last Post: aditi
  help parsing file aslezak 2 2,284 Oct-22-2019, 03:51 PM
Last Post: aslezak
  Python Script for parsing dictionary values from yaml file pawan6782 3 5,015 Sep-04-2019, 07:21 PM
Last Post: pawan6782
  Parsing an MBOX file Oliver 1 8,278 May-26-2019, 07:12 AM
Last Post: heiner55

Forum Jump:

User Panel Messages

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