This repository contains python scripts for parsing logs of the sshd daemon.
logparser_pd.py
- parses logs of the sshd and writes the result to theoutput/access_logs.xlsx
Excel filelogparser_pd_formatted.py
- parses logs of the sshd and writes the formated result to theoutput/access_logs_formated.xlsx
Excel filelogparser_pd_formatted_geoip.py
- parses logs of the sshd, adds information about country, city, isp, latitude and longitude of that who accessed the server and writes the formated result to theoutput/access_logs_formated_geoip.xlsx
Excel filelogparser_sql.py
- parses logs of the sshd and writes the result to theoutput/access.db
SQLite database using SQLAlchemy Corelogparser_sql_orm.py
- parses logs of the sshd and writes the result tooutput/access_orm.db
SQLite database using SQLAlchemy ORM