Chat now with support
Chat with Support

Identity Manager 9.2.1 - Configuration Guide

About this guide One Identity Manager software architecture Customizing the One Identity Manager default configuration Customizing the One Identity Manager base configuration One Identity Manager schema basics
Overview of the One Identity Manager schema Table types and default columns in the One Identity Manager data model Notes on editing table definitions and column definitions Table definitions Column definitions Table relations Dynamic foreign key Supporting file groups
Editing the user interface
Object definitions for the user interface User interface navigation Forms for the user interface Statistics in One Identity Manager Extending the Launchpad Task definitions for the user interface Applications for configuring the user interface Icons and images for configuring the user interface Using predefined database queries
Localization in One Identity Manager Process orchestration in One Identity Manager
Mapping processes in One Identity Manager Setting up Job servers
The One Identity Manager Service functionality Tracking changes with process monitoring Conditional compilation using preprocessor conditions Scripts in One Identity Manager
Visual Basic .NET scripts usage Notes on message output Notes on using date values Tips for using PowerShell scripts Using dollar ($) notation Using base objects Calling functions Pre-scripts for use in processes and process steps Using session services Using #LD notation Script library Support for processing scripts in the Script Editor Creating and editing scripts in the Script Editor Copying scripts in the Script Editor Testing scripts in the Script Editor Testing script compilation in the Script Editor Overriding scripts Permissions for running scripts Editing and testing script code with the System Debugger Extended debugging in the Object Browser
One Identity Manager query language Reports in One Identity Manager Adding custom tables or columns to the One Identity Manager schema Web service integration One Identity Manager as SCIM 2.0 service provider Processing DBQueue tasks One Identity Manager Service configuration files

General properties statistic definitions

Table 52: Properties of a statistic definition
Property Meaning

Statistics

Name of the statistic

Display name

This display name is used to show the statistic definition in the settings for the info system in the administration tools. The display name forms the title of a statistic. Translate the given text using the button.

NOTE: If a caption is entered in the menu item, it overwrites the statistic definition display name.

Description

Description of the statistic definition. The statistic definition description is shown in the info system settings in the administration tools. Translate the given text using the button.

Calculation schedule

Select the schedule for calculating the statistic information. The Calculate statistics, Calculate weekly statistics, and Calculate monthly statistics on the 1st schedules are provided.

NOTE: In the Designer, enable the schedules for calculating statistics in the Basic data > General > Schedules category. For more information about editing schedules, see the One Identity Manager Operational Guide.

Aggregate function

Use the aggregate function if the measurements query returns several values but there should only be one value displayed in the statistics.

Example:

Determines the number of identities for which a department head is responsible. Use the SUM aggregate function to display a statistic with the total number of identities in all departments for which one person is responsible. Do not use an aggregate function to display statistics by department.

Base aggregate function

Use the base aggregate function if a unique base value cannot be attained from the measurements query.

NOTE:

  • Aggregate and base aggregate functions are only evaluated if the formulated measurement value query is limited by a condition on the logged in user.

  • Aggregate and base aggregate functions are only taken into account for statistics that are displayed in the Web Portal.

Threshold green

Threshold factor in the value range from 0 to 1. This threshold factor is used to determine the percentage of the base measurement that reflects a correct status.

Threshold red

Threshold factor in the value range from 0 to 1. This threshold factor is used to determine the percentage of the base measurement that reflects an acceptable status.

Unit of measure

Unit for measured values. The unit of measure is displayed in the info system statistics. Translate the given text using the button.

Time scale

Enter the display accuracy of the data on the time axis for statistic definitions that contain a time query (for example, the number of new identities in the last week). Permitted values are Hour, Day, Week, Month, Quarter, and Year.

Measurement runs to archive

The number of measurement run (apart from the current measurement) to be archived for displaying in the history. Enter the value 0 if you only want to retain the most recent measurement in each case.

Deactivated

Specifies whether the statistic definition is disabled. Statistic definition which are disabled are not calculated.

Preprocessor condition

You can add preprocessor conditions to statistics. This means that a statistic definition is only available when the preprocessor condition is fulfilled.

Disabled by preprocessor

If a statistic definition is excluded through a preprocessor condition, this option is set by the Database Compiler.

