How to Report on OneDrive for Business Storage, Sharing, and Departing Users with PowerShell
Track storage trends, audit sharing links, and handle OneDrive content for departing users in one repeatable workflow.
OneDrive for Business is one of the most heavily used services in Microsoft 365 — and one of the most overlooked from a governance standpoint.
Storage usage grows quietly. Sharing links accumulate. And when someone leaves the organization, their OneDrive content can become orphaned data that nobody is tracking.
Each of those concerns is solvable with PowerShell, but most admins end up writing the same scripts over and over for each request.
Common OneDrive admin questions
Admins regularly need to answer:
- Which users are using the most storage?
- Where do active sharing links exist?
- Are there sites with broad external sharing?
- What happens to a user's OneDrive after they leave?
- Has access been preserved or transferred to a manager?
Why the offboarding piece matters
When users are deprovisioned, their OneDrive may be retained for a configured period, but during that window someone usually needs to access or migrate the content.
Doing this consistently is much easier when it is part of a defined workflow rather than handled differently every time.
How PSForge helps
PSForge gives you the building blocks to audit storage, export sharing links, and handle departing-user OneDrive scenarios as one structured PowerShell workflow that can be reused across HR-driven offboarding events.
Example OneDrive workflow
- Export OneDrive storage usage by user
- Identify accounts approaching quota
- Export sharing link data per OneDrive site
- Identify departing users from a list or query
- Grant manager access to the user's OneDrive
- Apply retention or hold settings where appropriate
- Generate a report of all actions for audit
Final thoughts
OneDrive deserves the same governance attention as SharePoint, Teams, and Exchange.
PSForge helps you give it that attention with a repeatable PowerShell workflow that handles storage, sharing, and offboarding in one place.