Filtering and Searching in Cogmotive Reports
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
Mailbox Sizes Greater Than 5GB
Mailbox Sizes of type UserMailbox over 5GB
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
Some reports allow you to search for other data, such as the Mobile Device reports.
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.