WSS – User Information List

2
Posted by Shantha Kumar on 11th March 2009

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
E-Mail Text EMail
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”

    2 Comments »

  1. Thanks Nice Compilation.

    Comment by Senthil — July 6, 2009 @ 8:38 am

  2. Useful informations, thanks a lot
    here you have an article on how to get metadata from this list : http://furuknap.blogspot.com/2009/08/sharepoint-user-information-list.html

    Comment by Konami2k — September 3, 2009 @ 11:56 am

RSS feed for comments on this post. TrackBack URL

Leave a comment