OPNsense Forum

Archive => 19.1 Legacy Series => Topic started by: johjoh on February 11, 2019, 08:11:16 AM

Title: Create report from LOG
Post by: johjoh on February 11, 2019, 08:11:16 AM
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?
Title: Re: Create report from LOG
Post by: franco on February 11, 2019, 08:54:09 AM
This one is pretty powerful: https://www.splunk.com/

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


Cheers,
Franco
Title: Re: Create report from LOG
Post by: johjoh on February 15, 2019, 12:41:04 AM
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?
Title: Re: Create report from LOG
Post by: bdirk on March 21, 2019, 07:09:40 AM
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.