Yes it is possible. All the activation/deactivation actions are stored as audit events under /var/audit/com.day.cq.replication folder.
You can use page Activity Report (/etc/reports/auditreport.html) to list all activations.
In order to do that either create a new instance of report or modify existing one by setting 'Root path' to /var/audit/com.day.cq.replication
You can also write custom scripts using CQ5 Groovy console - https://github.com/Citytechinc/cq5-groovy-console
Thanks for the info. I tried creating a copy of Page Activation Report by setting root path to /var/audit/com.day.cq.replication.
To test it, I activated a content and ran the report. It is showing past data but not the latest one that I activated.
I am new to CQ. I am not sure how to use it exactly. When I click on "Finish", it throws an alert saying "The report doesn't contain any grouped colums. Please ensure atleast one column is grouped before clicking Finish"
Also, let me explain what exactly I am trying to achieve. I want to pull an hourly list of content that is published and send it through email.
Any further info that you can provide will be of great help.
Thanks in advance.
You can implement cron-like OSGi Service, see http://sling.apache.org/site/scheduler-service-commons-scheduler.html for example, and use JCR Query capabilty to retrieve list of activated pages.
The equivalent SQL query would be something like below:
select * from cq:AuditEvent where cq:type = 'Activate' and cq:time > 'YYYY-MM-DD'