Brand Portal Collections Reporting

[BeckyFl1]

Is there a way to run reporting to find all of the assets that are currently in a Brand Portal collection?  I need to move a large number of assets in AEM, but I obviously need to unpublish them from the brand portal first and doing that removes them from the collection.  If I have a list that I can reference I'll be able to restore collections when I have finished the moves.

[abhishekanand_ · Accepted solution]

Hi @BeckyFl1 

Option 1:

To get a report of all assets currently in a Brand Portal collection, you can use AEM’s CSV Asset Exporter tool or a custom script to generate a list.

Go to Tools > Assets > Reports in AEM.

Configure Export Options:
Export CSV:

Option 2: Use a Custom Query or Script
If Brand Portal collections are tagged or identifiable through metadata, you can use a custom query to list assets:

Create a Query Using Query Builder:

In AEM, use the Query Builder API or JCR SQL2 to search for assets with specific properties indicating Brand Portal association.
Run the Query:

Run the query through a custom Sling servlet or Groovy script to fetch assets in collections and output the results in a readable format (like JSON or CSV).