Forum Discussion
Dynamic Group Membership: query tables to determine memberships?
I have a SQL table that lists users and some properties we want to check for determining group memberships.
Is there anyway to query an SQL table, or any other data source (Azure CDS, etc, anything) with the dynamic group queries?
It appears that you can only query AD properties, not look at any other data sources.
Thank you.
1 Reply
- You are correct, dynamic groups are limited to AAD properties - https://docs.microsoft.com/en-us/azure/active-directory/enterprise-users/groups-dynamic-membership#supported-properties
If you want to use SQL data, you could populate assigned groups through the API/Powershell
