Site Collections Inventory

This report gives you an easy way of exporting your Site Collections Inventory. The inventory is a complete list of items contained within a Site Collection.

You get all the basic information, such as site address, size, last modified date, total number of subsites, site owners, and administrators.


  • Build a Site Collection inventory of all your farms
  • Make sure that all your site collections have an owner and a secondary owner
  • List all the site collections you'll migrate to build your migration strategy
  • Know your Site Collections' size
  • Create detailed and interactive reports to present to your managers


  • Add or remove administrators to/from Site Collections
  • Set a new description
  • Set a new title
  • Manage Site Collection features
  • Add new audit events or remove them
  • Set a new value for days of audit log data to retain
  • Enable or disable the trimming of the audit log
  • Disable anonymous access or enable it for entire site or only lists & libraries
  • Enable or disable SharePoint Designer access
Site Collection report results


This is THE report for all SharePoint Administrators. A big part of your job is keeping an eye on your farms- you should always know what’s in them, who has access to what and what’s going on in there. What size are my Site Collections? How many subsites do they have? Are they all complying with our rules and policies?

Unfortunately, there's no way of building a Site Collection inventory directly within SharePoint.

Some companies have strict governance plans that contain a clear set of rules to follow when creating and storing content, which gives a certain control to administrators. But even if you don't have a governance plan, you want to learn more about the usage of your environments to make the right decisions going forward.

Technically, you could gather some of these details manually within your SharePoint Site Collections by going into the settings page, but you would lose an incredible amount of time.

The Site Collections Inventory is the ultimate report to gain insights on your SharePoint and Office 365 environments. Build a complete Site Collections inventory with this report.

You can easily overview all the details of your Site Collections within your farm or in multiple farms. By default, this report will give you the most important information: Title of the Site collection, Site Address, Size of your Site Collections, Last Modified Date, Total number of subsites of each Site Collection, Site Owner(s), and Administrator(s). This will help you maintain a detailed inventory of your farms.

Sharegate gives you the ability to sort your results per column. This can be useful to, for example, view which Site Collections are using too much storage. Take a quick look at the owners’ column to know who to contact to solve the storage issue. It’s easy as that!

Of course, you can just as easily add new columns to tailor your search results to your needs. Get more insights on your Site Collections:

  • Site Collection Description
  • Number of child subsites
  • Site Depth
  • Site Level
  • Language
  • Master Page
  • Site Template
  • Global & Current Navigation Type
  • Audited events and number of Days of Audit log data to retain
  • Report storage location
  • Trim audit log is enabled or disabled
  • Anonymous Access is enabled or disabled
  • Custom Permissions is enabled or disabled

Once you've built your first Site Collections inventory, there’s so much you can do with Sharegate to edit one, or multiple Site Collections. Actions can even be performed in bulk.

For example, now it’s incredibly simple to add a new employee as administrator of a Site Collection. All you have to do is choose the Site Collections in your search results, then select the "Add Administrators" action, pick the user or group, and apply! Or use the Copy Permissions option if it's not to make him an administrator. All of this without leaving Sharegate's interface.

Exporting the Site Collection Report

As always, you can export your search results to Excel. You can also with charts, or choose any other cool way to view the information in Excel.

The Excel export can be a simple and practical way to give managers and executives in your organization an overview of what's happening in your SharePoint environment, without them needing to sift through it themselves.

When building an inventory is useful

Having an inventory of your environments can be extremely useful and can save you tons of time when performing tasks, such as:

  • Evaluating the required effort of a migration project
  • Keeping your environment organized
  • Restructuring your environment
  • Splitting large site collections into smaller ones

Before a Migration

When planning a migration, having a complete inventory of your environment will help answer important questions related to the move: Where should you start? What should you do? How should you do it? And what to expect after the project is over.

You can use it to identify all your sites, lists and libraries and map out their destination, thus allowing you to evaluate the required time and effort of a migration project

The inventory report is an incredibly useful tool when creating a plan and a roadmap for your migration.

To Keep Your Environment Organized

Having an overview of your SharePoint or Office 365 can help you to spot inconsistencies, unused lists or libraries, inactive owners, and more. This makes it faster and easier to keep your site collections clean and organized!

Restructure your Environment & Split Large Site Collections into Smaller Ones

Export a detailed list of everything in your site collection to easily move elements around, plan the split of larger site collections, and plan the restructuring of your environment.

Save time, keep tabs on your tenant, manage change. All in one place.

See for yourself with a free, full-featured 15-day trial.