MigrationTool Sharegate has a special reporting services feature, which can provide more information about the OnPrem & Cloud Environment.

Key Reporting Features.
  • Site Collection Size
  • No of SubSites.
  • Workflows Present
  • Checked out Files.
  • Files having no version.
  • Large List
  • Custom Master Pages/ List
  • Custom Access Enabled etc.,
SharePoint
This blog is about how to capture the Site Level Information and workflows information using the Sharegate reporting services.

Site Level Report Generation

Reporting - Site Report

SharePoint

Select the Required Columns such as Sub Site Count, Created Date.

SharePoint
Click Save & Continue
SharePoint

Select the Target - Navigate

SharePoint

Search for the Site

SharePoint

Run Report

SharePoint
SharePoint
SharePoint
The Data can be exported to Excel & validated.
This Site Level Report doesn't consist of Workflows information. We need to choose the List Level Reporting Options for fetching the workflow information.
List Level Reporting Services
SharePoint

List Columns Selection- Remove the Filters (-)

SharePoint

Select the Target Site for which you need a report.

SharePoint
Search for the Site Collection or Site
SharePoint

Target List Library Selection - Run Now.

SharePoint

Sample Report Screen, The Report can be exported to Excel file also.

SharePoint
Advantages
  • We can clear & complete information about the OnPrem & Office 365 Sites.
Disadvantages
  • Won't work for Moss 2007 Sites/ Site Collections.
  • We can't find InfoPath related information.
  • We can't find how many workflows there are, only we can check whether the list is having workflows or not.
There is an option called inventory which can provide more information about the site collections as well sub-site with a number of workflow counts associated with the site.
SharePoint