Back to blog

New Feature: Compare specific site collections using new filtering option

Mar 14, 2016 by Emma Robinson

Here at Quadrotech, we are constantly adding to both the range of reports we offer and the additional features and capabilities to make sure you can get exactly the information you need on Office 365. Our latest addition is the option to filter reports for any combination of site collections. A site collection contains a single top-level site and multiple sub-sites below it, that share common navigation, template galleries, content types, web parts, and permissions. Until now, if you had a number of SharePoint site collections you could see reports either for all of them, or just one.

While this was useful if you needed to drill-down into a single SharePoint site or get an organization-wide overview, it had limitations in terms of getting exactly the data you needed – but not anymore.


With the new filtering capabilities, you are now able to generate reports for just the specific site collections you want to see, enabling you to get the data you need quickly and easily. The possibilities are endless!

Here’s an example of how this might come in handy:

A large, multi-national organisation has a ‘Marketing’ site collection in SharePoint Online for each country in which it operates, this is 150 sites in total. Brian, the Head of Global Marketing at XYZ corp. asks each country to move all their team documents and assets into SharePoint Online, in order to enable collaboration and consistency between remote locations. Upon doing this, some teams realised that the current SharePoint Online admin settings were incorrect. There should have been one or two admins for each country, including the head of department, but instead they found that some of these staff were not able to make the required changes.

After multiple complaints and a lot of confusion, Brian needed to get this sorted. Using the filtering function in the SharePoint Site Collection Administrators Report, Brian was able to select and compare the specific collections he needed without sifting through all of the organisation’s sites. He could quickly identify who was currently an administrator for each country’s site, and share this information with each team, so that the problem could be addressed and resolved.


As you can see above, any number of sites can be selected for comparison.

If you have a large number of SharePoint site collections (hundreds or thousands even), it is still easy to filter this information using the built-in search functionality to identify and select your chosen sites. An example of this can be seen in the image below.


If you need to report on a combination of your SharePoint site collections and you’re an existing Quadrotech customer, sign in now and give it a go!

If you want to try the feature out using demo data, visit the live demo of both Office 365 Reports and SharePoint Online Reports, which you can try here.

Alternatively, if you’re new to Quadrotech, and want to try this new feature using your own environment and data, why not learn more about our Office 365 reporting software.