Migration Assessment Scan: Large Lists
Learn how to mitigate issues with Large Lists during migration.
Overview
Lists over 20,000 items have historically caused issues with the migration tooling, making the ability to predict the time it takes to migrate sites that contain a larger list to be problematic.
Data Migration
List data is migrated. However, the larger the list the more unpredictable the migration process has proven. Extremely large lists can result in an extended migration.
Note
Any site that is configured as "No Access" (locked), in SharePoint will be skipped. To see a list of locked site collections see the Locked Sites scan output.
Preparing for Migration
Investigate the large lists and determine the need for this content to be migrated to the target environment.
Post Migration
The migration tooling has built-in validation to ensure all the list items are migrated. You'll want to validate the large lists migrated as expected.
Scan Result Reports
LargeLists-detail.csv This scan report provides all lists that have over 20,000 items.
| Column | Description |
|---|---|
| SiteId |
Unique identifier of the impacted site collection. |
| SiteURL |
URL to the impacted site collection. |
| SiteOwner |
Owner of the site collection. |
| SiteAdmins |
List of people listed as site collection administrators. |
| SiteSizeInMB |
Size of the size collection in megabytes [MB] |
| NumOfWebs |
Number of webs that exist in the site collection. |
| ContentDBName |
Name of the content database hosting the site collection. |
| ContentDBServerName |
SQL Server hosting the content database. |
| ContentDBSizeInMB |
Size of the content database hosting the site collection. |
| LastContentModifiedDate |
Date/Time the site collection had content modified. |
| TotalItemCount |
Total number of items found in the site collection. |
| Hits |
Number of requests logged for the site collection. Relies on data from the usage logging service. If the usage logging service is disabled this row shows N/A. |
| DistinctUsers |
Number of distinct users that have accessed the site collection. Relies on data from the usage logging service. If the usage logging service is disabled this row shows N/A. |
| DaysOfUsageData |
Number of days the usage logging service retains data. This provides context for Hits and DistinctUsers. For example, if this is 14 days, the Hits and DistinctUsers data is for the last 14 days. |
| WebURL |
Url to the subsite that contains the list. |
| ListTitle |
Title of the list. |
| ListURL |
Url to the root folder of the list. |
| ListItemCount |
Number of items in the list. |
| ListTemplate |
Template used when creating the list. |
| ListType |
The type of list configured. |
| ListCreator |
User that created the list. |
| ItemLastModifiedDate |
Date/Time an item was last modified on the list. |
| ScanID |
Unique identifier assigned to a specific execution of the SharePoint Migration Assessment Tool. |