Privileges Access to the application / start workflow - Entra ID Group

0

Hi Ernst,

maybe you can check which users have been resolved for this group in the database.

This could work, but I haven't tested it.

SELECT users.COS_BpsID
FROM [dbo].[CacheOrganizationStructure] as users
join [dbo].CacheOrganizationStructureGroupRelations as groupMembers
on users.COS_ID = groupMebers.COSGR_UserID
join [dbo].[CacheOrganizationStructure] as [group]
on groupMembers.COSGR_GroupID = [group].COS_ID
where [group].COS_DisplayName like '%All_internal_users%'

Best regards,
Daniel

Thanks Daniel,
this gives me all users (as expected).

I am using now a different group and its working. I will check the details (group differences) with my AD admin.

Thanks & Best regards
Ernst