Difference between revisions of "Maintenance ETL"
Jump to navigation
Jump to search
| Line 7: | Line 7: | ||
==Clean Database== | ==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. | When Maintenance cleans a database, it will determine if there are any records in the following tables that do not belong to any media. | ||
| + | * <code>[Alert]</code> | ||
| + | * <code>[Content]</code> | ||
| + | * <code><nowiki>[</nowiki>[[Entity Table|Entity]]<nowiki>]</nowiki></code> | ||
| + | * <code><nowiki>[</nowiki>[[Event Table|Event]]<nowiki>]</nowiki></code> | ||
| + | * <code><nowiki>[</nowiki>[[EXIF Table|EXIF]]<nowiki>]</nowiki></code> | ||
| + | * <code><nowiki>[</nowiki>[[ExpandedFile Table|ExpandedFile]]<nowiki>]</nowiki></code> | ||
* <code><nowiki>[</nowiki>[[File Table|File]]<nowiki>]</nowiki></code> | * <code><nowiki>[</nowiki>[[File Table|File]]<nowiki>]</nowiki></code> | ||
| − | * Filename | + | * <code>[Filename]</code> |
| − | * | + | * <code>[Free]</code> |
| − | * | + | * <code>[Image]</code> |
| − | * | + | * <code>[InvestigationMedia]</code> |
| − | * | + | * <code><nowiki>[</nowiki>[[Location Table|Location]]<nowiki>]</nowiki></code> |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
* <code><nowiki>[</nowiki>[[Log Table|Log]]<nowiki>]</nowiki></code> | * <code><nowiki>[</nowiki>[[Log Table|Log]]<nowiki>]</nowiki></code> | ||
| − | * | + | * <code>[LogString]</code> |
| − | * | + | * <code>[Message]</code> |
| + | * <code>[MessageAddress]</code> | ||
| + | * <code>[MessageAddress_Message]</code> | ||
| + | * <code>[MessageAddressDescription]</code> | ||
| + | * <code>[MessageSubject]</code> | ||
| + | * <code>[MessagePiece]</code> | ||
| + | * <code>[ReviewItem]</code> | ||
| + | * <code>[Slack]</code> | ||
| + | * <code><nowiki>[</nowiki>[[USBDevice Table|USBDevice]]<nowiki>]</nowiki></code> | ||
| + | * <code><nowiki>[</nowiki>[[WebsiteVisit Table|WebsiteVisit]]<nowiki>]</nowiki></code> | ||
Revision as of 14:30, 25 July 2022
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.
[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]
