SQL Script to get the size in GB used by customer documents module.

To get the size of space used for documents by a customer run this script on their database.

select round( ( (select isnull(SUM(isnull(DATALENGTH(ObjectivesFile),0)),0) from EmployeeObjectives) + (select isnull(SUM(isnull(DATALENGTH(RemunerationFile),0)),0) from EmployeeRemuneration) + (select isnull(SUM(isnull(DATALENGTH(CertificatesFile),0)),0) from EmployeeCertificates) + (select isnull(SUM(isnull(DATALENGTH(AppraisalFile),0)),0) from EmployeeAppraisal) + (select isnull(SUM(isnull(DATALENGTH(DisciplinaryFile),0)),0) from EmployeeDisciplinary) + (select isnull(SUM(isnull(DATALENGTH(DocumentsFile),0)),0) from EmployeeDocuments) + (select isnull(SUM(isnull(DATALENGTH(QualificationFile),0)),0) from EmployeeQualifications) + (select isnull(SUM(isnull(DATALENGTH(DocumentFile),0)),0) from EmployeeOnboardingDocuments) + (select isnull(SUM(isnull(DATALENGTH(FileContent),0)),0) from CompanyDocumentAttachments) + (select isnull(SUM(isnull(DATALENGTH(DocumentFile),0)),0) from ClockingActivityDocuments) ) / 1073741824.0, 3) as TotalDocumentsSpace