User Profile List in SharePoint 2010

SharePoint Expert Blog

Michael Doyle

Community Topic(s): SharePoint

Keywords: users, SharePoint

By Michael Doyle, SharePoint Architect at Waggener Edstrom Worldwide

November 19, 2010 - 1:00 AM

The User Information List is a list of every user that has ever been to your site collection or that has been added as an individual user. You may want to use this list for your own purposes. One of the ways you can do this is via Access. The steps to link to it are below.

Connecting to the SharePoint List from Access 2010

  1. Open up your Access database.
  2. Click on the External Data tab.
  3. Click on More and then SharePoint List as shown below
  4. Enter the top level site collection (i.e. http://howardcentral)
  5. Click on Link to the data source by creating a linked table.
  6. Click Next.
  7. Select UserInfo from the lists of lists as shown below.
  8. Click OK.
  9. You will now have a list of all the users that have been to your site (or that have been added individually).

You will now be able to use a list of users (and a host of other information) so that you can do things like create a phone book to be printed out. Old school, but you would be amazed at how often this request comes up and Access is an amazing tool for creating good looking reports.

 

Report

Add a Comment

You need to log in to post messages. Click here to login.

Comments

Tom Resing

Submitted by Tom Resing November 22, 2010 - 11:17 AM

I bet that makes a great phone book report! Great idea, Michael.
Report
Was this helpful? Yes No
Reply

This post and comment(s) reflect the personal perspectives of community members, and not necessarily those of their employers or of AIIM International