Chat with us, powered by LiveChat

Blog

Back

Filtering and Searching in Cogmotive Reports

5 Feb 2013 by Emma Robinson

This article refers to our former reporting, security, and management products. We have now integrated these products into Nova, an all-new Office 365 management platform. Find out more

Our Office 365 Reports provide a powerful range of filter and search functions to help you get exactly the information you want. This page will explain these different functions and provide some common examples.

The Filters Button

Most of our reports have a blue Report Filters button on the top right hand side. Clicking this button expands our Filtering engine which allows you to customise the data returned by the report. Using these filters you can create complex and targeted queries for the data in the report.
To get started, click the Add Filter button. You can add as many filter parameters as you wish.

  • The first box allows you to specify the AND/OR Operator. The first filter will always use AND.
  • The second box choose which Office 365 Attribute to filter on – select the one you want from the list.
  • The third box allows you to specify whether the Office 365 attribute Equals, Does Not Equal, Contains, Does Not Contain, Is Less Than, Is Greater Than the value that you put into the next box.
  • The fourth box is your search query.

When you put it all together, you can do things like this.

Recipients By Type Filtered by Mailbox Type

Recipients By Type Filtered by Mailbox Type


Mailbox Sizes Greater Than 5GB

Mailbox Sizes Greater Than 5GB


Mailbox Sizes of type UserMailbox over 5GB

Mailbox Sizes of type UserMailbox over 5GB


Mailbox Sizes of type UserMailbox over 5GB and have an E3 Licence Assigned

Mailbox Sizes of type UserMailbox over 5GB and have an E3 Licence Assigned


As you can see, powerful stuff! You can also use the Save Report button to save these filters. Click the Saved Reports section in the Navigation Bar on the left hand side to see your Saved Reports.

Searching a table

You can also use the search box at the top of the Data table to return more granular results. Simply type part of a users name or UserPrincipalName into the search box to return those results.

Search by Display Name or UPN

Search by Display Name or UPN


Some reports allow you to search for other data, such as the Mobile Device reports.
Search by other data

Search by other data


What do you think of our Search and Filter capabilities? Do you have any suggestions on how we can improve them?Let us know in the comments section below.