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 or file. These records are considered to be orphaned.

• [Alert]
• [Content]
• [Entity]
• [Event]
• [EXIF]
• [ExpandedFile]
• [File]
• [Filename]
• [Free]
• [Image]
• [InvestigationMedia]
• [Location]
• [Log]
• [LogString]
• [Message]
• [MessageAddress]
• [MessageAddress_Message]
• [MessageAddressDescription]
• [MessageSubject]
• [MessagePiece]
• [ReviewItem]
• [Slack]
• [USBDevice]
• [WebsiteVisit]

Delete Media

This will delete the media associated with the id in the message from the database.