: Upload JSON-based "site scripts" to programmatically apply themes or list templates when new sites are created.
The following script identifies all site collections in your tenant and sorts them by the percentage of storage quota used: powershell
: Generate detailed Excel or Markdown reports of your tenant's entire site architecture and guest activity. Best Practices for Running Scripts sharepoint powershell scripts
: Automate adding hundreds of users to specific groups and sites using a CSV file.
# Connect to your SharePoint Admin Center Connect-SPOService -Url "https://sharepoint.com" # Retrieve site usage and sort by descending current storage usage Get-SPOSite -Limit All | Select Url, StorageUsageCurrent, StorageQuota, ` @ Name = '% Used'; Expression = '0:P2' -f ($_.StorageUsageCurrent / $_.StorageQuota) | ` Sort-Object StorageUsageCurrent -Descending Use code with caution. Copied to clipboard Essential Admin Scripts : Upload JSON-based "site scripts" to programmatically apply
: Track file activities, external sharing links, and permission changes to protect confidential data.
To manage SharePoint effectively, you can use the to run scripts for batch operations like site creation, user management, and storage reporting. Sample Script: Storage Usage Report # Connect to your SharePoint Admin Center Connect-SPOService
Commonly used scripts for SharePoint administration include: