Migration Assessment Scan: External List

Overview

External lists are those lists that were created from a Business Catalogs Services [BCS] application. These are lists that appear to be SharePoint Lists, but are actually backed by an external datasource. For example, you could have a list that is showing data from an external SQL Server or Web Service.

Data Migration

BCS applications aren't migrated to the target environment. As a result, External Lists aren't migrated.

See Migration Assessment Scan: BCS for more information about BCS.

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

Build out a plan for the external lists. It's possible to configure Hybrid BCS to access on-premises data from SharePoint in Microsoft 365, but this will require some planning.

See Migration Assessment Scan: BCS for more information about BCS

Post Migration

Ensure that your solutions, which rely on the BCS applications, function with the newly deployed BCS applications.

Scan Result Reports

The following table describes the columns in the ExternalLists-detail.csv report. This scan report provides a list of all the external lists in the environment.

Column Description
SiteId
Unique identifier of the impacted site collection.
SiteURL
URL to the impacted site collection.
WebApplicationURL
URL of the Web Application hosting the 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 site that has publishing features enabled.
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 is 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.