Retrieve My sites list in SharePoint online

When i was working on branidng for my sites, then i should get the list of my sites so that i can apply the custom branding to all the my sites.
So, in order to get the list of my sites, i have written the below code.

private static void GetMySites()
        {
            string siteUrl = "<root my site url>";
            string userName = "<Enter tenant admin user name>";
            string password = "<Enter tenant admin password>";

            SecureString securePassword = new SecureString();
            foreach (char c in password)
            {
                securePassword.AppendChar(c);
            }

            using (ClientContext clientContext = new ClientContext(siteUrl))
            {
                clientContext.Credentials = new SharePointOnlineCredentials(userName, securePassword);

                Web web = clientContext.Web;
                clientContext.Load(web);
                clientContext.ExecuteQuery();

                List<SiteEntity> mysites = web.MySiteSearch();

                Console.WriteLine("My sites count: " + mysites.Count);

                string filePath = "D:\\GetMySites\MySites.txt";
                if (!System.IO.File.Exists(filePath))
                {
                    System.IO.File.Create(filePath).Close();
                }

                StringBuilder sbSites = new StringBuilder();
                using (System.IO.TextWriter writer = System.IO.File.CreateText(filePath))
                {
                    foreach (SiteEntity site in mysites)
                    {
                        sbSites = sbSites.Append(site.Url + ";");
                    }
                    writer.WriteLine(sbSites);
                }
            }
        }

Hope this code helps you to get the list of my sites in a text file.

Happy coding :)

Update Mysites/UserProfile user image url

I have recently had reason to update the PictureURL property value via PowerShell in SharePoint 2013 for all users in the system.
As a result, I wrote the following PowerShell script to update the property value using string replace.

You will ideally need to run this on the server with an account with the appropriate permissions to update all user profiles.

Script:

#Set up default variables

  

  #My Site URL

  $mySiteUrl = "http://mysite/"

  

  #The part of the picture URL you are trying to find

  $currentURLValue = "http://mypersonalsite"

  

  #The value that will replace the above

 $newURLValue = "http://mysite:80"

 #The internal name for PictureURL

 $upPictureURLAttribute = "PictureURL"

 #Get site objects and connect to User Profile Manager service

 $site = Get-SPSite $mySiteUrl

 $context = Get-SPServiceContext $site

 $profileManager = New-Object   Microsoft.Office.Server.UserProfiles.UserProfileManager($context) 

 $profiles = $profileManager.GetEnumerator()

 foreach ($userProfile in $profiles) {

  if ($userProfile[$upPictureURLAttribute] -ne '') {

    

    $newPictureURL = $userProfile[$upPictureURLAttribute].toString()

    $newPictureURL  = $newPictureURL.Replace($currentURLValue, $newURLValue)

    

    write-host "Before: " $userProfile[$upPictureURLAttribute].toString() " | After: " $newPictureURL 

    

    #Get user profile and change the value - uncomment the lines below to commit the changes

    #$userProfile[$upPictureURLAttribute].Value = $newPictureURL

    #$userProfile.Commit()

  }

 }