SharePoint【学习笔记】-- 查询SharePoint用户组有哪些成员

由于跟其他业务系统集成，其他系统需要提供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