Forum Discussion

Dean_Gross's avatar
Dean_Gross
Silver Contributor
Jan 16, 2018

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. 

      • 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,

         

Share