Report on SharePoint and Office 365 with Sharegate

Wondering how to deal with the amount of data you may have to deal with in complex and large environments? With Sharegate, it’s easy! In this video, we’ll see how you can leverage Sharegate to run queries, in order to find specific information.


Out of the box, Sharegate comes with different built-in report templates categorized by the type of object you can start your search with. You will find our most popular reports in the top section. Each one can be run as-is, or can be modified if you need to customize certain values to reflect your needs.

All templates are built based on the same structure. You can see how they are built when you edit them. You first need to specify a type of object such as a Site collection, List, SharePoint group, or any other available in our menu. Then, each of the objects will have specific filters you can select from, to search and display exactly the info you need. Finally, columns, will show additional information related to the results.

When launching a report, Sharegate will ask you to select where you want to run the query. This allows you to filter and find the exact scope you want Sharegate to analyze. You can select a single target or multiple. Note that you can also navigate inside them if you need to be even more specific. Once you’ve made your selection, you can either run the report right away or schedule it and set a recurrence.

Once the report is done running, Sharegate will notify you that your results are ready. Clicking on the notification will bring you over to the result screen. There, you will be able to select items found in the results and run actions in bulk. Depending on the type of report you ran, different set of actions will be available. If you want to analyze the data further, or even send it to someone else, you can easily export this to an Excel sheet or a CSV file.

But wait, it doesn’t stop here. The provided templates aren’t exactly what you need? That’s ok, since you can fully edit them by modifying, adding, or removing filters and columns, according to your needs. You can even save your new templates!

If this still isn’t enough, you can simply build your own reports from scratch. Let’s say you want to see all site collections where a specific user is site collection admin, you can create it in just a few steps. The possibilities here are numerous so don’t hesitate to play with the filters and columns.

So, whether you are planning a migration, managing sites or simply want more visibility of your SharePoint and Office 365 environments, remember that Sharegate comes with default reports that you can run as-is or edit, you can create your own reports from scratch and of course, you can schedule them all.

Read video transcript