User Information List in SharePoint All details

What is User Information List?As per the Name SharePoint User Information List stores information about a user by having some metadata set up for the user. Some examples are User Picture, Email, DisplayName, LoginName etc. For a complete list of fields, see further down this blog

 
 
 
 
 
5 Star
(5)
Add to favorites
SharePoint
12/21/2015
E-mail Twitter del.icio.us Digg Facebook
Sign in to ask a question


  • Clarification regarding removing users from the UIL
    1 Posts | Last post August 07, 2019
    • If a user is listed in the User Information List and I check permissions to ensure that they have no permissions on the site, can I delete them from the site?
      
      I'm thinking that the User Information List is showing anyone who has ever been given permissions on the site (even through an AD group) who has not been specifically deleted.
      
      I'm wanting to clear out people who don't currently have rights on the site so that I can more easily see a full list of who does currently have some type of rights. They still exist (and should) in our enterprise SharePoint environment, they just should not have any rights on the particular site.
      
      Thank you!
  • Greate article)
    1 Posts | Last post May 24, 2018
  • Sync between SPO User Profile Service and UIL not working properly
    2 Posts | Last post November 28, 2017
    • Hello,
      
      thanks for the very informative article. I learned a lot about the user information list (henceforth UIL).
      We use SPO and seem to have the issue that the User Profile Service (henceforth UPS) doesn't update display names for objects renamed in local AD. The object changes synch correctly from local AD to O365. However the UIL is not updated. The user is still shown with the old display name. Checking the UPS shows that it did not update the changes as well. However, removing the user from the UIL and adding him back will use the new display name. After an hour this change is synched to the UPS. So UIL -> UPS seems to be working. O365 -> UPS -> UIL doesn't.
      Any idea what might be going on here?
      
      Thanks a lot in advance for your help.
      
    • I have to correct myself. I have to idea wat happened but my latest test showed that everything worked / synched correctly. No idea what was going on before. Thanks.
  • How to access User Information list using powershell scripts
    1 Posts | Last post November 09, 2017
    • Hi Krishna,
      
      I don't think so "User Info list" will work in SPWeb object since this list is available only root site meaning site collection . 
      
        $Site = get-spsite "Enter the Site collection  url"
      
        $web =$Site.RootWeb;
      
      
  • How to delete a column in user information list ?
    1 Posts | Last post September 02, 2016
    • Hello,
      A add 2 column in user information list : Locale ID and Translation language.
      But i cannot delete them. And the locale ID is a required column. 
      I cannot change the parameters of this column.
      How can i delete this columns from user information list ?
      Can i make this via sp designer ?
      Thanks !
      
  • Adding account names BACK to the UIL?
    3 Posts | Last post May 05, 2016
    • I have an odd/interesting problem. We use some web parts that display the user name based on the UIL. When people leave the agency, it's not a problem because even though they're removed from the Active Directory, their accounts are still listed on the User Information List.
      
      BUT - running a PowerShell import-spweb command using the -IncludeUserSecurity parameter seems to have cleared out all the former users from the UIL. Now the web part is breaking because it can't find those names any more. 
      
      Is there a way to add back former users to the User Information List, without creating AD entries for them?
    • Hi KVollero,
      
      Sorry for the delay in response.
      
      Directly you can’t add user to User Information list, The User Information list is populated by the User Profile Properties defined in the User Profile Service Application in Central Administration.
      If you can add dummy user and provide all the details as you want to have for old user you can specify these value in user profile and create the user over there and it will come to your user information list but again you need to add dummy user to AD or your local computer to create Profile.
      
    • Thank you for the assistance and clarification.
  • Thanks for putting all details and described nicel
    1 Posts | Last post April 14, 2016
  • User Information List Fields
    2 Posts | Last post April 14, 2016
    • 
      Hi, I am looking after the list of fields, after the field names in the UIL.
      In the beginning of the article there is a note saying:
      For a complete list of fields, see further down this blogpost under "User Information List Fields".
      
      But I can not find this, is there somewhere else?
      
      Ta,
      Iulian
      
    • Hi Iulian,
      
      Here it is :
      
      Name:Content Type ID;Type:ContentTypeId
      Name:Name;Type:Text
      Name:Approver Comments;Type:Note
      Name:File Type;Type:Text
      Name:Account;Type:Text
      Name:Work e-mail;Type:Text
      Name:About me;Type:Note
      Name:SIP Address;Type:Text
      Name:Locale;Type:Integer
      Name:Calendar Type;Type:Integer
      Name:AdjustHijriDays;Type:Integer
      Name:TimeZone;Type:Integer
      Name:Time Format;Type:Boolean
      Name:Alternate Calendar Type;Type:Integer
      Name:CalendarView Options;Type:Integer
      Name:WorkDays;Type:Integer
      Name:WorkDay StartHour;Type:Integer
      Name:WorkDay EndHour;Type:Integer
      Name:Is Site Admin;Type:Boolean
      Name:Deleted;Type:Boolean
      Name:Picture;Type:URL
      Name:Department;Type:Text
      Name:Title;Type:Text
      Name:Is Active;Type:Boolean
      Name:First name;Type:Text
      Name:Last name;Type:Text
      Name:Name;Type:Computed
      Name:Work phone;Type:Text
      Name:Office;Type:Text
      Name:User name;Type:Text
      Name:Web site;Type:URL
      Name:Responsibilities;Type:Note
      Name:MyWork Email;Type:Note
      Name:ID;Type:Counter
      Name:Content Type;Type:Text
      Name:Modified;Type:DateTime
      Name:Created;Type:DateTime
      Name:Created By;Type:User
      Name:Modified By;Type:User
      Name:Has Copy Destinations;Type:Boolean
      Name:Copy Source;Type:Text
      Name:owshiddenversion;Type:Integer
      Name:Workflow Version;Type:Integer
      Name:UI Version;Type:Integer
      Name:Version;Type:Text
      Name:Attachments;Type:Attachments
      Name:Approval Status;Type:ModStat
      Name:Edit;Type:Computed
      Name:Name;Type:Computed
      Name:Select;Type:Computed
      Name:Instance ID;Type:Integer
      Name:Order;Type:Number
      Name:GUID;Type:Guid
      Name:Workflow Instance ID;Type:Guid
      Name:URL Path;Type:Lookup
      Name:Path;Type:Lookup
      Name:Modified;Type:Lookup
      Name:Created;Type:Lookup
      Name:Item Type;Type:Lookup
      Name:Effective Permissions Mask;Type:Computed
      Name:Name;Type:File
      Name:Unique Id;Type:Lookup
      Name:ProgId;Type:Lookup
      Name:ScopeId;Type:Lookup
      Name:HTML File Type;Type:Computed
      Name:Edit Menu Table Start;Type:Computed
      Name:Edit Menu Table End;Type:Computed
      Name:Name;Type:Computed
      Name:Name;Type:Computed
      Name:Type;Ty