File attachment folder structure
We recently migrated servers with success except for the file attachments. It appears that whenever a new attachment is added as either a request or purchase order, the system is automatically creating a new subfolder called fileAttachment. It has reached the limit of the operating system and will now not store any further documents. When I try to change the default location in the Self-Service Portal setting, it will start the migration process and then stop due to the character limit of the file structure.
Is there a script I can run against the SDeskAttachment table to update this to a new folder I have created? I also need to be able to update the default location but I'm not sure where that is stored.
Since I know many of the attachments are lost, I can try and restore some from a backup but any help would be greatly appreciated.
Currently on ServiceDesk Plus 9.3 Build 9314.