Forum Discussion
Create a list of SharePoint Groups containing a specific member.
We've run into this a couple of times now. We have more than 300 SharePoint groups in our site collection. When we have staff turnover, we would like to remove that person from all the groups of which they are a member. Is there a quick way to generate a list of groups containing a specific member?
Have a look at something like a free trial of Sharegate which can help you with this. It is not just a migration tool but great for this kind of scenario.
You can use PnP-PowerShell cmdlets to help you achive this. Here is the link to the Remove-PnPUserFromGroup cmdlet and Get‑PnPGroup cmdlet.
- Paul, can you share with me some of the third party tools that can do this?
- No easy way to get this information, you will need programming skills to get it or buy a third party tool that can help you with this...by the way: Have you considered to use security groups / Office 365 groups for your scenario?
- When you say security groups, you mean Active Directory? We looked at that last year as an option and it was decided to only do SharePoint groups at that time. Our company does not yet have Exchange Online and so Office 365 Groups are not available to us yet, but we expect that to come in toward the end of the year. Can you give me a heads up as to where I can find the "list of groups" for which a person is a member at that time?
