topic Re: default file path for exported CSV file from Smart view in Firewall and Security Management

default file path for exported CSV file from Smart view

tetemkegebre — Tue, 25 Apr 2023 11:49:47 GMT

Dears,

I have tried to export CSV file from Smart view .but I am unable to get the exported CSV file.

where is the default path for the downloaded file.

Re: default file path for exported CSV file from Smart view

G_W_Albrecht — Tue, 25 Apr 2023 12:11:29 GMT

SmartView Web page lets you export csv - but you have to wait until the export file is ready on SMS/Logserver and you get a download button:

Re: default file path for exported CSV file from Smart view

the_rock — Tue, 25 Apr 2023 12:45:53 GMT

As Guenther said, you would need to wait until it shows you option to download it, thats basically it : - )

Andy

Re: default file path for exported CSV file from Smart view

Gingerwerewolf — Fri, 21 Mar 2025 10:55:43 GMT

Hi

That pop up can sometimes take ages to pop up. Im talking 10 minutes

And, it only pops up for 10 Seconds so it is very easy to miss

Is this file stored, so that I can retrieve it from the SMS that Im connected to, should I miss it.

In fact, I would say that the pop up is rather annoying method.

Re: default file path for exported CSV file from Smart view

Gingerwerewolf — Fri, 21 Mar 2025 10:56:07 GMT

Sorry for any thread necromancy

Re: default file path for exported CSV file from Smart view

the_rock — Fri, 21 Mar 2025 11:29:38 GMT

You are absolutely correct @Gingerwerewolf , times do vary, for sure, at least from my experience. Let me test this in R82 lab and see if its any different.

Andy

Re: default file path for exported CSV file from Smart view

Gingerwerewolf — Fri, 21 Mar 2025 11:38:33 GMT

OK abit of searching myself and I have answered my own question - however it is a bit hidden

So the csv files are generated and then zipped up in a subfolder of the following:

/opt/CPrt-R81.20/smartview/exported_files

however you need to go deeper, and that I assume is unique to both the SMS in question and the User

There is a folder in the above link that has a String of what looks like Hex in an 8-4-4-4-12 character length

Then inside that folder, there is another Folder (which I would assume is which username requested the csv) that folder is in a 8-4-4-4-13 character length

Then inside those folders are zip files and there are named with date and time stamps. These appear to be the files.

Hope this helps others

Re: default file path for exported CSV file from Smart view

Gingerwerewolf — Fri, 21 Mar 2025 11:51:20 GMT

Thanks! See my other posts - if you could confirm my findings that would be ace!

Re: default file path for exported CSV file from Smart view

the_rock — Fri, 21 Mar 2025 12:16:43 GMT

Learned something new today, never knew where those files were stored, thank you @Gingerwerewolf 👍👌

Btw, I attached the file I got from the lab and it took literally 5 seconds to generate one for 24 hours. I tried 3 months time period and that took about 35 seconds, which makes sense, since its longer span, if you will.

[Expert@R82:0]# pwd
/opt/CPrt-R82/smartview/exported_files/41e821a0-3720-11e3-aa6e-0800200c9fde/6f42f104-d586-49c2-acfe-c0386b0dc704
[Expert@R82:0]# ls
Logs_Mar_21__2025_08_11_18_675_AM.zip
[Expert@R82:0]#

Andy

Re: default file path for exported CSV file from Smart view

Gingerwerewolf — Sun, 23 Mar 2025 07:41:15 GMT

Awesome! Thank you too!

Ive also found, that, unsurprisingly it depends on how the SMS or Log server is doing at the time. The same log files took significantly less time on a dedicated log server in my environment, than the actual SMS

Re: default file path for exported CSV file from Smart view

the_rock — Sun, 23 Mar 2025 12:05:33 GMT

Absolutely, that can affect it.

Andy

Re: default file path for exported CSV file from Smart view

Amir_Senn — Sun, 23 Mar 2025 13:25:14 GMT

You can go in the SmartConsole/Smartview webapp to "New Tab" => "Archive"

It contains all exported operations and you can download it any time: