Home / server / Questions / 573658
Accepted
Rob Moir
Asked: 2014-02-07 05:37:48 +0800 CST

Delete an individual user profile from Office 365/Sharepoint Online MySite, using Powershell

  • 772

I'm trying to work out a process that would allow my helpdesk to delete an individual user's profile from Office 365 sharepoint online using powershell.

It's easy to connect to our Sharepoint Online URL and see the sites we have:

Connect-MsolService
Connect-SPOService -url https://example-admin.sharepoint.com -Credential [email protected]

I can verify that I'm connected. get-sposite returns a list of our sharepoint online URLs, as you expect.

Running commands such as repair-sposite or remove-sposite work for the entire site collection, e.g. repair-sposite -identity https://example-my.sharepoint.com works on the whole site collection, so the last thing I want to be doing is running remove-sposite at this level, and running it at a deeper level (repair-sposite -identity https://example-my.sharepoint.com/personal/user_example_com) fails to locate a sharepoint site to work with.

There are a few sites out there that have all cut and pasted the same snippet of code to iterate all the users in a sharepoint mysites collection and remove all of them, but I'm not convinced that code works for sharepoint 2013 sites and it's trivial to remove a user's permissions from a site. But I don't want to do either of those things, I just want to remove one user's profile from mysites.

powershell

2 Answers

  1. Best I can find for you:

    http://jopx.blogspot.com/2013/08/managing-sharepoint-online-with.html

    Which states:

    There are no cmdlets available for managing SharePoint objects at a lower scope than the site collection.

    But then gives this possibility:

    There is however a workaround for manipulating objects in SharePoint Online at a lower level using the SharePoint Server 2013 Client Components SDK which enables remote development against SharePoint Server 2013.

    But isn't what you are after for providing a simple PS script for the Helpdesk to use. You might consider opening a ticket with O365 support, but my experience with that has been hit or miss. Sometimes it seems I get someone that knows only scripted answers, and then there are times where it seems I get the actual developers themselves.

    • 1
  2. Best Answer

    I've been generating a library to use for sharepoint online, so I've been writing hundreds of these small tasks lately, but basically you'll need to use CSOM commands. first, download the sharepoint server 2013 client context SDK. Then make sure you include the DLL in your code:

    Import-Module 'C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.dll'

    Your path to the DLL may differ from mine.

    Now you can use CSOM to do just about anything you want.

    Here's some code that should accomplish what you're trying to do.

    Import-Module 'C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.dll'  #Needed for CSOM
$SPOUsername="[email protected]"
$SPOPassword="my plain text password"
$SPCred=New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($SPOUsername,(ConvertTo-SecureString $SPOPassword -AsPlainText -Force))
$context = New-Object Microsoft.SharePoint.Client.ClientContext("https://Blah.sharepoint.com/sites/.....")
$context.Credentials = $SPCred
$web=$context.Web
$context.Load($web.SiteUsers)
$context.ExecuteQuery()

$Web.SiteUsers|Select ID,Email,title #Display users and their IDs
$Web.SiteUsers.RemoveById(<ID of target user>)

$context.ExecuteQuery()
    • 1