Maintenance ETL

From truxwiki.com
Revision as of 13:58, 25 July 2022 by Sam (talk | contribs) (Created page with "The Maintenance ETL is tasked with performing long running tasks. These tasks can take a significant amount of time and cause the Analyst Desktop to become unresponsive. =Tas...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

The Maintenance ETL is tasked with performing long running tasks. These tasks can take a significant amount of time and cause the Analyst Desktop to become unresponsive.

Tasks Performed

Maintenance is responsible for the following tasks.

Clean Database

When Maintenance cleans a database, it will determine if there are any records in the following tables that do not belong to any media.

  • File
  • Filename
  • Slack
  • Entity Strings
  • Expanded Files
  • Message Address Message
  • Message Address
  • Meddage Piece
  • Message Subjects
  • Message Address Descriptiosn
  • Investigation Media
  • Log
  • Log Strings
  • Content