Using the SharePoint Migration Tool Reports

Using the SharePoint Migration Tool reports

The SharePoint Migration Tool generates log files, summary and task level reports to help you manage, audit and troubleshoot your migration process.

How to view the reports

These reports can be viewed while the migration is taking place or after the jobs are complete.

Viewing task level reports:

After the migration has begun, click View task report.
A file folder will open listing the task level reports that have been generated for that specific task.

Viewing summary reports:

After migration completes, click Open Report.
A folder with the summary reports opens.

Summary Reports

Two types of summary reports are generated. The second type of summary report generated only if there is failures.

SummaryReport.csv. This report contains a single row of data that gives the total picture total size, number of files migrated, duration.
FailureSummary.csv.This report is created only when failures or errors happen during the migration process.

When assessing your migration jobs, we recommend that you first look at these summary reports. If a FailureSummary.csv file was not created, then no failures occurred during the job run.

Column	Description
Source	File path or URL of the location of the data being migrated.
Destination	The URL of the Site and library to where the data will be migrated.
Status	Status of each task (success, failure, in progress, not started)
Total bytes	Total number of bytes scanned in source destination..
Total GB	Total number of gigabytes scanned in source destination.
Count of files	Total number of scanned items
Migrated bytes	The total number of bytes of data migrated.
Migrated GB in current round	The total size of the files migrated, expressed in gigabytes.
GB not migrated in current round	The total size of the files not migrated, expressed in gigabytes.
Total scanned items	Total number of files and list items, including those that will be filtered out because of settings or potential scan issues.
Total to be migrated in current round	The total number of files that were expected to migrate excluding those filtered out based on settings or potential scan issues.
Migrated items in current round	The total number of files migrated.
Items not migrated in current round	Number of files that did not migrate.
Warning count in current round	Number of warnings generated.
Start time	The time the migration task began.
End time	The time the migration task ended.
Duration	Length of time in minutes that the migration task took to complete.
GB/hour	How many GB per migrated per hour.
Round number	The round number is the incremental number of times the report has been generated based on the multiple passes the tool made to get all the content it could into the destination.
Workflow ID	The ID number of the migration workflow. Many tasks can be in a single workflow.
Task ID	The individual task number.
Log Path	The location of the log files for each task.

This report is only generated if a failure occurs during the job run.

Column	Description
Source	File path or URL of the location of the data being migrated.
Destination	The URL of the Site and library to where the data will be migrated.
File name	Failed file or folder name or list items
Extension	If it is a folder, then the extension is empty, else if it is a file, then extension is file extension.
File size	Failed file or folder size or item size
Content type	Folder or file.
Status	Status of the file or folder that shows as "Failed" in this report.
Result category	Failed reason category based on the job process.
Message	Failed reason detail description.
Error code	Failed reason errorcode.
Package number	The package number for the package includes the failed item .
Migration job ID	The job id for the package includes the failed item.
Incremental round	The last incremental round number that item failed.
Task ID	The individual task number.
Device name	The name of the device or computer that is running the migration job.

Task Reports

When you need to do some deeper investigation or simply verification of your migration task, the task level reports help you drill down into the specific details. The four recommended task level reports to use are:

FileSummary.csv: This is similar to the overall summary report except that it aggregates the data just for a single task.
FilesFailureReport.csv: This is the failure report at the item level. This is a filtered version of the filese report, showing only failures.
FilesReport.csv: A list of all the items this task attempted to do
ScanSummary.csv: This report gives statisticall totals.
StructureReport.csv
StructureFailureReport.csv
StructureFailureSummary.csv

The FilesSummary.csv report is a summary report at the task level.

Column	Description
Incremental round	The round number added to the end of the report name (RO, R1, etc.) indicates if the scan or job has been rerun.
Scanned	Total number of files scanned before migration.
Item scan failures	Number of files that failed the scan and doesn't qualify for the migration.
Filtered out items	Number of files not included in migration.
Expected migrated file count	The total number of files that were expected to migrate excluding those filtered out based settings or scanned potential issues. The total number of files that were expected to migrate.
Read	Total number of files read.
Packaged	Total number of files packaged and ready to upload to the destination.
Uploaded	Total number of files attempted to upload.
ReUploaded	The total number of files that were re-uploaded.
Submitted	Total number of files submitted.
ReSubmitted	Total number of files resubmitted.
Migrated	Total number of files migrated.
Failed reading	Number of files that encountered an error or failure while being read.
Failed packing	Number of files that encountered an error or failure while being packaged.
Failed uploading	Number of files that encountered an error or failure while being uploaded.
Failed submitting	Number of files that encountered an error or failure while being submitted.
Failed querying	Number of files that encountered an error or failure while being queried.
Device name	Name of the device or computer that is running the migration job.

