Page Activity Report not display page activity

[varuns46785756]

Hi ,

needs to generate a report to check page data like when pages will be activated & deactivated under a particular hierarchy.I am using OOTB.Please guide me add extra field.

Regards,

[kautuk_sahni · Accepted solution]

Hi

Please have a look at this documentation link:- https://docs.adobe.com/docs/en/cq/5-6-1/administering/reporting.html#Page%20Activity%20Report

//

Another reference article:- http://www.wemblog.com/2011/10/how-to-find-all-pages-modified-or.html

//

How to find all the pages modified or activated after certain time
Use Case: You want to create package of all the nodes modified after certain date and time. This can be use ful in Migration Projects. If you have problem with one of the activation agent and you want to activate pages / Asset to that agent based on time.

Solution: You can use following packages to achieve this use case

You can also refer code form Here

1) Install attached package using package manager
2) Go to http://<host>:<port>/apps/tools/components/listPage.html
3) Select Date and time
4) Then click on submit
5) You can click on create package of modified pages to create package

I hope this would help you.

Thanks and Regards

Kautuk Sahni

[varuns46785756]

Hi Kautuk,

Thanks for reply, now I can able to add extra column in report, I am trying to display page activate and deactivate date/time on report , through the page properties onofftime, but I am not able to fetch the value , please let me know how can I get this value on report.

Regards,

[kautuk_sahni]

Hi 

You can get on and off time for the page :-  http://dev.day.com/docs/en/cq/current/javadoc/com/day/cq/wcm/api/Page.html

Please go through this community article for your reference :- http://wemcode.wemblog.com/on-off-time-behavior-in-cq-aem

//

To get on off time using query

final String now = session.getValueFactory().createValue(Calendar.getInstance()).getString();

final Query q = session.getWorkspace().getQueryManager().createQuery( "/jcr:root/content//*[@offTime > xs:dateTime('" + now + "') or @onTime > xs:dateTime('" + now + "')]",  Query.XPATH);

final QueryResult r = q.execute();

 final NodeIterator iter = r.getNodes();

while (iter.hasNext()) {

                    final Node node = iter.nextNode();

                    final long onTime = node.hasProperty(NameConstants.PN_ON_TIME) ? node.getProperty(NameConstants.PN_ON_TIME).getLong(): 0;

                    final long offTime = node.hasProperty(NameConstants.PN_OFF_TIME) ? node.getProperty(NameConstants.PN_OFF_TIME).getLong(): 0;

}

I hope this would help you.

Thanks and Regards

Kautuk Sahni