Find site collections within a Web application
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: 2008-04-07
Before you perform this procedure, confirm that:
- You have read the topic Manage Web applications.
When you view a list of site collections through the user interface, you can see at a glance the URL, title, description, primary site collection administrator, e-mail address, and the content database name for each site collection.
When you use the Stsadm.exe command enumsites, you can view additional information about a site collection, including the name of the secondary site collection administrator, the amount of storage currently in use by the content database, the maximum storage limit for the content database, and the warning level for the content database. You can also display the lock status of each site by using the showlocks parameter. You can use redirectedsites to display a list of sites that redirect to the Web application.
Finding site collections within a Web application
Use the following procedures to view a list of the site collections within a Web application.
Important
At the minimum, you must be a member of the Farm Administrators SharePoint group to complete this procedure using the user interface.
View the site collections within a Web application by using Central Administration
On the top link bar of the Central Administration Web site, click Application Management.
On the Application Management page, in the SharePoint Site Management section, click Site collection list.
On the Site Collection List page, verify that the Web application you want is selected. If it is not, on the Web Application menu, click Change Web Application.
On the Select Web Application page, click the Web application for which you want to view the site collection. A list of all Web sites associated with the Web application is displayed. The sites are listed in alphabetical order, in batches of 10 items per page.
Click OK.
Important
The account that you use to run the Stsadm command-line tool must be a member of the Administrators group on the local computer.
View the site collections within a Web application by using the Stsadm command-line tool
On the drive where SharePoint Products and Technologies is installed, open a command-line window and type the following command:
cd %CommonProgramFiles%\Microsoft Shared\web server extensions\12\bin
To view a list of Web applications on the server, type the following command:
stsadm -o enumzoneurls
Be sure to note the URL of the Web application for which you want to view site collections.
For more information, see Enumzoneurls: Stsadm operation (Office SharePoint Server).
To view a list of site collections for a specific Web application, type the command stsadm -o enumsites -url <http://collection name> [-showlocks] [-redirectedsites], where collection name is the URL path to the Web application that you located in step 2.
To show the lock status of each site, append -showlocks to the command.
To show a list of sites that have not been upgraded in a version 3.0 Web application, append -redirectedsites to the command.
For more information, see Enumsites: Stsadm operation (Office SharePoint Server).
Additional references
For information about:
Web applications and how to structure your logical architecture, see Logical architecture model: Corporate deployment.
How to organize your site collection's content, see Determine sites and subsites.
Planning the process for creating site collections, and managing the size and number of site collections in your environment, see Plan for site creation and maintenance (Office SharePoint Server).