topic Re: Export Log to Excel CSV in Smart-1 Cloud in Firewall and Security Management

Export Log to Excel CSV in Smart-1 Cloud

Pedro_Sentinela — Wed, 18 May 2022 17:25:46 GMT

I need export the logs for a worksheet, but in smat-1 cloud generate a alert saying: "to export logs to excel, please use SmartView Web Aplplication." when i go to smart view application, the application dont load. SmartView monitor should work in smart-1 cloud?

As the smartview web application is on top of the manager's ip and smart-1 has no manager how do I export the logs in this case?

somebody help me?
reference:

Re: Export Log to Excel CSV in Smart-1 Cloud

the_rock — Wed, 18 May 2022 18:36:52 GMT

Go under "logs and events" under portal for smart-1 cloud and then on upper right right, click export and follow prompts, works 100%.

Re: Export Log to Excel CSV in Smart-1 Cloud

Pedro_Sentinela — Wed, 18 May 2022 19:17:22 GMT

Logs&Monitor correct?

I did the same thing I was trying on the console, but now smart-1 cloud and the result is the same.

Re: Export Log to Excel CSV in Smart-1 Cloud

Tomer_Noy — Thu, 19 May 2022 09:03:22 GMT

It should be done in the "LOGS & EVENTS" page in the Smart-1 Cloud application within the Infinity Portal (not in SmartConsole).

That page is the same as browsing to the smartview web application.

Re: Export Log to Excel CSV in Smart-1 Cloud

Pedro_Sentinela — Thu, 19 May 2022 11:23:57 GMT

I didn't know about this Log&Events page outside the console. thank you for your help.

Re: Export Log to Excel CSV in Smart-1 Cloud

Pedro_Sentinela — Thu, 19 May 2022 11:25:53 GMT

thank you this helped me a lot

Re: Export Log to Excel CSV in Smart-1 Cloud

the_rock — Thu, 19 May 2022 12:45:54 GMT

Thats exact same thing I was referring to :). Sorry if I used wrong wording.

Re: Export Log to Excel CSV in Smart-1 Cloud

Ayman_Almagairy — Wed, 19 Oct 2022 10:26:36 GMT

does anyone know a way to export more than 1001 entries? I chose to export up to 1 million records, but I got a spreadsheet with 10001 records only

Re: Export Log to Excel CSV in Smart-1 Cloud

PhoneBoy — Wed, 19 Oct 2022 10:41:40 GMT

Don’t use SmartConsole to do the export, do it from SmartView or Infinity Portal.
If you are doing that and it’s not working, raise a TAC case.

Re: Export Log to Excel CSV in Smart-1 Cloud

Tomer_Noy — Wed, 19 Oct 2022 10:55:37 GMT

Exporting logs to csv should indeed be done from SmartView. You can easily access the SmartView logs page directly within the Smart-1 Cloud applications in the Infinity Portal. It is embedded as the Logs View.

Regarding the number of records, there is currently a limitation in Smart-1 Cloud of 1000 logs per export. This is documented in the Known Limitations:
https://sc1.checkpoint.com/documents/Infinity_Portal/WebAdminGuides/EN/Check-Point-SmartCloud-Admin-Guide/Topics-Smart-1-Cloud/Expected-Behavior-and-Known-Limitations.htm

We might re-evaluate and raise this limit in the future.

Re: Export Log to Excel CSV in Smart-1 Cloud

the_rock — Wed, 19 Oct 2022 11:08:00 GMT

@Tomer_Noy and @PhoneBoy are 100% right. I had done it before from Smartview and got 100000+ entries. You need at least R81 for that to work, on both mgmt and gateways, if I recall right.

Re: Export Log to Excel CSV in Smart-1 Cloud

Ayman_Almagairy — Wed, 19 Oct 2022 20:48:15 GMT

Thanks, Tomer,

I also tried to create an API script to export the logs 100 by 100, but I still can't export more than 1001, this is really important for us as we need to review logs for a long period of time

Re: Export Log to Excel CSV in Smart-1 Cloud

PhoneBoy — Thu, 20 Oct 2022 15:14:53 GMT

Please start a new thread in the API/CLI Discussion space with more details about how you are attempting to do this.