-
Suggestion
-
Resolution: Unresolved
-
None
-
None
-
1
-
Problem Definition
For auditing purposes (to potentially reduce the licensed users count), customers may want to use the Crowd REST APIs to generate a list of users and their group memberships for any groups they were added to on or after a specific date. This does not appear to be possible in the current implementation, as the HTTP responses don't include the timestamps that would show when a user was added to a group.
Suggested Solution
In the Crowd Group Memberships API, include the timestamp when the user was added to a group for the 'Search users' GET request.
Why This Is Important
It would help to determine if any users were unintentionally added to certain groups and remove them as needed to reduce the number of licensed users.
Workaround
Query the Crowd database directly like this:
SELECT u.user_name, STRING_AGG(g.group_name, ', ' ORDER BY g.group_name ASC) AS groups FROM cwd_user u JOIN cwd_membership m ON u.id = m.child_id JOIN cwd_group g ON m.parent_id = g.id WHERE m.created_date >= '2024-01-01' GROUP BY u.user_name ORDER BY u.user_name;
If we can get the same results using the REST API, that would avoid having to directly access the database.