{"id":601,"date":"2020-11-28T22:28:49","date_gmt":"2020-11-28T22:28:49","guid":{"rendered":"http:\/\/www.decoutere.eu\/?p=601"},"modified":"2020-11-28T22:28:50","modified_gmt":"2020-11-28T22:28:50","slug":"onedrive-groottes-in-office365-bepalen","status":"publish","type":"post","link":"https:\/\/www.decoutere.eu\/index.php\/2020\/11\/28\/onedrive-groottes-in-office365-bepalen\/","title":{"rendered":"onedrive groottes in Office365 bepalen"},"content":{"rendered":"
\n
\n\t

Param(
\n\t[Parameter(Position=0, Mandatory=$true, ValueFromPipeline=$true)]
\n [string] $Tenantname,
\n [Parameter(Position=0, Mandatory=$true, ValueFromPipeline=$true)]
\n [string] $Username,
\n\t[Parameter(Position=1, Mandatory=$true, ValueFromPipeline=$true)]
\n [string] $Password,
\n\t[Parameter(Position=2, Mandatory=$false, ValueFromPipeline=$true)]
\n [string] $OutputFile
\n)
\nif ($OutputFile -eq \"\")
\n{
\n $OutputFile=\"C:\\OneDrive_groottes.csv\"
\n}
\n$Result=@()
\n$loadInfo1 = [System.Reflection.Assembly]::LoadWithPartialName(\"Microsoft.SharePoint.Client\")
\n$loadInfo2 = [System.Reflection.Assembly]::LoadWithPartialName(\"Microsoft.SharePoint.Client.Runtime\")
\n$loadInfo3 = [System.Reflection.Assembly]::LoadWithPartialName(\"Microsoft.SharePoint.Client.UserProfiles\")
\n$AdminURI = \"https:\/\/\" + $Tenantname +\"-admin.sharepoint.com\"
\n$OneDrivePrefixUrl=\"https:\/\/\" + $Tenantname +\"-my.sharepoint.com\"
\n$SecPwd = $Password | ConvertTo-SecureString -AsPlainText -Force
\n$creds = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($Username, $SecPwd)
\n$UserCredential = New-Object System.Management.Automation.PSCredential -argumentlist $Username, $SecPwd
\n$proxyaddr = \"$AdminURI\/_vti_bin\/UserProfileService.asmx?wsdl\"
\n$UserProfileService= New-WebServiceProxy -Uri $proxyaddr -UseDefaultCredential False
\n$UserProfileService.Credentials = $creds
\nWrite-Progress -activity \"Fetching User Profiles\" -status \"...........\"
\n$strAuthCookie = $creds.GetAuthenticationCookie($AdminURI)
\n$uri = New-Object System.Uri($AdminURI)
\n$container = New-Object System.Net.CookieContainer
\n$container.SetCookies($uri, $strAuthCookie)
\n$UserProfileService.CookieContainer = $container
\n$UserProfileResult = $UserProfileService.GetUserProfileByIndex(-1)
\nWrite-Host \"Starting- This could take a while.\"
\n$NumProfiles = $UserProfileService.GetUserProfileCount()
\n$i = 1
\nConnect-SPOService -Url $AdminURI -Credential $UserCredential
\nWhile ($UserProfileResult.NextValue -ne -1)
\n{
\nWrite-Progress -activity \"Processing User Profiles\" -status \"$i out of $NumProfiles completed\"
\n$Prop = $UserProfileResult.UserProfile | Where-Object { $_.Name -eq \"PersonalSpace\" }
\n$Url= $Prop.Values[0].Value
\nif ($Url) {
\n$siteurl = $OneDrivePrefixUrl + $Url.Substring(0,$Url.Length-1)
\n$temp = Get-SPOSite $siteurl -Detailed
\nif($temp)
\n{
\n$Result += New-Object PSObject -property @{
\nUserName = $temp.Title
\nUserPrincipalName = $temp.Owner
\nTotalSize_MB = $temp.StorageUsageCurrent
\nTotalSize_GB = $temp.StorageUsageCurrent\/1024
\nStorageQuota_GB = $temp.StorageQuota\/1024
\nWarningSize_GB =\u00a0 $temp.StorageQuotaWarningLevel\/1024
\n}
\n}
\n}
\n$UserProfileResult = $UserProfileService.GetUserProfileByIndex($UserProfileResult.NextValue)
\n$i++
\n}
\n$Result | Select-object -property UserName,UserPrincipalName,TotalSize_MB,TotalSize_GB,StorageQuota_GB,WarningSize_GB |Export-CSV $OutputFile -NoTypeInformation -Encoding UTF8
\nWrite-Host \"OneDrive for Business Storage Report successfully exported to \"$OutputFile -foregroundcolor Green<\/p>\n<\/div>\n<\/div><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"

Param( [Parameter(Position=0, Mandatory=$true, ValueFromPipeline=$true)] [string] $Tenantname, [Parameter(Position=0, Mandatory=$true, ValueFromPipeline=$true)] [string] $Username, [Parameter(Position=1, Mandatory=$true, ValueFromPipeline=$true)] [string] $Password, [Parameter(Position=2, Mandatory=$false, ValueFromPipeline=$true)] [string] $OutputFile ) if ($OutputFile -eq “”) { $OutputFile=”C:\\OneDrive_groottes.csv” } $Result=@() $loadInfo1 = [System.Reflection.Assembly]::LoadWithPartialName(“Microsoft.SharePoint.Client”) $loadInfo2 = [System.Reflection.Assembly]::LoadWithPartialName(“Microsoft.SharePoint.Client.Runtime”) $loadInfo3 = [System.Reflection.Assembly]::LoadWithPartialName(“Microsoft.SharePoint.Client.UserProfiles”) $AdminURI = “https:\/\/” + $Tenantname +”-admin.sharepoint.com” $OneDrivePrefixUrl=”https:\/\/” + $Tenantname +”-my.sharepoint.com” $SecPwd = $Password | ConvertTo-SecureString -AsPlainText […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-601","post","type-post","status-publish","format-standard","hentry","category-geen-categorie"],"_links":{"self":[{"href":"https:\/\/www.decoutere.eu\/index.php\/wp-json\/wp\/v2\/posts\/601","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.decoutere.eu\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.decoutere.eu\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.decoutere.eu\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.decoutere.eu\/index.php\/wp-json\/wp\/v2\/comments?post=601"}],"version-history":[{"count":1,"href":"https:\/\/www.decoutere.eu\/index.php\/wp-json\/wp\/v2\/posts\/601\/revisions"}],"predecessor-version":[{"id":602,"href":"https:\/\/www.decoutere.eu\/index.php\/wp-json\/wp\/v2\/posts\/601\/revisions\/602"}],"wp:attachment":[{"href":"https:\/\/www.decoutere.eu\/index.php\/wp-json\/wp\/v2\/media?parent=601"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.decoutere.eu\/index.php\/wp-json\/wp\/v2\/categories?post=601"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.decoutere.eu\/index.php\/wp-json\/wp\/v2\/tags?post=601"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}