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.
IMPORTANT
This tool / script should be used ONLY on installations running the following versions:
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
PROCEDURE
Download the tool / script (see above)
Read the readme.txt which is bundled with ZIP file for usage instructions