Hello-
I am hitting a wall on figuring out the best way to do this so I would love to hear from others that have figured it out. We have been syncing Groups to sys_user_group (Groups) table from on-prem AD via LDAP sync, for many years. I have been tasked with the requirement to sync groups data (and group members) from Azure AD into the sys_user_group table. We have integrated Azure AD via the Integration Hub spoke and I can see that we have populated group and user data from there.
What is the best way to get the groups from Azure AD into the sys_user_group table? Would it be a scheduled transform from one table to the other? Is there a cleaner way to do this and keep the data in sync between Azure AD, on-prem AD, and ServiceNow? I am having issues finding any up-to-date articles on the topic. TIA!
