View site collections for a Web application

SharePoint 2007

Updated: July 31, 2008

Applies To: Office SharePoint Server 2007

This Office product will reach end of support on October 10, 2017. To stay supported, you will need to upgrade. For more information, see , Resources to help you upgrade your Office 2007 servers and clients.


Topic Last Modified: 2015-03-09

Web sites based on Microsoft Office SharePoint Server 2007 exist in a hierarchy. At the top of the hierarchy is a top-level Web site. Under this top-level site, there can be multiple subsites, and each subsite can contain other subsites. The entire structure of a top-level Web site and all of its subsites is called a site collection.

You can view the site collections in a Web application on the Site collection page in the SharePoint Central Administration Web site. The Site collection page lists the URLs of all available site collections in a Web application. Site collection details appear in the pane on the right side of the page. The following details are displayed:

  • URL

  • Title

  • Description

  • Primary

  • Administrator

  • E-mail address

  • Database name

For information about how to perform this procedure using the Stsadm command-line tool, see Enumsubwebs: Stsadm operation (Office SharePoint Server).

Membership in the Farm Administrators SharePoint group, or equivalent, is the minimum permission level required to complete this procedure. To view one of the sites within the list, you must have permissions to that site.

Use this procedure to view a list of all the sites in the site collection for the selected Web application.

View site collections for a Web application
  1. On the top navigation bar of the SharePoint Central Administration Web site page, click Application Management.

  2. In the SharePoint Site Management section, click Site collection list. The Site Collection List page appears.

  3. In the Web Application drop-down box, click the down arrow, and then click Change Web Application. The Select Web Application page lists the available Web applications.

  4. Click the name of the Web application. The Site Collection List page displays the list of site collection relative URLs for the selected Web application on the left side of the page.

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


    Information Description


    URL of the site collection.


    Title given when the site was created.


    Description provided when the site collection was created.

    Primary administrator

    Primary administrator for the site collection.

    E-mail address

    E-mail address for the primary administrator.

    Database name

    Content database used by the site collection.