Create report from LOG

[johjoh]

Hello, I need to create a report or an audit from the LOG files of the last month in OPNsense.
What software I can use? What files I must export?

[franco]

This one is pretty powerful: https://www.splunk.com/

Under System: Settings: Logging you should remote-export all the logs to it.


Cheers,
Franco

[johjoh]

Thank you Franco, Splunk is powerful but it isn't what I'm lookin for.
I'm searching for something simple like LogMX.
1. I export LOG from the last 30 days in CSV format from Reporting - Insight - Export - FlowSourceAddrDetails
2. I import them in a simple software
3. the software resolve the hostname of the public IP

Any other idea?

[bdirk]

Hello,

we have to check ramdomly a month wich sites has been visited.
So im also looking for a method to do report like this.