Migration Assessment Scan: Large List Views

Learn how to mitigate issues with Large List Views during migration.

Overview

On the source environment it is possible to configure list view throttling so there are a set number of hours per day where the throttle on views is lifted. On the target platform, the stated product list limits is in place continuously (24x7). This may result in some of your list views being throttled.

Data Migration

The lists and their data will be migrated. However, the list views called out in the scan report may not be viewable post migration without performing the remediation documented in the following section, Preparing for Migration. Any list views containing over 12 lookup columns may also be throttled and require remediation. For more information, see Designing large lists and maximizing list performance..

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

Review the provided report and remediate the large list views prior to migration. For information on how to optimize list views, see Manage large lists and libraries in Office 365.

Post Migration

Ensure the lists that you remediated are rendering correctly.

Scan Result Reports

FileName: LargeListViews-detail.csv    This scan report contains list views that were either throttled, or will potentially be throttled in the near future once you migrate to the new platform. The report contains list views that meet one of the following criteria:

  • Returned greater than 3,000 items.

  • Actively throttled on the scanned environment.

  • Contains greater than 12 lookup columns.

  • Configured as an aggregate view.

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.

LookupColumnCount

ListViewTitle

The title of the impacted list view.

DefaultView

True/False. Determines if the view is the default view for the list.

AggregateView

True/False. Determines if the view is an aggregate view. For example, the view is configured to display a Total.

ListViewThrottled

True/False. Specifies whether the list view was actively throttled on the scanned environment.

ViewItemCount

Number of items returned when the list view was executed. This field is empty if ListViewThrottled is True.

Hidden

True/False. Specifies if the list view is configured to be hidden from end users.

ReadOnlyView

True/False. Specifies if the list view is configured to be read only.

WebURL

Url to the subsite that contains the list view.

ListTitle

Title of the list the list view is associated with

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.

×