WSS – User Information List
by Shantha Kumar • March 11, 2009 • SharePoint • 3 Comments
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”
Thanks Nice Compilation.
Hi Shantha Kumar,
[Note:You don't need to approve this Comment, I searched for contact me option, as one is not there I though to contact you through comment, sorry about that]
I have few queries off the Topic, just wanted to know how did you created the Site. I too for sometime planning to host a domain on my Name and I have a account with wordpress.
Did you purchase domain from someone other than WordPress ?
Also I wanted my Template to be little more customizable, as out of the box wordpress template is not suited for me, it always has right and LEft section. I wanted one simimar to your site so that I can give more content to the user.
Thanks in advance
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