(By: Gil Raviv. Originally published here).
In today’s episode on Excel for Security Analysts, we will import SSH logs to Excel. To read more episodes of Excel for Security Analysts, go here.
The idea for this post came from a TechNet forum thread that started by a Data Analyst here (Thank you Rajender for sharing the challenge and the logs).
You start with a log file like this:
And you should end up with a table in Excel: