Chatee ahora con Soporte
Chat con el soporte

Identity Manager 9.3 - 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 The full-text search in One Identity Manager 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 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 Displaying messages in the user interface Referencing packages and files in scripts 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 Committing and compiling script changes 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 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
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 Processor tasks Structure of the Jobservice.cfg configuration file

Creating and editing statistic definitions

The basis for the info system is the definition of statistics. Predefined configurations are maintained by the schema installation and cannot be edited apart from a few properties. The default configuration is moved to a configuration buffer during handling. You can retrieve changes from the configuration buffer and restore the default configuration in this way.

To create or edit a statistic definition

  1. In the Designer, select the User interface > Statistic definitions category.

  2. Select a statistic definition and then the Change main data task.

    - OR -

    To create a new statistic definition, select Object > New.

  3. Enter the general properties on the General tab.

  4. Enter the inventory query on the Queries tab.

  5. Check the queries and statistic definition for errors.

    • Use the Check query button to test each query.

      The SQL query and its result are tested for validity. This checks the number of columns, column relations, and data types.

    • Use Check button to check the entire statistic definition.

      To run the test, the statistic is saved in the database and the calculation is simulated. After simulation, the simulated test calculation is removed from the database.

  6. Select the Database > Save to database and click Save.

Detailed information about this topic

General properties statistic definitions

The following properties are displayed for statistics.

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

The following properties are displayed for querying statistic measurements.

Table 117: 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: Threshold calculation for statistics

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

Table 118: 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 > Save to database and click Save.

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

Related topics
Documentos relacionados

The document was helpful.

Seleccionar calificación

I easily found the information I needed.

Seleccionar calificación