Page Comparison

The toolkit was designed for Site Owners , and Site Collection Administrators and Farm Admins. So sometimes a Site Owner may only have access to certain sites but not the web application, therefore the tool does not try to enumerate all of the site collections and sites in a web application automatically.

To add all of the site collections from a web application automatically, you can use the Add Site->Import option

You can bulk import sites using a MS Excel spreadsheet.

To do this,

Click Add Site from the Home tab, then click the “Import” link.

To prepare the MS Excel file, you can get a list of your Site Collections using one of the PowerShell scripts below.

IMPORTANT: This should be a list of Site Collections to be imported. Any subsites that the account has access to will be imported automatically. You should not import using a list of subsites/SPWebs, only a list of Site Collections.

NOTE: You can use PowerShell below to get a list of All Site Collections into a CSV file and you only need to import once to get them listed.

• SharePoint On-Premise
  get-spsite -limit all -WebApplication http://yourwebapplication | Select Url | Export-CSV "C:\Users\yourusername\Documents\spsites.csv"
  
  
• SharePoint Online (Office 365)
  Download and install the SharePoint Online Management Shell: https://www.microsoft.com/en-us/download/details.aspx?id=35588
  https://technet.microsoft.com/en-us/library/fp161372.aspx
  
  #Connect to SPO $AdminUrl = “https://tenant-admin.sharepoint.com/” $UserName = “username@tenant.onmicrosoft.com” $userCredential = Get-Credential -UserName $UserName -Message "Type the password." Connect-SPOService -Url $AdminUrl -Credential $Credentials #Get Site Collections in tenant $sites = Get-SPOSite | Select Url | Export-CSV "C:\Users\yourusername\Documents\spsites.csv" #Retrieve and print all sites foreach ($site in $sites) { Write-Host $site.Url }

After you have the list of your site collections, use the steps below to create the MS Excel file for import.

• Create a new MS Excel document and add 2 columns, the first column should be “Site URL” and a second column to be “Contact Email”.
• “Site URL” is the URL of the site collection to be added to the Home Page Dashboard.
• “Contact Email” (optional, can be left blank) is the email address of the person who will receive reports for this site via email notifications. See “Contact Email” section below for more information.