Migration Assessment Scan: Large Lists

Learn how to mitigate issues with Large Lists during migration.

Overview

Lists over 5,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.

Important: 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 will want to validate the large lists migrated as expected.

Scan Result Reports

LargeLists-detail.csv    This scan report provides all lists that have over 5,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 will show 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 will show 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.

Connect with an expert
Contact us
Expand your skills
Explore training

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×