Instant calculation

Set this for statistic definitions, which are calculated at the moment they are displayed in the Web Portal. If this option is not set, the statistics are calculated during maintenance tasks.

Imported statistic data

Specifies whether these statistics are calculated at the moment they are displayed (for use in the Web Portal). If this option is not set, the statistics are calculated asynchronously by the DBQueue Processor.

Related topics

Querying statistic measurements

Table 53: Measurement query properties
Property Meaning

Measurements query

Enter the complete database query in SQL syntax to determine the statistic measurements. The query must return the ElementName and ElementValue columns as results.

To display statistic information in the Web Portal, you can also optionally output the ElementObjectKey, ElementObjectKey2, and ElementValue2 columns.

You can, optionally, control the display order of statistic measurements with the ElementOrder column. If the ElementOrder column does not exist, they are sorted by the ElementName column.

Base measurements query

Enter the complete database query in SQL syntax to determine the statistic measurements. The query must return the ElementName and ElementValue columns as results.

To display statistic information in the Web Portal, you can also optionally output the ElementObjectKey, ElementObjectKey2, and ElementValue2 columns.

You can, optionally, control the display order of statistic measurements with the ElementOrder column. If the ElementOrder column does not exist, they are sorted by the ElementName column.

The threshold factors entered in the fields Threshold green and Threshold red refer to the result in the ElementValue column. To determine the base measurement percentage, the result from column ElementValue is applied with 100%.

NOTE: The name of the ElementName column in the base measurements query must match the name of the ElementName column in the measurements query.

Condition

Formulate a condition to limit the statistics data that are displayed to the current user. The condition has to be formulated as a valid WHERE clause for database queries and limits the result of the query further based on the ElementObjectKey column. To restrict the database query to the logged in user, use the "%useruid%" variable.

NOTE: The condition is only taken into account for statistics that are shown in the Web Portal.

Example: Calculating the threshold

Threshold factors are used to determine the percentage of the base measurement that reflects a correct or acceptable status.

Table 54: Example of finding the state
Base Measurements Threshold green Threshold red Percentage State

100

0.25

0.75

< = 25

correct

>25 to >75

acceptable

>= 75

unacceptable

0.75

0.25

> = 75

correct

<75 to <25

acceptable

<= 25

unacceptable

Related topics

Disabling statistics definition

You have the option to disable individual statistic elements as required. Statistic definitions that are disabled are not calculated. Predefined user statistic definitions remain disabled even after the schema has been updated.

To edit an statistic definition

  1. In the Designer, select a statistic definitions in the User Interface > Statistics definitions category.

  2. In the edit view, select the Properties view.

  3. Select the Properties tab and set the Disabled option.

  4. Select the Database > Commit to database and click Save.

In addition, statistic definitions can be disabled through pre-processor conditions.

Related topics

Including statistics in the user interface

In order to visualize statistics in the One Identity Manager administration tools, such as the Manager, you have to link the statistics into the user interface as a custom menu item.

You will typically find statistics in the Manager under the Info System navigation item in nearly any category. You should set up custom menu items for statistics under an info system like this. All statistics that are defined at one menu level are displayed on one form.

You can show reports that you create in the Report Editor or in the Manager in the statistics. In the Manager's info system, the report opens when you double-click on the statistics header.

Statistics can also be linked as form elements into overview forms. To do this, use the Overview Form Editor.

NOTE: If you set up a custom info system, ensure that the menu item under which you define the statistics, is labeled with Not expandable by user and Force open menu item.

For more information about general properties of menu items, see General menu item properties. Take note of the following properties for menu items.

Table 55: Statistics properties
Property Meaning

Entry type

Select the entry type Statistics.

Caption

The caption given here, overwrites the statistic definition caption. Leave this field empty if you want to use the statistic definition display name.

Statistics

Enter the statistic definition to be displayed.

Diagram type

Select the diagram type that is going to represent the statistic.

Alignment

Positioning of statistics on the overview form. This layout information is used if the statistic is used as a form element on an overview form.

Background

Background color of the form elements on the overview form. This layout information is used if the statistic is used as a form element on an overview form.

All menu items that are to be displayed in an application user interface have to be assigned to a permissions group and an application.

Related topics
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating