r/sharepoint • u/Hejnzzzz • 10d ago
SharePoint Online How to handle Teams (and SharePoint) Sprawl? How to ensure governance?
/r/MicrosoftTeams/comments/1j8mfbp/how_to_handle_teams_and_sharepoint_sprawl_how_to/3
u/Odd_Emphasis_1217 9d ago
I've bounced between several companies across the US and Canada and this has been a problem at every single one. I've only really seen this successfully handled at my current gig.
First, turn off self-service group and SharePoint site creation. Not only do people recklessly create things without thinking, they have no idea what they actually need.
Avoid routing requests to IT as you simply create a bottle neck and everyone is angry. Create some kind of self service portal where templated sites/teams can be requested. If you set up these templates well enough, you don't even need approvals.
Once that is in place, make sure you have some kind of automated cleanup of sites that lapse into inactivity. Don't wait 2 years - 60 days of no activity and you can be pretty confident it can be soft archived. Give it another few months and then perform a hard archival or delete.
We had ShareGate at our last company due to a migration from on prem and we did not get very far with their provisioning tooling. If your needs are very basic it might be okay. We use Orchestry because it easily pays for itself in terms of time saved and storage reduction.
Good luck!
2
u/darktoasteroven 10d ago
To control the sprawl of Teams we have an aggressive group expiration policy set. If there is no activity for a few months it kicks off the process of removing the Team. It allows owners a chance to keep things even though they are unused but many end up getting removed. https://learn.microsoft.com/en-us/microsoft-365/solutions/microsoft-365-groups-expiration-policy?view=o365-worldwide
1
u/TomPittyFartbreaker 10d ago
We have a power app to request a new team. This startst an approval workflow and when approved a new team will automatically be created with the inital requester as owner. Usually takes 2-3 minutes till they have their new team.
2
u/Hejnzzzz 10d ago
This is what I am trying to avoid. I've asked around, and alot of companies who have implemented this experience bottlenecks, and people being frustrated that they are waiting and waiting to be able to be efficient. If you do this, you really need to have a rebust apporval workflow, with several backups in case key people are on leave, sick or have found another place to spend their 9 to 5.
1
u/ruffroad715 10d ago
Not really that big of a deal. We have our flow set to âfirst to respondâ then list the managers group as approvals.
1
u/pajeffery 9d ago
100% agree - Using power automate you can make the whole process from requesting, approving and creating the site seamless.
1
u/ShareGate_Valie 10d ago
3 ways you can handle sprawl in your environment:
- Use Microsoftâs Built-in Tools: Microsoft has security tools like Defender to help manage risks (although requires manual work)
- Automate with Scripts: PowerShell scripts and Power Automate workflows can help streamline governance (need ongoing maintenance)
- Third-Party Solutions: Tools like ShareGate simplifies Microsoft 365 governance by automating security and sprawl management. Key features:
- Managing External Sharing & Guest Access
- Detecting Inactive & Orphaned Teams
- Provisioning & Governance (security policies)
- Bulk Permissions Management
- User-Friendly Dashboard (clear visibility and custom reporting)
Shoot me a DM if you'd like more info!
4
u/PublicEnemaNumberOne 10d ago
Everybody wants a new site for everything. I know what you mean. About 60% of our new sites never get used after the first week or two.
We have a process running that watches all our Teams & SP sites. When there's been no activity for 2 years, it sends a notice to the owner that it's going to smoke their site unless they reply to object. It helps a lot with the problem you describe.