I did some research on Sharepoint(WSS) Users, about where are the users & their properties are stored.
I got some result with that, So, i like to share that with you all via.. this post,
By using the SPWeb.SiteUserInfoList property,we will get a UserInfo list of the site collection of the current web.
The title of this userinfo list is “User Information List“.This was the hidden list and it has some metadata for storing some information about user.
Here, I list out the metadata available in “User Information List“,
Display Name | Type | Name |
Content Type ID | ContentTypeId | ContentTypeId |
Name | Text | Title |
Approver Comments | Note | _ModerationComments |
File Type | Text | File_x0020_Type |
Account | Text | Name |
Text | ||
About Me | Note | Notes |
SIP Address | Text | SipAddress |
Locale | Integer | Locale |
Calendar Type | Integer | CalendarType |
AdjustHijriDays | Integer | AdjustHijriDays |
TimeZone | Integer | TimeZone |
Time Format | Boolean | Time24 |
Alternate Calendar Type | Integer | AltCalendarType |
CalendarView Options | Integer | CalendarViewOptions |
WorkDays | Integer | WorkDays |
WorkDay StartHour | Integer | WorkDayStartHour |
WorkDay EndHour | Integer | WorkDayEndHour |
Is Site Admin | Boolean | IsSiteAdmin |
Deleted | Boolean | Deleted |
Picture | URL | Picture |
Department | Text | Department |
Job Title | Text | JobTitle |
Is Active | Boolean | IsActive |
Report To | User | Report_x0020_To |
ID | Counter | ID |
Content Type | Text | ContentType |
Modified | DateTime | Modified |
Created | DateTime | Created |
Created By | User | Author |
Modified By | User | Editor |
Has Copy Destinations | Boolean | _HasCopyDestinations |
Copy Source | Text | _CopySource |
owshiddenversion | Integer | owshiddenversion |
Workflow Version | Integer | WorkflowVersion |
UI Version | Integer | _UIVersion |
Version | Text | _UIVersionString |
Attachments | Attachments | Attachments |
Approval Status | ModStat | _ModerationStatus |
Edit | Computed | Edit |
Name | Computed | LinkTitleNoMenu |
Title | Computed | LinkTitle |
Select | Computed | SelectTitle |
Instance ID | Integer | InstanceID |
Order | Number | Order |
GUID | Guid | GUID |
Workflow Instance ID | Guid | WorkflowInstanceID |
URL Path | Lookup | FileRef |
Path | Lookup | FileDirRef |
Modified | Lookup | Last_x0020_Modified |
Created | Lookup | Created_x0020_Date |
Item Type | Lookup | FSObjType |
Effective Permissions Mask | Computed | PermMask |
Name | File | FileLeafRef |
Unique Id | Lookup | UniqueId |
ProgId | Lookup | ProgId |
ScopeId | Lookup | ScopeId |
HTML File Type | Computed | HTML_x0020_File_x0020_Type |
Edit Menu Table Start | Computed | _EditMenuTableStart |
Edit Menu Table End | Computed | _EditMenuTableEnd |
Name | Computed | LinkFilenameNoMenu |
Name | Computed | LinkFilename |
Type | Computed | DocIcon |
Server Relative URL | Computed | ServerUrl |
Encoded Absolute URL | Computed | EncodedAbsUrl |
File Name | Computed | BaseName |
Property Bag | Lookup | MetaInfo |
Level | Integer | _Level |
Is Current Version | Boolean | _IsCurrentVersion |
Group | Computed | GroupLink |
Edit | Computed | GroupEdit |
Name | Computed | ImnName |
Picture | Computed | PictureDisp |
Name | Computed | NameWithPicture |
Name | Computed | NameWithPictureAndDetails |
Edit | Computed | EditUser |
Selection Checkbox | Computed | UserSelection |
Content Type | Computed | ContentTypeDisp |
By using above metadata’s we can get or set the values to User items in “User Information List”
How can I add fields to “User Information List”
By: Isabel on April 14, 2010
at 6:42 pm
If only more people would read about this.
By: Leopoldo Bullard on May 28, 2010
at 3:17 pm
Incredibly interesting read. Really!
By: Lenard Bauman on June 1, 2010
at 8:50 pm
[…] WSS – User Information List ” Welcome to ShanthaKumar’s Blog I did some research on Sharepoint(WSS) Users, about where are the users & their … _UIVersionString. Attachments. Attachments. Attachments. Approval Status. ModStat … […]
By: Articles about _uiversionstring volume 2 « Article Directory on June 13, 2010
at 12:20 am
I need to access the IS Site Admin property using JQuery and SOAP, any idea if this possible?? I am not able to find the IS Site Admin column in the “User Information List” columns returned by the Lists.asmx web service.
Thanks,
Ganesh.M
By: Ganesh on March 8, 2012
at 12:38 pm
A lot of thanks for your entire labor on this site.
My aunt loves making time for research and it is obvious why.
Most people hear all about the dynamic tactic you
create invaluable tips by means of your website and even
foster participation from other individuals on the situation while our
own child has always been studying a lot. Enjoy the remaining portion of the new year.
You’re performing a first class job.
By: lekkere verhalen on August 7, 2013
at 12:00 am
I know this site offers quality based articles or reviews and extra stuff, is there any other web site which presents
these kinds of information in quality?
By: Lance on October 3, 2014
at 12:02 am
Have you ever thought about adding a little bit more than just your articles?
I mean, what you say is valuable and everything.
But think of if you added some great pictures or videos to
give your posts more, “pop”! Your content is excellent but with pics and
video clips, this site could undeniably be one of the very best in its
niche. Awesome blog!
By: Aura Kingdom Bot on October 5, 2014
at 3:31 pm
Great post.
By: australian brides on November 17, 2014
at 5:02 pm
[…] UserInfo Table […]
By: Cleanup the Inactive users in SharePoint - Keep it Simple on February 9, 2016
at 10:27 am