View all site collections in SharePoint 2013


Applies to: SharePoint Foundation 2013, SharePoint Server 2013

Topic Last Modified: 2016-12-16

Summary: How to see the list of site collections in SharePoint 2013.

A site collection is a group of websites that have the same owner and share administrative settings, for example, permissions, and quotas. Site collections are created within a web application. When you create a site collection, a top-level site is automatically created in the site collection. You can then create one or more subsites below the top-level site. The entire structure of the top-level site and all its subsites is called a site collection.

The steps in this article apply to both SharePoint Foundation 2013 and SharePoint Server 2013.

Use the following procedures to view all the site collections in a web application.

To view all site collections by using Central Administration
  1. Verify that you have the following administrative credentials:

    • To view all site collections, you must be a member of the Farm Administrators group on the computer that is running the SharePoint Central Administration website.

  2. Start SharePoint 2013 Central Administration.

    • For Windows Server 2008 R2:

      • Click Start, click Microsoft SharePoint 2013 Products, and then click SharePoint 2013 Central Administration.

    • For Windows Server 2012:

      • On the Start screen, click SharePoint 2013 Central Administration.

        If SharePoint 2013 Central Administration is not on the Start screen:

      • Right-click Computer, click All apps, and then click SharePoint 2013 Central Administration.

    For more information about how to interact with Windows Server 2012, see Common Management Tasks and Navigation in Windows Server 2012.

  3. In Central Administration, on the Application Management page, in the Site Collections section, click View all site collections.

    The Site Collection List page lists all the site collections in the web application.

  4. To display more information about a site collection, in the URL column, click the site collection.

    The following information about the site collection appears in a table on the right side of the page.


    Item Description


    The URL of the site collection.


    The current title for site collection.


    The current description for the site collection.

    Primary administrator

    The primary administrator for the site collection.

    Email address

    The email address for the primary administrator.

    Database name

    The content database that is used by the site collection.

  5. If you want to change the selected web application, click the Web Application box, and then click Change Web Application. Use the Select Web Application page to select another web application.

To view all site collections by using Windows PowerShell
  1. Verify that you meet the following minimum requirements: See Add-SPShellAdmin.

  2. On the Start menu, click All Programs.

  3. Click Microsoft SharePoint 2013 Products.

  4. Click SharePoint 2013 Management Shell.

  5. At the Windows PowerShell command prompt, type the following command, and then press ENTER:

    Get-SPWebApplication -Limit All | Get-SPSite | Format-Table -Property URL,ContentDatabase

    This command displays the URLs of all the web applications in a server farm and the site collections in each web application.

For more information, see Get-SPWebApplication and Get-SPSite.

We recommend that you use Windows PowerShell when performing command-line administrative tasks. The Stsadm command-line tool has been deprecated, but is included to support compatibility with previous product versions.