在 AllUserData table 中查找 "people or group"

 

SELECT     *

FROM        UserData INNER JOIN

                      UserDataJunctions ON UserData.tp_LeafName = UserDataJunctions.tp_LeafName AND UserData.tp_DirName = UserDataJunctions.tp_DirName AND 

                      UserData.tp_SiteId = UserDataJunctions.tp_SiteId INNER JOIN

                      UserInfo ON UserData.tp_SiteId = UserInfo.tp_SiteID AND UserDataJunctions.tp_Id = UserInfo.tp_ID

WHERE     (UserData.tp_DirName like '%Lists/Backup Owner%')AND (UserData.tp_DeleteTransactionId 

NOT IN(SELECT  DeleteTransactionId FROM dbo.RecycleBin))and tp_IsCurrent=1