Component Report

[sugram13]

Anyway where we can pull out the components used in a particular page and get it exported to excel file?

[smacdonald2008]

You can build a tool that queries that information using JCR SQL2 - similar to how we query users here and dump the JCR Data into Excel -- Adobe Experience Manager Help | Developing Java Swing Applications that displays Adobe Experience Ma...

[Amit-Tiwari]

yes you can.

go to miscadmin and create a component report.

for exporting in excel you need little change that you can find here.

FAQ: Export AEM6 Reports to Comma Separated Values (CSV)

[Amit-Tiwari]

Let me know if you need further help

[sugram13]

I had gone through component report earlier as well but the thing about csv export.It is still not working.the link you sent to export to csv ,it is not getting exported.

[Amit-Tiwari]

Its working fine for me.

what problem you are facing?

is it not downloading or there is no data in the exported file.

[sugram13]

it is not downloading ..I can see the response in console on debugging but not getting downloaded.

[sugram13]

it is not downloading ..I can see the response in console on debugging but not getting downloaded.

[Techaspect_Solu · Accepted solution]

Hi,

Please follow the below steps . It worked fine for us -

1) Select your required page to see component report at http://localhost:4502/etc/reports/compreport.html

2) Now hit the below URL. It gives you JSON output.

http://localhost:4502/etc/reports/compreport/jcr:content/report.data.json

3) Copy paste the generated JSON output at below URL and click on JSON to excel

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

You should be generating excel report now.

We hope this information helps!

Regards,

TechAspect Solutions