SharePoint Report Generation Using ShareGate

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

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