AEM DAM File Reports

[PovEim]

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 solution]

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.

[PovEim]

Thanks @BrianKasingli for your answer and the lead to github. This looks like a powerful tool that I will have to learn how to use. 

Do you by any chance know which property does Reference sit under? I assume it is jcr: , but what is the correct term?

Thanks