DAM Asset reports - how many assets modified by a specific user?

[PovEim]

Hi Team,

I am working with 6.5 on-prem AEM DAM. 

I need to create a report which would show me how many images / documents have been processed by a specific user if such is possible?

Scenario - I, as a DAM Librarian, have been adding / correcting metadata to hundreds of files across many folders. For my end of the year report I need to know how many such files I have processed. Currently I use "Modification report". Is there a better way available perhaps?

Also, is there a way to find out how many files have been deleted? (may be in the logs?) 

Many thanks

[VishalKa5 · Accepted solution]

Hi @PovEim ,

Modified Assets Count:

Best Approach: Use Asset Search with Filters

• Go to Assets Console > Advanced Search
• Filter: Modified By = your username
• Date Range = your reporting period
• Result count shows total assets modified
• Export results to CSV for documentation

Alternative: Disk Usage Report

• Tools > Assets > Reports > Disk Usage
• Filter by your username and date range
• Export to CSV with asset details

Why this works: Tracks all metadata changes and modifications you've made, exactly what you need for your librarian report.

Deleted Assets Count:

Check Audit Logs

• Location: /crx-quickstart/logs/audit.log
• Search for delete events by your username
• Command: grep "deleted" audit.log | grep "your-username"
• Count entries within your date range

Enable for Future Tracking

• Tools > Operations > Web Console
• Search: "Day CQ DAM Event Recorder"
• Enable comprehensive audit logging
• Future deletions will be properly tracked

Quick Solution for Your Report:

1. Run Asset Search with your username filter → get modified count
2. Check audit.log for deletion entries → get deleted count
3. Export both for your annual report

Note: Enable audit logging now for easier tracking next year.

Thanks,

Vishal

[PovEim]

Hi @VishalKa5 ,

This is exactly what I was after - thank you! 🙂 

Love the step by step too!

Have a great day