New Advanced Date Filtering options in Cogmotive Reports
Our customers are always giving us great feedback and suggestions on how to make our product more powerful. In the past week three of our customers requested the same feature – the ability to filter reports by variable dates.
This allows you to scheduled very flexible and powerful customised reports around variable dates. These filters work both on our Custom Report and on our standard canned reports.
For example, one company may want to see a list of all the user accounts created in the past 7 days and want this report sent out every Friday morning to the HR team.
Multiple filters can be used, so this company could schedule an additional report that shows newly created users that haven’t logged in yet. This could be sent to the helpdesk team to pro-actively call the users to see if they have had trouble with their accounts.
You can currently use these advanced variable date filters on the following fields.
- Last Logon Date
- Creation Date
- In-Place Hold Date
- First ActiveSync
- Last Successful ActiveSync
- Last ActiveSync Policy Update
You can return results with a specific date or that have dates greater or less than the date specified.
Here are some examples
If you want to show all results with a specific date, you should use the Contains operator and specify the date in the YYYY-MM-DD format.
You can also use English time concepts within the filter. Entering values such as Today, Yesterday and “First Day of Last Month” as well as mathematical operations such as “today -30 days”.
Before or After a Date
You can use the Less Than or Greater Than operators to return results from Before or After a certain date.
Rolling Monthly Reports
A common requirement is to schedule rolling monthly reports. This is now relatively easy by combining two date filters which will return results between two variable dates. The example below will return all users who Last Logged On in the previous month.
Combining Multiple Filters
These date filters can of course be combined with the traditional filters we already had in place to return fine grained reports showing exactly the date you require.
We’d love to hear some feedback on these new filters in the comments below!