topic Re: Log export to excel CSV in Firewall and Security Management

Log export to excel CSV

VENKAT_S_P — Tue, 22 Jun 2021 21:19:30 GMT

general question:
Is there a option to export all (not first 50 records) the 7days / 30days logs to CSV file from Logs & Monitor pane?

Re: Log export to excel CSV

Maarten_Sjouw — Wed, 11 Jul 2018 10:50:28 GMT

It will export the part that is visible within your scrolled area, so when you set a filter and scroll down to the beginning of the filter output and then run your export, you will get the items that are in your display buffer in the exportfile.

Re: Log export to excel CSV

PhoneBoy — Fri, 21 Jun 2019 09:22:31 GMT

SmartView supports this.

See: https://community.checkpoint.com/message/6415-smartview-accessing-check-point-logs-from-web

Re: Log export to excel CSV

VENKAT_S_P — Wed, 11 Jul 2018 21:02:13 GMT

Thanks, SmartView is awesome.

Re: Log export to excel CSV

aner_sagi — Mon, 15 Apr 2019 19:50:15 GMT

Hi.

My customer wants to export 7 days of log to CSV.

smartcenter R80.20 jumbo 33. after installing fix sk148794 i am able to login.

export all logs (up to 1 million lines). sometimes works sometime not.

the problem is that when it works it generate an excel file of less then 30 minutes of logs !

customer has 15 firewalls on smartcenter. is there a way to really export 7 days of logs to several csv files ?

Thanks in advance

Aner.

Re: Log export to excel CSV

PhoneBoy — Mon, 15 Apr 2019 21:50:01 GMT

As for "sometimes works sometimes not" customer should engage with the TAC.
When it does export, do you get a million log entries in that CSV file?
And why do they want 7 days worth of logs in a CSV file?

I suspect a better solution would be to use Log Exporter to continually export the logs to a syslog server or third party SIEM.
If you're just using a standard Linux machine as a syslog server, all the logs will be in ASCII text.

Re: Log export to excel CSV

peter_schumache — Wed, 14 Aug 2019 14:05:08 GMT

And where does SmartView the exported execel CSV store?

Re: Log export to excel CSV

Tal_Paz-Fridman — Wed, 14 Aug 2019 14:15:40 GMT

You download the file on the machine running browser with SmartView.

After the export is completed you will be prompted to download the file.

HTH

Tal

Re: Log export to excel CSV

rlamerico — Wed, 14 Jul 2021 01:28:09 GMT

Hi PhoneBoy,

Do you know if there is another option in addition to Log Exporter? for example, consult these informations using an API.

Re: Log export to excel CSV

PhoneBoy — Wed, 14 Jul 2021 01:31:49 GMT

From R80.40 JHF 78 you can do log queries via REST API.
https://sc1.checkpoint.com/documents/latest/APIs/#cli/show-logs~v1.8%20