Expand my Community achievements bar.

SOLVED

OOTB Reports

Avatar

Level 2

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. 

1 Accepted Solution

Avatar

Correct answer by
Administrator

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



Kautuk Sahni

View solution in original post

3 Replies

Avatar

Level 9

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.

Avatar

Correct answer by
Administrator

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



Kautuk Sahni