The FilesFailureReport.csv, is only generated if an error resulting in a file being unable or failing to migrate.

Column	Description
Source	File path or URL of the location of the data being migrated.
Destination	the URL of the tenant and library to where the data will be migrated.
Item name	The name of the file migrated.
Extension	The extension, indicating the file type.
Item size	The size of the individual file.
Content type	The file type.
Status	Status indicating at what stage the file is.
Result category	General code associated with the item to indicate what happened with that item.
Message	Detailed error or informational message .
Error code	Failed reason error code.
Source item ID	ID of the item at the source.
Destination item ID	ID ofthe item at the destination.
Package number	ID generated for the package number during the transition.
Migration job ID	The ID number of the job (which could contain one or more tasks).
Incremental Round	The round number added to the end of the report name (RO, R1, etc.) indicates if the scan or job has been rerun.
Task ID	The ID number of the Task.
Device name	Name of the device or computer that is running the migration job.

The FilesReport.csv is a detailed report that provides data on each file within the task.

Column	Description
Source	File path or URL of the location of the data being migrated.
Destination	the URL of the tenant and library to where the data will be migrated.
File name	The name of the file migrated.
Extension	The extension, indicating the file type.
File size	The size of the individual file.
Content type	The file type.
Status	Status indicating at what stage the file is.
Result category	General code associated with the item to indicate what happened with that item.
Message	more detailed Error or informational message generated.
Source item ID	ID of the item at the source.
Destination item ID	ID ofthe item at the destination.
Package number	ID generated for the package number during the transition.
Migration job ID	The ID number of the job (which could contain one or more tasks).
Incremental round	The round number added to the end of the report name (RO, R1, etc.) indicates if the scan or job has been rerun.
Task ID	The ID number of the Task.
Device name	Name of the device or computer that is running the migration job.

The ScanSummary.csv report provides the total stats for the scan -- a process that takes place before the actual migration begins.

Column	Description
Incremental round	The round number added to the end of the report name (RO, R1, etc.) indicates if the scan or job has been rerun.
Total scanned items	Total number of folders, list items and files that have been scanned.
Total scanned folders	Total number of folders scanned.
Total scanned list items	Total number of list items scanned.
Total scanned files	Total number of files scanned.
Folders with issues	The number of folders with potential issues for the migration.
Items with issues	The number of files with potential issues for migration.
Items filtered out	Number of files that where filtered out based on settings in the tool.
Folders to be migrated	Number of folders that will be migrated.
Items to be migrated	Number of files that will be migrated.
Total items to be migrated	Total number of folder and files that will be migrated.
Device name	Name of the device or computer that is running the migration job.

Structure report

Structure report at the task level.

Column	Description
Structure type	Site collection, site, list, field, content type, view
Structure title	Display name of the object
Operation	Skipped, created or updated.
Status	Success, partial success, failure
Details	Reason for failure.
Source structure URL	Display the source URL. Site collection, site, and list will list the URL. Fields, content type. and view will display its container's URL.
Destination structure URL	Display the source URL. Site collection, site, and list will list the URL. Fields, content type, and view will display its container's URL.
Source structure ID	ID when available.
Destination structure ID	ID when available.
Time stamp	The time at which the action occurred.

Structure failure report

This is a failure report at the task level. This report will only be generated if there is a failure.

Column	Description
Structure type	Site collection, site, list, field, content type, view
Structure title	Display name of the object
Operation	Skipped, created or updated.
Status	Success, partial success, failure
Details	Reason for failure.
Source structure URL	Display the source URL. Site collection, site, and list will list the URL. Fields, content type. and view will display its container's URL.
Destination structure URL	Display the source URL. Site collection, site, and list will list the URL. Fields, content type, and view will display its container's URL.
Source structure ID	ID when available.
Destination structure ID	ID when available.
Time stamp	The time at which the action occurred.

Structure failure summary

This is an aggregate of all the task failure reports. This will only be generated if there are failures.

Column	Description
Structure type	Site collection, site, list, field, content type, view
Structure title	Display name of the object
Operation	Skipped, created or updated.
Status	Success, partial success, failure
Details	Reason for failure.
Source structure URL	Display the source URL. Site collection, site, and list will list the URL. Fields, content type. and view will display its container's URL.
Destination structure URL	Display the source URL. Site collection, site, and list will list the URL. Fields, content type, and view will display its container's URL.
Source structure ID	ID when available.
Destination structure ID	ID when available.
Time stamp	The time at which the action occurred.

Using the SharePoint Migration Tool Reports