Thanks for posting this. We've been looking for a solution to output profile data for ages. We've been asked to output users profiles to a file and have managed to output to a csv by adding "$UserProfile.UserProfileProperties | Out-File C:\psoutputs\users.csv -append" to your code.

We are now having trouble manipulating that data into something readable as it outputs into rows instead of columns. We think we might need to define an array but have limited knowledge of PowerShell. Are you or any of your readers able to offer any advice or assistance?

Brilliant, many thanks - any additional information would be greatly received. With regard to the urgency, we would like to report the information as soon as possible but completely understand that you may have other priorities.

This is wonderful :) I'm attempting this in c# rather than PS, but the principle idea is the same and EXACTLY what we needed for a client. If you take this a step further and open a client context object pointed at the Personal or OneDrive URL, and get the documents library, you can see who is actually USING their one drive, and who hasn't visited their profile to update their properties. This is a great tool for gauging user adoption. Cheers! - Baltimore, MD

when I'm trying to execute this script i receive following error:

Exception calling "ExecuteQuery" with "0" argument(s): "The remote server returned an error: (401) Unauthorized."
At line:22 char:1
+ $Context.ExecuteQuery()
+ ~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : NotSpecified: (:) [], MethodInvocationException
+ FullyQualifiedErrorId : WebException

The collection has not been initialized. It has not been requested or the request has not been executed. It may need to be explicitly requested.
At line:26 char:10
+ Foreach ($User in $Users)
+ ~~~~~
+ CategoryInfo : OperationStopped: (:) [], CollectionNotInitializedException
+ FullyQualifiedErrorId : Microsoft.SharePoint.Client.CollectionNotInitializedException

I'm admin in office 365 and adapted the values to ours. any ideas?

Getting following error on this line: $PeopleManager = New-Object Microsoft.SharePoint.Client.UserProfiles.PeopleManager($Context)

New-Object : Cannot find an overload for "PeopleManager" and the argument count: "1".
...
+ $PeopleManager = New-Object Microsoft.SharePoint.Client.UserProfiles.PeopleManag ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : InvalidOperation: (:) [New-Object], MethodException
+ FullyQualifiedErrorId : ConstructorInvokedThrowException,Microsoft.PowerShell.Commands.NewObjectCommand

Hi Brendan, if the OneDrive URL is blank, does that mean the user has not setup their Personal Site? I am trying to find powershell script that will give me an output of users who have yet to setup OneDrive and this could be my answer. Many thanks in advance

Great. Thanks!

@VReyes - that's correct.

Is it possible to bulk delete the OneDrive account (Personal site) of all the users using PowerShell. If possible what command should I use. Kindly advise.

Hi excellent post , however to retrieve all users in system we can Use the MySiteURL instead of individual Site Collections.