Skip to main content
ryeh028
New Member
April 21, 2022
Solved

FortiAnalyzer 7 analytic data

  • April 21, 2022
  • 2 replies
  • 1918 views

We recently conducted an internal penetration test and the testing machine generated 20 times more messages on our analyzer.  I have already deleted log files, however, is there a way to delete the messages generated by that PEN test machine from the analytic database?  Thanks!

Best answer by Debbie_FTNT

Hey ryeh028,

there is no way to delete entries from the analytic database directly.

The only way to remove those log messages is to first delete them from archive logs, and then rebuild the database:

-> this will discard the current database with the logs in question

-> the new database will be rebuilt based on archive logs (where the logs in question were already removed)

-> the new database should not contain the logs in question

KB on rebuilding a database: https://community.fortinet.com/t5/FortiAnalyzer/Technical-Tip-FortiAnalyzer-SQL-database-delete-and-rebuild/ta-p/193883

2 replies

Debbie_FTNT
Staff & Editor
Staff & Editor
April 22, 2022

Hey ryeh028,

there is no way to delete entries from the analytic database directly.

The only way to remove those log messages is to first delete them from archive logs, and then rebuild the database:

-> this will discard the current database with the logs in question

-> the new database will be rebuilt based on archive logs (where the logs in question were already removed)

-> the new database should not contain the logs in question

KB on rebuilding a database: https://community.fortinet.com/t5/FortiAnalyzer/Technical-Tip-FortiAnalyzer-SQL-database-delete-and-rebuild/ta-p/193883

ryeh028
ryeh028Author
New Member
April 22, 2022

Thank you!

 

Randy

Thought Leadership Security Summit. Outpace New Threats with AI - enhanced defense. Tuesday, Septmeber 15, 8:30 AM - 2:30 PM PT. The Golf Club at Newcastle, WA.
Fortinet Flag the Hack. Wednesday, August 26, 9:00 AM - 5:00 PM ET, COSM, Atlanta, GA.
Virtual event | September 2026. SASE summit. The age of autonomous trust. Register here!