Fetch report for all the authoring changes made to a particular page in AEM for a selected date range in AEM 6.5

[arindam6600]

My goal is to write a custom code/query which will fetch and show the components that were changed/modified and if any new component has been added or if an existing component has been deleted for a certain page for a selected date range. Any ideas/suggestions with any possible code snippet is highly appreciated. Thanks!

[narendragandhi · Accepted solution]

Hi @arindam6600 

This feature is already available in ACS Commons audit log search - https://adobe-consulting-services.github.io/acs-aem-commons/features/audit-log-search/index.html

Have you already explored it and do let us know for any feedback or issue you might see with it.

Thanks

Narendra

[arindam6600]

I have already created an audit log oak index but still I see this when running the tool. All the properties are set to true.

[narendragandhi]

Hi @arindam6600 

I had to make few updates to the index to make it work (main definition) - 

(cq:path node)

The index definition might need to be updated to include additional properties being included in search. Below screenshot covers what a cq:AuditEvent looks like to show all fields -

Can you try and confirm if it works for you.

[arindam6600]

Hi @narendragandhi - I modified the properties as per your recommendations but I still see the error.

main definition :

cq:path node

/var

For ease of understanding, I am uploading the package here : acs-aem-commons-audit-log-oak-index-4.8.6. Can you please modify this and send me over?

[kautuk_sahni]

@arindam6600 Did you find the suggestions from users helpful? Please let us know if more information is required. Otherwise, please mark the answer as correct for posterity. If you have found out solution yourself, please share it with the community.

[arindam6600]

Hi @kautuk_sahni - I'm still facing issues after modifying the indexes and I've furnished those details in the comment above. Waiting for @narendragandhi's expertise to get this up and running. Thanks!

[narendragandhi]

Hi @arindam6600  Try with this updated index defintion - https://drive.google.com/file/d/1fqhD_ukI7S3rXXj-2nDFBGfqmWPPFrkQ/view?usp=sharing

I tested in my local and is seem to work fine.

Thanks

Narendra

[arindam6600]

Thanks @narendragandhi! This works. You're awesome.

[arindam6600]

Hi @narendragandhi - I have encountered a unique issue wherein although the search runs fine and says success the logs don't appear. Any suggestions/advice on how to mitigate this?