OOTB Reports

[santosh_sai]

How Do i view the page activity report, component report by date wise?
Is there any way to export the same report in CSV format?

Please help me. 

[smacdonald2008]

Please read the AEM documentation on this subject: 

https://docs.adobe.com/docs/en/aem/6-1/administer/operations/reporting.html

Hope this helps... 

[Jitendra_S_Toma]

Santosh Sai wrote...

How Do i view the page activity report, component report by date wise?
Is there any way to export the same report in CSV format?

Please help me. 

AEM Report especially Activity report provides basic details however there is a grid where you can apply sorting/filtering data.

[kautuk_sahni · Accepted solution]

Hi 

As mentioned by Jitendra you can do sorting/Filtering as this is Grid View. 

Option 1:-

On top of "page", "Type", "User" and "time" go and click on it, there you will get sorting and filtering options.

Option 2:-

One more way to do so is, as this response is coming in Json format, you can check all the networks calls and find the request call for it.

The Query to find out this data in our case is:- http://localhost:4502/etc/reports/auditreport/jcr:content/report.data.json?dir=ASC&limit=100&sort=&s...

Here Json->Hits will give you data.

Once you have Json with you, you can convert it to CSV very easily.

Link:-https://konklone.io/json/

Link:- http://www.convertcsv.com/json-to-csv.htm

I hope this would help you.

Thanks and Regards

Kautuk Sahni