We are experiencing storage issues due to the number/size of files our teams are uploading.
Where can I find/create a list of uploaded files and the associated sizes? Can I build a GI?
This information looks to be stored in ‘UploadFileRevisionNoData’ but this doesn’t appear as a table in Generic Inquiries?
Best answer by YasasWithanage76
Hello
Yes. You can create a custom GI to accomplish this requirement. You can use PX.SM.UploadFileRevision DAC and the PX.SM.UploadFile DAC.
As an example please check the attached GI. Based on your requirement you can modify that.
+4Hello
Yes. You can create a custom GI to accomplish this requirement. You can use PX.SM.UploadFileRevision DAC and the PX.SM.UploadFile DAC.
As an example please check the attached GI. Based on your requirement you can modify that.
Thank you, I copied your GI and it worked for me! In the case we are running out of storage, is there a way to either “archive”/export and delete either large files or old files to free up storage?
Hi
If this is a PCS instance the below KB may be helpful.
How to reduce the database size by removing old file revisions | Community (acumatica.com)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
