Maintenance ETL

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