Good day, I have a question. If I make the backup through the shell, can I restore it in another FortiAnalyzer? Also, how would the process change? I am having issues trying to backup, even after setting up about 7 FTP servers and 2 SFTP servers. :(
@@vratos - If you are good with SQL, you can run SQL queries against the log tables. #execute sql-query-generic - Here is an example: #exec sql-query-generic "select tbl_name, pg_size_pretty(space_used) from table_ref order by space_used desc limit 10"
@@goba05 awesome thanks for the example! one last question, where can I see the different tables I can use in the from? "select * from ...." I can't find the list of tables, can you help me please? thanks!
Amigo cómo configuraste el filezilla Server? ... Tb cuando escribes los comandos en el CLI del FAz pq no escribisteis el directorio completo?? Pq según el vídeo solo pusisted / .. me podrías ayudar con estas consultas porfavor pq hecho varios procedimientos guiándome de vídeos o kb y aún así me sale error 🙏🏻🙏🏻
Usa la misma configuración qué muestro en el video, ponle pausa. Es importante generar el certificado, no es tan difícil. En el comando puedes ponerle la ruta o solo la ruta por defecto del FileZilla. Saludos
Thank you very much that was very useful I have noticed something weird but, I am not sure if it applies to everybody I perform a backup for all settings with an FQDN target, however, when I try to transfer the logs to an FQDN it doesn't transfer. Instead, I have to type the IP address instead of the FQDN
@@goba05 Yes it is able to ping the host name What drives me crazy that it works fine with backing up the "execute backup all-settings sftp (server-name) etc.. "😂
Good day, I have a question. If I make the backup through the shell, can I restore it in another FortiAnalyzer? Also, how would the process change? I am having issues trying to backup, even after setting up about 7 FTP servers and 2 SFTP servers. :(
Hi! What is the difference between execute backup log and log-only ???
I recommend to use log, it takes all type of logs. Log-only may exclude event or traffic not all logs.
Awesome Thanks!
Awesome the execute shell, is there any way we can do sql query there?
The only way to run SQL queries is through normal CLI, not shell. Regards
@@goba05 Thanks for the answer! can you tell me please where in the CLI can I run sql query? thanks in advance!
@@vratos - If you are good with SQL, you can run SQL queries against the log tables. #execute sql-query-generic
- Here is an example: #exec sql-query-generic "select tbl_name, pg_size_pretty(space_used) from table_ref order by space_used desc limit 10"
You are awesome!
@@goba05 awesome thanks for the example! one last question, where can I see the different tables I can use in the from? "select * from ...." I can't find the list of tables, can you help me please? thanks!
Amigo cómo configuraste el filezilla Server? ... Tb cuando escribes los comandos en el CLI del FAz pq no escribisteis el directorio completo?? Pq según el vídeo solo pusisted / .. me podrías ayudar con estas consultas porfavor pq hecho varios procedimientos guiándome de vídeos o kb y aún así me sale error 🙏🏻🙏🏻
Usa la misma configuración qué muestro en el video, ponle pausa. Es importante generar el certificado, no es tan difícil. En el comando puedes ponerle la ruta o solo la ruta por defecto del FileZilla. Saludos
Thank you very much that was very useful
I have noticed something weird but, I am not sure if it applies to everybody
I perform a backup for all settings with an FQDN target, however, when I try to transfer the logs to an FQDN it doesn't transfer. Instead, I have to type the IP address instead of the FQDN
Is the FAZ/FMG able to ping FQDN? Maybe is a issue related to DNS
@@goba05
Yes it is able to ping the host name
What drives me crazy that it works fine with backing up the "execute backup all-settings sftp (server-name) etc.. "😂
@@esamalaslmy you need then do it by IP address, there is no other option!