01-16-2018 06:41 AM
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.
01-16-2018 06:53 AM
01-17-2018 08:07 PM
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 $Credentials
Connect-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,