Retrieve the ACL and the number of users in the group in SharePoint, using pointacl

Retrieve the ACL and the number of users in the group in SharePoint, using pointacl

Retrieve the ACL and the number of users in the group in SharePoint

1. Number of obtained ACLs:

Select COUNT (ra. PrincipalId) as [Count], p. ScopeUrl
From [WSS_Content_80]. [dbo]. [RoleAssignment] ra with (nolock)
Join [WSS_Content_80]. [dbo]. [Perms] p with (nolock) on p. SiteId = ra. SiteId and p. ScopeId = ra. ScopeId
Group by p. ScopeUrl
Order by [Count] desc

2. Obtain the number of users in the group:

Select COUNT (m. MemberId) as [Count], g. Title as [Group-Title]
From [WSS_Content_80]. [dbo]. [GroupMembership] m with (nolock)
Join [WSS_Content_80]. [dbo]. [Groups] g with (nolock) on m. GroupId = g. ID and m. SiteId = g. SiteId
Group by g. Title

Order by [Count] desc

Adding the AD Security Group permission to the Sharepoint user group in Sharepoint2010 is not controllable.

This is indeed a problem with sharepoint and ad caching. I remember there is a service in sharepoint that is synchronized with ad. After opening the service, set the automatic running time and run it. I have also encountered this problem before. We set the customer to run this service once a day, which is acceptable to customers in a day.

What is a domain group in sharepoint? What is the difference between it and the user group?

The domain group can be viewed as a user in sharepoint, but all users in the domain group have the permissions of the domain group in SharePoint,
The domain group can be added to the sharepoint user group. At the development level, the user can be judged in the user group, but the user cannot be judged in the domain group in the user group.