Where can i find Active directory user (List Data) information in Content database


  • I created a list in SharePoint2013 where  two of the list columns are imported from Active directory (I created a list column like "Person or group" and did a look up from "All Users" Group). I am trying to read this list data to update to another database and i cant find those fields which i am importing from AD.However i was able to get all information from list fields. I would appreciate if anyone would help me locate these fields. 

    PS: I have searched all fields (Nvarchar, text ) for this information. 

    • Edited by Pratibabb Friday, February 9, 2018 9:37 PM
    Friday, February 9, 2018 9:36 PM

All replies

  • It is not supported to read directly from SharePoint databases. Use the object model instead.

    All user data is contained within the UserInfo table. Each List item will have a reference to the ID (column value) of the user within the UserInfo table.

    Trevor Seward

    Office Servers and Services MVP

    Author, Deploying SharePoint 2016

    This post is my own opinion and does not necessarily reflect the opinion or view of Microsoft, its employees, or other MVPs.

    Friday, February 9, 2018 11:06 PM