Skip to main content


User Admin Console (Classic UI) & Crashing Browsers

As businesses grow, the number of end users and groups in Adobe Experience Manager (AEM) tends to increase as well. I recently worked with two clients who are synchronizing users and associating users to the groups through the custom sync handlers to CRX (the content repository in AEM).
Business Analysts (BA) or AEM Admins use the User Admin console and CRX/DE Lite to debug user- or group-related issues. Due to large number of users and groups, when we do a search for a user or group, sometimes it’ll cause the browser to crash. This issue is known to occur with various browsers.
What are the alternative ways to find the user attributes and group information? Query Builder and SQL2 queries come in handy to help you find basic information of the users and groups. Below are two sample queries.
1. Find all attributes of users.
To verify that all attributes have been synchronized correctly through a custom sync handler, we can use the following query:

(click the image to enlarge it)
2. Find all the groups the user is associated with.
Users are associated to groups to view permission-sensitive contents. Group names are used as CUG (Closed User Groups) on the page to allow users to view the page.  To verify whether a user is associated to correct group, we can use the following query.

(click the image to enlarge it)
Alternatively, the equivalent SQL2 query can be executed in CRX/DE Lite query tool:
SELECT * FROM [rep:Group] AS s WHERE ISDESCENDANTNODE([/home/groups]) AND s.”rep:members” = CAST(‘uuidvalue’ AS WEAKREFERENCE)
SELECT * FROM [rep:Group] AS s WHERE ISDESCENDANTNODE([/home/groups]) AND s.”rep:members” = CAST(‘9253def2-e0b5-3b5c-ad02-0f7d79848d83’ AS WEAKREFERENCE)

(click the image to enlarge it)
Based on the above sample queries, you can build more complex queries to debug user- and group-related issues. AEM’s Query Builder and CRX/DE Lite query tool with JCR query language can save you time and resources when you are exploring CRX repository.
Hopefully, this gives couple of workarounds for BAs and Admins to get the information needed when experiencing browser crashes. Please leave a comment below if you have any questions or need any help with this.

Thoughts on “User Admin Console (Classic UI) & Crashing Browsers”

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Prakash Venkatesh

Prakash Venkatesh is a certified Adobe Experience Manager and Senior Technical Architect at Perficient. He has successfully delivered software applications for customers across e-commerce, retail, automotive, manufacturing, and product development. He brings a combination of best practices and problem-solving skills to the table with experience gained over years of working in the IT industry.

More from this Author

Follow Us