Dynamic Group Membership: query tables to determine memberships?

Copper Contributor

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#s...

If you want to use SQL data, you could populate assigned groups through the API/Powershell