View site collections in a Web application (SharePoint Foundation 2010)
Published: May 12, 2010
When you view a list of site collections through the Central Administration Web site, the page shows the URL, title, description, primary site collection administrator, the contact e-mail address, and the content database name for each site collection. When you use Windows PowerShell 2.0 commands to view site collections, you can view additional information, such as the name of the secondary site collection administrator, the maximum storage limit for the content database, and other details.
In this article:
To view site collections by using Central Administration
Verify that the user account that is performing this procedure is a member of the Farm Administrators SharePoint group.
On the Central Administration Home page, click Application Management.
On the Application Management page, in the Site Collections section, click View all site collections. The page lists site collections for the Web application that is displayed in the Web Application drop-down menu.
If the Web application for which you want to view site collections is not listed, click the down-arrow on the Web Application menu, and then click Change Web Application. In the Select Web Application dialog box, click the name of the Web application that you want.
A list of all site collections that are associated with the Web application is displayed. The site collections are listed in alphabetical order, in groups of 10 site collections per page.
To view the details of a listed site collection, click the URL of the site collection in the URL column of the page (for example, /mysites or /sites/team).
When you have finished viewing site collections, click OK.
To view site collections by using Windows PowerShell
Verify that you meet the following minimum requirements: See Add-SPShellAdmin.
On the Start menu, click All Programs.
Click Microsoft SharePoint 2010 Products.
Click SharePoint 2010 Management Shell.
At the Windows PowerShell command prompt, type the following command:
Run the Get-SPWebApplication command to return all site collections for a Web application.
Get-SPWebApplication <http://WebApplicationURL> | Get-SPSiteAdministration -Limit ALL | Select URL
Where <http://WebApplicationURL> is the URL of the Web application.
Run the Get-SPSite command to store the identity of the desired site collection into the $site variable. This retrieves and stores the content database GUID for the site collection into the $dbguid variable.
$site = Get-SPSite <http://SiteName> $dbguid = $site.contentdatabase.id
Where <http://SiteName> is the name of the site collection.
Run the Get-SPSite command using the $dbguid variable to display properties for the sites contained on this content database. In the following example, the URL, owner, secondary owner, and quota properties will be displayed in table format. Additional properties can be viewed by adding them to the command.
Get-SPSite -ContentDatabase $dbguid | Format-Table -Property Url, Owner, SecondaryOwner, Quota
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.