Introduction

The purpose of the "Locked User Accounts" report template is to allow the administrator to create reports showing all users with locked accounts.

The report can be found by navigating to "Administration | Reports", then scrolling down to the report "Locked User Accounts";

Creating a report using the "Locked User Accounts" template

To create a report based on locked users you will need to use the context menu option "Create" for the report template "Locked User Accounts" (highlighted template above).

Using the "Condition Builder" tool to filter reported records

If no conditions are specified, then the report will list all locked users, 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
DomainUnit
Login NameStatus
First NameDescription
Last NameFail Count
TokensLast Change Password
Last Login

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 that will search the all locked users in the domain "spt.deepnetid.com".




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";

For this report we want to search for user details for the user with login name of "TestUser";

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 all currently locked users in the specified domain;