Sys_User_Grmember group empty Azure AD
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-19-2024 12:25 PM
We are using Azure AD/Entra ID for single sign on (SSO). The group is being created but entries into the sys_user_grmember table has the User but the Group is (empty) and we are also getting duplicate entries in the table. This worked previously but we are now using groups with 50 thousand plus users.
Any ideas on what might be causing this would be greatly appreciated. Please let me know if my information is not clear.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-26-2024 11:48 AM
Check your Transform Map. We have an onAfter script that runs the following:
ldapUtils.addMembers(source, target);
That adds the users to the groups for us. I assume that's an OOTB script include.
As far as it creating duplicate groups, are you coalescing on anything? We are pulling the property "objectGUID" into a custom field and coalescing on that. That's better than doing it based on the names, because we found when we coalesced on the name, if the name changed, it would create a new group instead of updating the existing one.
I hope that helps.