Answer

DESCRIPTION

This bundle contains scripts which help to remove the folder structure for specific user or all users as well as removing a specific or all empty folders.

Remove_Folder_Structure.sql
Clears the folder structure except for Calendar and File folders. Each email is then associated to either the user's Inbox or Sent folder.
Remove_Folder_Structure_For_User.sql
Clears the folder structure for a specific user except his or her Calendar and File folders.
Remove_Empty_Folder.sql
This script will remove one empty folder located under the 'Inbox' mailbox folder.
Remove_All_Empty_Folders.sql
This script will remove any empty folders located under the 'Inbox' mailbox folder. The 'Inbox' and 'Sent' folders will NOT be removed.

This tool / script should be used ONLY on installations running the following versions:
- GFI Archiver 12.0 - 12.4: 20151222 - 20180528

Please ensure to read the readme.txt bundled with the ZIP file
It is recommended to take a backup of the system incl. data (Archive Stores) before using this tool/script
It is recommended to rebuild the indexes after running the script: failure to do so might cause all indexes where the script was run to fail to validate and trigger auto-rebuild after a version upgrade
Immediately after running the script, if you refresh the browser, the folder structure view should show only inbox and sent items