AEM DAM File Reports

Question

Hi,

6.5 SP22 on prem user here.

I am tasked to audit document files (30k+).

My approach is to export a file report, then sort by used who uploaded, then modified. Then send a list of files to the user asking to audit their files.

The challenge here is - I only want to first see the document files that are not referencing to websites.

Question:

1. Can I add a property in the File Report that would display if the file is referencing or not (similar to what Renovator exports)?

2. If above is No, what other report can I use / create that will show: Filepath, Uploader, Modifier, Referencing or Not?

This has to be a UI solution please.

Thanks

BrianKasingli · Accepted Answer

On AEM 6.5 SP22, the out-of-the-box File Report does not include a column to show if an asset is referenced on a website. It only provides metadata like path, uploader, and modifier.

If you must stay UI-only, you can create a Custom Report under Tools → General → Reports, based on the Files Report template. Add a calculated column that checks references via the built-in References tool. This will let you mark each file as “Referenced” or “Not Referenced.”

Try ACS AEM Commons – Reports Builder https://adobe-consulting-services.github.io/acs-aem-commons/features/report-builder/index.html. It allows you to define a DAM report, add fields for Filepath, Uploader, Modifier, and include a scripted “Referenced?” column. You can then export a full CSV for auditing.

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded