WEBCON Tables: BpsUsers & BpsUsersGroupRelations

0

Hello Bjoern,

there's probably a simple reason, you are looking at the BPS_Content database instead of the BPS_Config.
I'm not sure when there are "real" users in this table but BPS Groups are added to the BPSUsers table in the Config database. From there they are synchronized into all content databases using the default user tables:
CacheOrganizationStructure
CacheOrganizationStructureGroupRelations

Here's a little snippet to retrieve all users in the group 'dc_managers'

SELECT COS_DisplayName, COS_BpsID
FROM [dbo].[CacheOrganizationStructure] as users join
[dbo].CacheOrganizationStructureGroupRelations as relations
on users.COS_ID = relations.COSGR_UserID
where relations.COSGR_GroupID in (
SELECT COS_ID
FROM [dbo].[CacheOrganizationStructure]
where COS_BpsID like 'dc_managers'
)



Best regards,
Daniel

Hello Daniel,

thank you very much / vielen Dank.

Perfect solution for my problem.
Now i can use some data tables to display the information and i also have built some "Global Business Rules".

Best regards,
Bjoern