Introduction

The purpose of the "Users have been inactive for over n days" report template is to allow the administrator to create reports showing details for all users that have been inactive for a specified number of days.

The report can be found by navigating to "Administration | Reports", then scrolling down to the report "Users have been inactive for over n days";

Creating a report using the "Users have been inactive for over n days" template

To create a report based on user details you will need to use the context menu option "Create" for the report template "Users have been inactive for over n days" (highlighted template above).

Using the Query Statement Tool

If no conditions are specified, then the report will list details user details, but filters can be applied to the report result using the query statement tool.

Report Scheduling

Whilst the report can be run manually from the management console, it is possible you might want to schedule the report to run a specific times automatically.

This can be achieved by use the report scheduling option;

Using the "Condition Builder" tool to filter reported records

If no conditions are specified, then the report will list details all tokens, but  additional conditions can be added that filter which records are included in the report.

Condition filters are added using the "Condition Builder" tool that is used to construct the Query Statement and is employed using the icon.

Filters may be applied based on any of the following fields;

Report Scheduling

Whilst the report can be run manually from the management console, it is possible you might want to schedule the report to run a specific times automatically.

This can be achieved by use the report scheduling option;

Configuring Report Output 

The default layout and contents of the report can be customised using the button.

The purpose of the configuration feature is to specify which of the available field are to be listed in the report columns.

In the following table the items listed as included are listed in the report columns, whilst the optional items are not included in the report;

IncludedOptional

Domain

Unit
Login NameStatus
First NameDescription
Last NameFail Count
TokensLast Change Password
Last Login
Last Updated

Running and Exporting the Report

The newly created report will now be listed in the "Reports" tab (listed under the name that you gave your report, and should be at the end of the list).

Example Report

In the following example report we will create a report all users that have been inactive for more than 20 days.




We start by naming our report and providing a suitable description, then we click on the icon in order to build our query statement;.

A new window now opens titled "Condition Builder";

This report needs to know how many inactive days should be reported so we need to supply the required inactive days condition;

We don't need any additional conditions so we click to build the condition, and the Query Statement parameter is updated;










After the report has been saved and run, we will find that the exported report shows all users that have been inactive for more than 20 days;