由于跟其他业务系统集成,其他系统需要提供SharePoint组里面包含的成员,通过查询,得到如下SQL:
USE [WSS_Content] -- SharePoint网站内容数据库
select b.Title,c.tp_Login,c.tp_Title from dbo.GroupMembership as a
inner join dbo.Groups as b
on a.GroupId = b.ID
inner join dbo.UserInfo as c
on a.MemberId = c.tp_ID