Chat now with support
Chat with Support

Identity Manager 8.1 - Configuration Guide

About this guide One Identity Manager software architecture Customizing the One Identity Manager default configuration Adjusting the One Identity Manager base configuration One Identity Manager schema basics 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
Setting up Job servers in Designer Configuring the One Identity Manager Service Handling processes in One Identity Manager
Tracking changes with process monitoring Conditional compilation using preprocessor conditions Scripts in One Identity Manager Reports in One Identity Manager Adding custom tables or columns to the One Identity Manager schema Web service integration SOAP Web Service One Identity Manager as SPML provisioning service provider Processing DBQueue tasks Appendix: Configuration files of the One Identity Manager Service

General properties of a statistic definition

Table 56: 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 schedules Calculate statistics, Calculate weekly statistics and Calculate monthly statistics on the 1st are provided.

NOTE: Enable the schedules for calculating statistics in the category Basic data | General | Schedules in the Designer. For detailed 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 employees for which a department head is responsible. Use the SUM aggregate function to display a statistic with the total number of employees 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.

NOTE: 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 employees 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.
Disabled 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 57: 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 columns ElementName and ElementValue as results.

You can also optionally output the columns ElementObjectKey, ElementObjectKey2 and ElementValue2 for displaying statistic information in the Web Portal.

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

Base measurements query

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

You can also optionally output the columns ElementObjectKey, ElementObjectKey2 and ElementValue2 for displaying statistic information in the Web Portal.

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

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: ElementName in the base measurements query must match the name of ElementName in the measurements query.

Condition

Formulate a condition with which the statistic measurements can be limited 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 column ElementObjectKey using the variable %UserUID%.

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

Example of Calculating the Threshold

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

Table 58: 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

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 under the category Info system in the administration tools navigation menu. 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.

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 59: 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

Diagram types for visualizing statistics

There are several diagram types available for visualizing statistics.

Bar chart

A bar chart can be used to visualize comparisons between measurements. The actual measurement of the column ElementValue and the identifier for column ElementName are used to label the diagram.

Figure 19: Bar Chart Example

Pie chart

A pie chart can be used to visualize the measurements as a percentage of the base measurement. The actual measurement of the column ElementValue and the identifier for column ElementName are used to label the diagram.

Figure 20: Pie Chart Example

Line diagram

A line diagram can be used to visualize a data sequence over a specified time period. The time axis is scaled in proportion to the time scale given in the statistic definition. The number of measurements in the line diagram results from measurement runs to archive given in the statistic definition. Click with the mouse on a point of measurement and a tooltip showing the measurement is displayed.

Figure 21: Line Diagram Example

Traffic light

A traffic light diagram can be used to visualize the state of the system. The state is indicated by the color. The threshold factors given in the statistic definition determine when which status is reached.

Table 60: Meaning of the Colors
Color State
Green correct
Yellow acceptable
Red unacceptable

The actual measurement of the column ElementValue and the identifier for column ElementName are used to label the diagram.

Figure 22: Traffic Light Example

Tachometer

A tachometer diagram can be used to visualize the state of the system in more detail than in a traffic light diagram. The base measurement is also displayed. The state is indicated by the color. The threshold factors given in the statistic definition determine when which status is reached. The actual measurement of the column ElementValue and the identifier for column ElementName are used to label the diagram.

Figure 23: Tachometer Diagram Example

Thermometer

A thermometer diagram can be used to visualize the state of the system in more detail that in a traffic light diagram. The state is indicated by a color scale on the side of the diagram. The threshold factors given in the statistic definition determine when which status is reached. The actual measurement of the column ElementValue and the identifier for column ElementName are used to label the diagram.

Figure 24: Thermometer Diagram Example

Table

This diagram type can be used to visualize the measurements in table form. Enter a number of archived measurements runs in the statistic definition, to present the data over a specified time period.

Figure 25: Table Example

Related Documents