Forum Discussion
- Ey Dean: Do you mean the site usage report in the Office 365 Admin Center?
- Dean_GrossSilver Contributor
Yes
I am not sure what your reporting requirements are, but this simple PowerShell script produces some great information about sites, and owners such as Sharing Capability, Status, Last Content Modified Data, Current Storage Usage, Storage Quota, Resource Usage Average, etc...
Just substitute your tenant name in two places where the "YourTenantName" tag: exist
$AdminUrl = "https://<YourTenantName-admin.sharepoint.com/"
$Credentials = Get-Credential -UserName $username -Message "Please Enter Password"
#$SPOCredentials = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($Credentials.UserName, $Credentials.Password)#----------------------------------------------------------------------------------------
#Retrieve all site collection info
#Connect-SPOService -Url $AdminUrl -Credential $CredentialsConnect-SPOService -Url https://<YourTenantName>-admin.sharepoint.com -credential $Credentials
$sites = Get-SPOSite$sites
You can always pipe the output to | Out-GridView, or ConvertTo-Csv, or use some fantastic tools to take the data and do what you want with it.
Hope that helps,