| Description |
*This issue relates to i21 Help Desk ticket:* [ HDTN-278134 - Framework R&D Enhancements|https://helpdesk.irely.com/iRelyi21live/#/HD/Ticket/?ticket=HDTN-278134]
Track the total storage size of the Attachments and limit the size to 100GB by default. This can be done by running the following query on the Attachments table to get the total size.
SELECT SUM(reserved_page_count * 8.0 / 1024) AS Total_GB_Consumed
FROM sys.dm_db_partition_stats
WHERE object_id = OBJECT_ID('tblSMUpload');
We can check this when a customer logs in or globally on a daily basis and if they have used 90% of the storage, display a message that they have consumed 90% of their total Attachment storage.
When the they consume 100% of the storage, then display a message they have reached the storage limit of 100GB and don't allow them to attach any new files until the limit is increased. If a user tries to attach a file when they have reached 100%, display the same message again.
Include an option in the Company License Registration screen to increase this and make it default to 100 GB for new license registrations.
!pastedImage_d217636_0.png|height=635,width=699!
|