从 SharePoint 在线租户获取所有用户并通过 Powershell 设置用户配置文件属性 [英] Getting ALL users from SharePoint online tenant and set userprofile property via Powershell

问题描述

更新:

Vadim 在下面有一个很好的答案，但我就是这样做的:

Vadim has a good answer below but this is how I did:

namespace UserProfile.Manipulation.CSOM.Console
{
    class Program
    {
        static void Main(string[] args)
        {
            searchAllUsers();

        }

        private static void searchAllUsers()
        {
            string siteCollectionUrl = "https://tenant.sharepoint.com/sites/intranet";
            string tenantAdminLoginName = "adminlogin";
            string tenantAdminPassword = "Password";

            using (ClientContext clientContext = new ClientContext(siteCollectionUrl))
            {
                SecureString passWord = new SecureString();

                foreach (char c in tenantAdminPassword.ToCharArray()) passWord.AppendChar(c);

                clientContext.Credentials = new SharePointOnlineCredentials(tenantAdminLoginName, passWord);

                KeywordQuery keywordQuery = new KeywordQuery(clientContext);
                keywordQuery.QueryText = "*";
                keywordQuery.SourceId = new Guid("B09A7990-05EA-4AF9-81EF-EDFAB16C4E31");
                keywordQuery.TrimDuplicates = false;


                keywordQuery.RowLimit = 500;
//startrow changed 3 times since 500 limitations.
                keywordQuery.StartRow = 1001;

                SearchExecutor searchExecutor = new SearchExecutor(clientContext);
                ClientResult<ResultTableCollection> results = searchExecutor.ExecuteQuery(keywordQuery);
                clientContext.ExecuteQuery();

                foreach (var resultRow in results.Value[0].ResultRows)
                {
                    SetSingleValueProfileProperty(resultRow["AccountName"].ToString());

                }

            }

        }

        private static void SetSingleValueProfileProperty(string accountName)
        {

            string tenantAdministrationUrl = "https://tentnatname-admin.sharepoint.com";
            string tenantAdminLoginName = "adminlogin";
            string tenantAdminPassword = "password";

            string UserAccountName = accountName;

            using (ClientContext clientContext = new ClientContext(tenantAdministrationUrl))
            {
                SecureString passWord = new SecureString();

                foreach (char c in tenantAdminPassword.ToCharArray()) passWord.AppendChar(c);

                clientContext.Credentials = new SharePointOnlineCredentials(tenantAdminLoginName, passWord);

                PeopleManager peopleManager = new PeopleManager(clientContext);

                peopleManager.SetSingleValueProfileProperty(UserAccountName, "SPS-PicturePlaceholderState", "1");

                clientContext.ExecuteQuery();
            }
        }


    }

}

我需要为租户内的所有用户配置文件设置一个属性.

}

I need to set a property on ALL userprofiles within a tenant.

似乎不可能通过 CSOM 和 powershell 从UPA"获取所有用户配置文件！?

It doesnt seem possible to get all user profiles from "UPA" via CSOM and powershell!?

可以(理论上)循环遍历所有站点集合并将所有用户添加到某个数组，然后仅从该数组中选择唯一的(删除重复项):

Its possible (in theory) to loop trough all sitecollections and add all users to maybe some array and afterwards only select unique from that array (to remove duplicates):

$sites = Get-SPOSite | select *
foreach ($site in $sites) {

Get-SPOUser -Site $site

...等等

然后循环遍历该数组并使用 csom:

And then loop trough that array and use csom:

$pMAn = New-Object Microsoft.SharePoint.Client.UserProfiles.PeopleManager($context)

$userProfile = $pMan.GetPropertiesFor($user.LoginName)
$ctx.Load($userProfile)

$ctx.ExecuteQuery()
$pMan.SetSingleVlueProfileProperty($userProfile.AccountName, "property", $value)

$ctx.ExecuteQuery()

谁能想到更聪明的解决方案?

Anyone who can think of a smarter solution?

推荐答案

正如您提到的，没有使用 SharePoint Online CSOM API 在 SharePoint 租户中获取所有用户配置文件的直接方法.但您可以考虑以下方法:

As you mentioned, there is no straightforward ways of getting all user profiles within SharePoint tenant using SharePoint Online CSOM API. But you could consider the following approach:

• 利用 Windows PowerShell 的 Azure Active Directory 模块检索租户中的所有用户(Get-MsolUser cmdlet)
• 迭代用户并利用 SharePoint 用户配置文件 CSOM API检索用户个人资料

• utilize Azure Active Directory Module for Windows PowerShell to retrieve all the users in tenant (Get-MsolUser cmdlet)
• iterate users and utilize SharePoint User Profiles CSOM API to retrieve user profile

示例

Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.dll"
Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.Runtime.dll"
Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.UserProfiles.dll"



Function Get-SPOContext([string]$Url,[string]$UserName,[string]$Password)
{
   $context = New-Object Microsoft.SharePoint.Client.ClientContext($Url)
   $context.Credentials = Get-SPOCredentials -UserName $UserName -Password $Password
   return $context
}


Function Get-SPOCredentials([string]$UserName,[string]$Password)
{
   $SecurePassword = $Password | ConvertTo-SecureString -AsPlainText -Force
   return New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($UserName, $SecurePassword)
}



Function Print-UserProfileInfo([Microsoft.SharePoint.Client.UserProfiles.PeopleManager]$PeopleManager,[string]$AccountName){
   $ctx = $PeopleManager.Context
   $accountName = "i:0#.f|membership|" + $AccountName  #claim format  
   $userProfile = $PeopleManager.GetPropertiesFor($AccountName)
   $ctx.Load($userProfile)
   $ctx.ExecuteQuery()
   Write-Host $userProfile.PersonalUrl
}




$tenantUrl = "https://contoso.sharepoint.com/"
$userName = "[e-mail]" 
$password = "password"

$secPassword = ConvertTo-SecureString $password -AsPlainText -Force
$cred = New-Object System.Management.Automation.PSCredential ($userName, $secPassword)
Connect-MsolService -Credential $cred
$allUsers = Get-MsolUser




$Context = Get-SPOContext -Url $tenantUrl -UserName $userName -Password $password
$peopleManager = New-Object Microsoft.SharePoint.Client.UserProfiles.PeopleManager($Context)
$allUsers |  % { Print-UserProfileInfo -PeopleManager $peopleManager -AccountName $_.UserPrincipalName }
$Context.Dispose()

这篇关于从 SharePoint 在线租户获取所有用户并通过 Powershell 设置用户配置文件属性的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！