BPS groups extraction by sql command?

0

Hi,

I have no idea, which information you mean, but if you are interested in the group members

SELECT users.COS_BpsID
FROM [dbo].[CacheOrganizationStructure] as users
join [dbo].CacheOrganizationStructureGroupRelations as groupMebers
on users.COS_ID = groupMebers.COSGR_UserID
join [dbo].[CacheOrganizationStructure] as [group]
on groupMebers.COSGR_GroupID = [group].COS_ID
where [group].COS_BpsID= 'bps@group.id'

Best regards,
Daniel