Difference between revisions of "Maintenance ETL"
Jump to navigation
Jump to search
| Line 33: | Line 33: | ||
* <code><nowiki>[</nowiki>[[USBDevice Table|USBDevice]]<nowiki>]</nowiki></code> | * <code><nowiki>[</nowiki>[[USBDevice Table|USBDevice]]<nowiki>]</nowiki></code> | ||
* <code><nowiki>[</nowiki>[[WebsiteVisit Table|WebsiteVisit]]<nowiki>]</nowiki></code> | * <code><nowiki>[</nowiki>[[WebsiteVisit Table|WebsiteVisit]]<nowiki>]</nowiki></code> | ||
| + | |||
| + | ==Delete Media== | ||
| + | This will delete the media associated with the id in the message from the database. | ||
Revision as of 14:34, 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 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.
