Log Parser for linux [closed]

Question

Log Parser is great tool for parsing log files. I can parse not just IIS log files but also custom log files with it.

For example I can use SQL syntax to parse logs:

C:\>LogParser "SELECT TimeGenerated, SourceName, 
EventCategoryName, Message INTO report.txt FROM Security WHERE 
EventID = 528 AND SID LIKE '%TESTUSER%'" -resolveSIDs:ON

Is there any tool like that for linux?

Thanks.

Answer 1

lnav supports SQL queries and supports most of the common Linux log formats. Look at the project's website and documentation page for more details and screenshots.