Smart Console Log Export without SmartEvent

[00071491]

Hi All,

Running a Clustered pair of 5600 appliances on R80.40.

From SmartConsole > Logs & Monitoring, I filter down a log using the following for the last 30 days:  

user:username blade:"URL Filtering" 

I want to export the results using Menu > File > Export to Excel CSV, but I'm only given a few results in the file.  From SmartConsole I can keep scrolling and see all of the results as intended.  I don't see the same numbers of results in the CSV. 

We don't have Smart Event activated to get a report in that manner.  Unsure if that's a licensing fee to add that?

Any ideas on the best way to generate 30-days of URL Filtering results for a user?

Rory 

[K_montalvo]

Hello

I tried it the same way than you and got the exact results that's shows up on the Logs and monitoring tab. What application are you using to open the .csv exported file?

[00071491]

Using Microsoft Excel to view the CSV....in your search results...scroll down to show more results then export.  You'll find everything you scrolled passed will be blank lines in your CSV file and only show you the logs for what's visible in the GUI window.

[PhoneBoy · Accepted solution]

https://mgmt-ip/smartview

From there you can export up to a million log entries.
The fact you can only export the visible log lines from SmartConsole is a known limitation.

[00071491]

Good to know on the known limitation.  I'll try the link you provided using our mgmt IP.  We only have read-only access to our management and log servers, but I'll report back tomorrow on results.  Thank you.

[the_rock]

@PhoneBoy is 100% correct. I actually exported logs from my lab mgmt for 3 months and it had about 500000 lines.

Andy

[00071491]

Thank you again.  Going through the web worked like a charm!