Real World SharePoint: Managing Security

It’s been a while since my last blog post, mainly because I’ve been busy writing blog post for our corporate blog, go check it out!

For this blog post, I wanted to give some love to Sharegate.

We believe that any SharePoint endeavor should consist of:

  • 80 % user adoption
  • 15 % great architecture
  • 5 % of those tech dudes doing their magic (great work guys!)

But part of the “user adoption” is also getting your power users and administrators adopted. And not just for migrating data from older SharePoint versions or file shares, but also to manage your SharePoint farm or tenant.

Today, I want to stress on that last aspect with a short but very useful side of Sharegate, “Reporting”. You may think that this kind of dull graphic won’t help manage SharePoint at all. But you’re wrong.

The case for Sharegate Reporting

Let’s start with the use case.

Like all great SharePoint security architects (cough), SharePoint security is set up with SharePoint groups. This is an on premise SharePoint, so no Office 365 Groups here. So I have 4 security groups per site collection set up:

  • “Administrators” – or – “Administrators of Finance” (and others)
  • Owners
  • Members
  • Visitors

Now, my client asks me if I can add an administrator in all 33 of their site collections.

Off to the battlegrounds

My first thought was to fire up Sharegate to try to do this. I just opened the Reporting section, created a new Report and selected “SharePoint Group” as the object type I want to search for and added a filter and an extra column to my results:


When executing the report, we got every site collection that has a group named like that (in just a few seconds by the way):


When you select all groups and click “Edit” you can actually add and remove group members (with no duplicates as a result!):


How about that for quick changes to SharePoint security! I need at least 10 clicks to add a user to a group in a site collection, that makes for 330 clicks saved today (and Sharegate only took me about 20). I wrote this blogpost with the time Sharegate saved for me!

Interested in knowing more about Sharegate’s superpowers? Contact us!


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s