Get a list of all Sharepoint lists and document libraries RRS feed

  • Question

  • We are upgrading to SharePoint 2013 from SP 2007 and in preparation I need to get a listing of all list and document libraries in my site collection.  We want to bring over only pertinent information.  I want to leave all stale sites, list and libraries in 2007 and let them go into the trash with the servers they are on :)

    I need to know:

    1. see how many items are in each.
    2. when the list was last used
    3. the size of the data

    Is this possible? 


    Thursday, September 11, 2014 7:22 PM


  • Hi all,

    I found a way to get what I was looking for.  I am sure its not a supported way, but as a SQL DBA,  I used the only way I know, which is hitting the tables.

    I used the AllLists to get the list title, last updated, and item counts and I joined it to the AllUserData to get the directory of the list.


    • Marked as answer by Jaylou Friday, September 12, 2014 3:41 PM
    Friday, September 12, 2014 3:41 PM