Skip to main content
psniech
Visitor III
May 15, 2024
Solved

select *

  • May 15, 2024
  • 2 replies
  • 3465 views

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

 

select * from $log ....

 

doesn't work

 

 

 

Best answer by ozkanaltas

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.

2 replies

ozkanaltas
Esteemed Contributor III
May 15, 2024

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

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

ozkanaltas
Esteemed Contributor III
May 16, 2024

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