Skip to main content
santosh_sai
Level 2
Jul 29, 2016 10:37 AM UTC
Solved

OOTB Reports

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.
kautuk_sahni
kautuk_sahniAccepted solution
Level 9
Aug 1, 2016 11:47 AM UTC

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

3 replies

smacdonald2008
Level 10
Jul 29, 2016 1:46 PM UTC

Please read the AEM documentation on this subject: 

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

Hope this helps... 

Translate
Jitendra_S_Toma
Level 10
Aug 1, 2016 6:08 AM UTC

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.

Translate
kautuk_sahni
kautuk_sahniAccepted solution
Level 9
Aug 1, 2016 11:47 AM UTC

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

Translate
Kautuk Sahni