Posted by: Shantham | March 11, 2009

WSS – User Information List


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”

Read more…


Responses

  1. How can I add fields to “User Information List”

  2. If only more people would read about this.

  3. Incredibly interesting read. Really!

  4. […] 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 … […]

  5. 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

  6. 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.

  7. 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?

  8. 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!

  9. Great post.

  10. […] UserInfo Table […]


Leave a reply to Isabel Cancel reply

Categories