People picker processing process

Source: Internet
Author: User
Tags ldap protocol

Users and groups in SharePoint can be added to the site. put a keyword to search for users in the domain. After confirmation, the user displays the user's display name, which is underlined. how does people picker work?


1. People will query SharePoint's content database by running an SQL statement:

Exec sp_executesql
Select top 202 T1. [type] As C0,
T1. [metainfo] as C2,
Userdata. [nvarchar3],
Userdata. [tp_contenttypeid],
Userdata. [nvarchar8],
Userdata. [tp_id],
Userdata. [tp_copysource],
Userdata. [tp_version],
Userdata. [nvarchar4],
T1. [scopeid] as C4,
Userdata. [nvarchar9],
Userdata. [nvarchar5],
Userdata. [tp_created],
When datalength (t1.dirname) = 0 then t1.leafname
When datalength (t1.leafname) = 0 then t1.dirname
Else t1.dirname + N''/''+ T1.leafname
End as C1,
Userdata. [tp_hascopydestinations],
Userdata. [nvarchar1],
Userdata. [tp_moderationstatus],
Userdata. [tp_level],
T1. [ID] as C3,
Userdata. [tp_contenttype]
From userdata
Inner merge join Docs as T1 with (nolock)
On (1 = 1
And userdata. [tp_rowordinal] = 0
And t1.siteid = userdata. tp_siteid
And t1.siteid = @ L2
And t1.dirname = userdata. tp_dirname
And t1.leafname = userdata. tp_leafname
And t1.level = userdata. tp_level
And t1.iscurrentversion = 1
And (1 = 1 ))
Where (userdata. tp_iscurrent = 1)
And userdata. tp_siteid = @ L2
And (userdata. tp_dirname = @ DN)
And userdata. tp_rowordinal = 0
And (userdata. [bit3] = 0)
And (userdata. [nvarchar3] Like @ l3txp)
Or (userdata. [nvarchar1] Like @ l4txp ))
Or (userdata. [nvarchar4] Like @ l4txp ))
And t1.siteid = @ L2
And (t1.dirname = @ DN ))
Order by T1. [type] DESC,
Userdata. [nvarchar3] ASC,
Userdata. [tp_id] ASC
Option (Force Order)
N'@ L0 uniqueidentifier, @ L2 uniqueidentifier, @ l3txp nvarchar (255), @ l4txp nvarchar (255), @ nvdn archar (260)',
@ L0 ='00000000-0000-0000-0000-000000000000',
@ L2 ='48d3167b-xxxx-xxxx-xxxx-ee6030973575',
@ L3txp = N'% Keyword %',
@ L4txp = N'Keyword %',
@ DN = N'_ Catalogs/users'


Note that the l3xp contains wildcards before and after the input keyword. The nvarchar3 stores Login Name, therefore, if the keywords you enter is any part of the login name, you can obtain the search result from the content database.

L4xp only includes a wildcard after the keyword. Therefore, the keyword you search for must be the start part of the field in nvarchar1 or nvarchar4. It is inferred based on the content, the two fields are displayname and email address.


2. if the user is not found in the content database, it indicates that the user has not been added to the site before. People picker then queries the domain controller, runs the LDAP query, and obtains the user instance returned by the ad.

3. If Network Monitor is used to capture the Network Package and use LDAP protocol as the filter, you will see the LDAP query filter, the attribute list to AD, and the attribute list returned by AD.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.