OOTB Reports | Community
Skip to main content
santosh_sai
New Participant
July 29, 2016
Solved

OOTB Reports

  • July 29, 2016
  • 3 replies
  • 1067 views

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. 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by kautuk_sahni

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=&start=0

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

3 replies

kautuk_sahni
kautuk_sahniAccepted solution
Employee
August 1, 2016

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=&start=0

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

Kautuk Sahni
Jitendra_S_Toma
New Participant
August 1, 2016

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.

smacdonald2008
New Participant
July 29, 2016

Please read the AEM documentation on this subject: 

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

Hope this helps...