none
Onedrive for business space check for specific domain

    Question

  • Hello everybody,

    we are in Office tanet where 220 domains with 1.5lac users.

    we need to know only the space and items of our user (6500-7000), used in Onedrive.

    how we achieve this goal ?

    thanks in advance.


    • Edited by CHUNHUA lEE Wednesday, November 16, 2016 12:53 PM update
    Wednesday, November 16, 2016 12:45 PM

Answers

  • Hi,
    you achieve this goal by following the below mentioned steps.

    Login with Global administrator rights
    Go to Reports> Usage> OneDrive files


    Go to URL menu> Filter> Contain> Enter domain name without Dot.com

    Then click on export. to export the report

    Open file in Excel
    Select the column> click on filter


    Click on filter> Text Filters> Contain


    Enter Domain name and click ok


    Now you see the filter results

    • Marked as answer by CHUNHUA lEE Thursday, November 17, 2016 10:41 AM
    Thursday, November 17, 2016 10:31 AM

All replies

  • Hi,

    Please check the PowerShell below:

    function GetODUsage($url)
    {
        $sc = Get-SPOSite $url -Detailed -ErrorAction SilentlyContinue | select url, storageusagecurrent, Owner
        $usage = $sc.StorageUsageCurrent / 1024
        return "$($sc.Owner), $($usage), $($url)"
    }
    foreach($usr in $(Get-MsolUser -All ))
    {
        if ($usr.IsLicensed -eq $true)
        {
            $upn = $usr.UserPrincipalName.Replace(".","_")
            $od4bSC = "https://tenant-my.sharepoint.com/personal/$($upn.Replace("@","_"))"
            $od4bSC
            foreach($lic in $usr.licenses)
            {
                if ($lic.AccountSkuID -eq "tenant:ENTERPRISEPACK") {Write-Host "$(GetODUsage($od4bSC)), E3"}
                elseif ($lic.AccountSkuID -eq "tenant:WACONEDRIVESTANDARD") {Write-Host "$(GetODUsage($od4bSC)), OneDrive" }    
            }
        }
    }
    
    

    More information is here:

    http://blogs.catapultsystems.com/dbroussard/archive/2015/10/20/pull-onedrive-for-business-usage-using-powershell/

    Best Regards,

    Dennis


    Please remember to mark the replies as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com

    Thursday, November 17, 2016 9:05 AM
    Moderator
  • Hi,
    you achieve this goal by following the below mentioned steps.

    Login with Global administrator rights
    Go to Reports> Usage> OneDrive files


    Go to URL menu> Filter> Contain> Enter domain name without Dot.com

    Then click on export. to export the report

    Open file in Excel
    Select the column> click on filter


    Click on filter> Text Filters> Contain


    Enter Domain name and click ok


    Now you see the filter results

    • Marked as answer by CHUNHUA lEE Thursday, November 17, 2016 10:41 AM
    Thursday, November 17, 2016 10:31 AM