Assets Reports

AEM Assets provides an enterprise level reporting framework that scales for large repositories through an intuitive user experience.

Microsoft Excel Formulas

The following formulas are used in the video to generate the Assets by Size chart in Microsoft Excel.

Asset size normalization to bytes

=IF(RIGHT(D2,2)="KB",
      LEFT(D2,(LEN(D2)-2))*1024,
  IF(RIGHT(D2,2)="MB",
      LEFT(D2,(LEN(D2)-2))*1024*1024,
  IF(RIGHT(D2,2)="GB",
      LEFT(D2,(LEN(D2)-2))*1024*1024*1024,
  IF(RIGHT(D2,2)="TB",
      LEFT(D2,(LEN(D2)-2))*1024*1024*1024*1024, 0))))

Asset count by size

Less than 200 KB

=COUNTIFS(E2:E1000,"< 200000")

200 KB to 500 KB

=COUNTIFS(E2:E1000,">= 200000", E2:E1000,"<= 500000")

Greater than 500 KB

=COUNTIFS(E2:E1000,"> 500000")

Additional Resources

Download All Assets Excel File with Chart