OOTB Reports | Community
Skip to main content
santosh_sai
santosh_sai
Level 2
July 29, 2016
Solved

OOTB Reports

  • July 29, 2016
  • 3 replies
  • 1075 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

smacdonald2008
smacdonald2008
Level 10
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... 

Jitendra_S_Toma
Jitendra_S_Toma
Level 10
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.

kautuk_sahni
Community Manager
kautuk_sahniCommunity ManagerAccepted solution
Community Manager
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
Terms & ConditionsAccessibility statement

Loading footer...