Forum Discussion
Site Owner value in Usage report
The Site Owner value in the SharePoint Site Usage report shows an Office Group name instead of specific users. Is this what others are seeing also? it is not very helpful.
Ey Dean: Do you mean the site usage report in the Office 365 Admin Center?
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,
