Skip to main content
psniech
Visitor III
May 15, 2024 9:49 AM UTC
Solved

select *

why the formula that allows to get column's names from log:

 

select * from $log ....

 

doesn't work

 

 

 

ozkanaltas
Valued Contributor III
May 16, 2024 1:44 PM UTC

Hi @psniech ,

 

I know I also used that SQL query before on the previous version of FortiAnalyzer.

 

I think they forgot to update the training document. 

 

Actually, I understand why removed this SQL query. Because when you ran that query, FortiAnalyzer was fetching all logs from the log database. This actually means that it puts a load on the device. They have brought this convenience so that this query does not have to be run continuously.

7 replies

ozkanaltas
Valued Contributor III
May 15, 2024 9:59 AM UTC

Hello @psniech ,

 

Can you explain the issue few more words? 

 

You try to write datasets on FortiAnalyzer, right? If you say yes, can you share all SQL queries with us? 

psniech
psniechAuthor
Visitor III
May 15, 2024 10:02 AM UTC

Sorry, it was a problem with the browser. Now is displaying properly column names. Problem solved.

ozkanaltas
Valued Contributor III
May 16, 2024 1:48 PM UTC

In addition, As you can see these screens are from the oldest version of FortiAnalyzer.

 

Because of that, they need to update training documents. :) 

 

image.png

Thought Leadership. Security Summit. Thursday, November 12th, PGA National Resort, Palm Beach Gardens, FL.
Security Operations Summit: Modernize SecOps. Operate AI-Native.AMER: November 4 | 9:00 AM PST. India and SAARC: November 5 | 10:00 AM IST. EMEA: November 5 | 10:30 AM CET. APAC: November 5 | 11:00 AM SGT