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

Using reports in statistics

In the Manager's info system, you can display reports that you create in the Report Editor as statistics. To do this, you must alter the user interface of the Manager program. The report opens when you double-click on the statistic's header.

To display a report as a statistic

  1. In the Designer, create a user interface form.

    1. In the Designer, select the User interface > Forms > User interface forms category.

    2. Select the Edit form task.

    3. Select the Form > Insert menu item.

    4. Edit the interface form's main data.

      Take the following cases into account:

      • Use the VI_Report form definition

        This form definition is configured to display in the graphical user interface and web applications. You only need to set up one interface form for this. Which form template will be used to display the interface form is decided dynamically, depending on usage.

      • In the form's configuration data, pass the name of the report to run (DialogReport.ReportName) in the Properties section.

        Syntax:

        <DialogSheetDefinition FormatVersion="1.0">

        <Properties>

        <Property Name="ReportName">ReportName from the DialogReport</Property> table

        </Properties>

        </DialogSheetDefinition>

    5. Assign the user interface form to the applications and permissions groups.

  2. In the Designer, create a menu item.

    1. In the Designer, select User interface > User interface navigation category.

    2. In the User Interface Editor, select the menu item for the statistics item to show the report.

    3. Select New.

    4. Edit the main data of the menu item.

    5. Assign the menu item to the Manager application and permissions groups.

  3. Assign the user interface form to the menu item.

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

Related topics

Using simple reports in statistics

Simple reports that you create in the Manager can be displayed as statistics in the Manager's info system. To do this, in the Designer, you must alter the user interface of the Manager program. In the Manager's info system, the report opens when you double-click on the statistic's header.

For more information about how to create reports in the Manager, see the One Identity Manager Report Subscriptions Administration Guide.

To display a simple report in the statistics

  1. In the Designer, create a user interface form.

    1. In the Designer, select the User interface > Forms > User interface forms category.

    2. Select the Edit form task.

    3. Select the Form > Insert menu item.

    4. Edit the interface form's main data.

      Take the following cases into account:

      • Use the VI_Report form definition.

        This form definition is configured to display in the graphical user interface and web applications. You only need to set up one interface form for this. Which form template will be used to display the interface form is decided dynamically, depending on usage.

      • In the form’s configuration data, enter the UID of the simple report (RPSReport.UID_RPSReport) in the Properties section.

        Syntax:

        <DialogSheetDefinition FormatVersion="1.0">

        <Properties>

        <Property name="UIDRPSReport">UID_RPSReport from the RPSReport</Property> table

        </Properties>

        </DialogSheetDefinition>

    5. Assign the user interface form to the Manager program and the permissions groups.

  2. In the Designer, create a menu item.

    1. In the Designer, select User interface > User interface navigation category.

    2. In the User Interface Editor, select the menu item for the statistics item to show the report.

    3. Select New.

    4. Edit the main data of the menu item.

    5. Assign the menu item to the Manager application and permissions groups.

  3. Assign the user interface form to the menu item.

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

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 ElementValue column and the identifier for ElementName column are used to label the diagram.

Figure 17: 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 ElementValue column and the identifier for ElementName column are used to label the diagram.

Figure 18: 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 that are entered in the statistic definition from the history data. Click with the mouse on a point of measurement and a tooltip showing the measurement is displayed.

Figure 19: 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 56: Meaning of the colors
Color State

Green

correct

Yellow

acceptable

Red

unacceptable

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

Figure 20: 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 ElementValue column and the identifier for ElementName column are used to label the diagram.

Figure 21: 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 ElementValue column and the identifier for ElementName column are used to label the diagram.

Figure 22: 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 23: Table example

Examples of statistic definitions

Example 1:

The number of people in the company should be displayed in the statistics. This statistic should be calculated daily. The statistics definition could look like:

Statistic:

CountIdentities

Display name:

Number of identities

Description:

Finds the number of identities in the company on a daily basis.

Calculation schedule:

Calculate statistics

Measurements query:

select 'Identities' as ElementName, count (*) as ElementValue from Person

To display the statistics in the Manager in the Identities > Info system category, the following menu item is created:

Menu item:

Person.InfoSystem.CountIdentities

Item type:

Statistics

Sort order

1

Statistic:

Number of identities

Diagram type:

Thermometer

The menu item is assigned to the Manager program and an application role and can then be displayed in the Manager.

Example 2:

The number of external identities in the company should be displayed in the statistics. This statistic should be calculated weekly. If more than 20% of identities in the company are externals, the info system should display the state as acceptable instead of a correct. If more than 80% are externals the state should be unacceptable.

Statistic:

CountExternalIdentities

Display name:

Number of external identities.

Description:

Find the number of external identities in the company on a weekly basis.

Calculation schedule:

Calculate weekly statistics

Measurements query:

Select 'Identities' as ElementName, Count (*) as ElementValue

from Person where IsExternal = 1

Base measurements query:

Select 'Identities' as ElementName, Count (*) as ElementValue

from Person

Threshold green:

0.2

Threshold red:

0.8

To display the statistics in the Manager in the Identities > Info system category, the following menu item is created:

Menu item:

Person.InfoSystem.CountExternalIdentities

Item type:

Statistics

Sort order

2

Statistic:

Number of external identities.

Diagram type:

Traffic light

The menu item is assigned to the Manager program and an application role and can then be displayed in the Manager.

Example 3:

The number of identities, for which the current user is entered directly as manager, should be represented in a statistic. Restrictions to the values for the current user are made though a condition.

Statistic:

CountIdentitiesPersonHead

Display name:

Number of direct reports.

Description:

Finds the number of identities for which the manager is responsible on a daily basis.

Calculation schedule:

Calculate statistics

Measurements query:

select XObjectKey as ElementObjectKey, 'Identities' as ElementName, Count (*) as ElementValue

from Person where IsExternal = 1

Group by XObjectKey

Condition:

ElementObjectKey in

(select XObjectKey from Person where uid_PersonHead = '%useruid%')

Configure the web project in the Web Designer, to display statistics in the Web Designer Web Portal info system.

Example 4:

Internal and external identities, which the current user supervises as department manager, should be represented in a statistic. Departments are added here separately to determine clear results for displaying the measurement because a department manager might be responsible for more than one department.

Statistic:

IdentityCountInternalExternal_By_Department

Display name:

Number of internal and external identities

Description:

Finds the number of internal and external identities per department on a daily basis.

Calculation schedule:

Calculate statistics

Measurements query:

select d.XObjectKey as ElementObjectKey, 'Internal' as ElementName, count(p.uid_person) as ElementValue

from Department d Left Outer Join Person p on p.UID_Department = d.UID_Department and p.IsExternal = 0

Group By d.XObjectKey

UNION ALL

select d.XObjectKey as ElementObjectKey, 'External' as ElementName, count(p.uid_person) as ElementValue

from Department d Left Outer Join Person p on p.UID_Department = d.UID_Department and p.IsExternal = 1

Group By d.XObjectKey

Condition:

ElementObjectKey in

(select d.XObjectKey from Department d join helperheadorg hpo on d.UID_Department = hpo.UID_Org where hpo.UID_PersonHead = '%useruid%')

Aggregate function

SUM

Configure the web project in the Designer, to display statistics in the Web Designer Web Portal info system.

Example 5:

Ten identities with the highest risk index should be found and displayed in a statistic. They should be sorted by measurement unit.

Statistic:

Top10ActiveIdentitiesByRiskIndex

Display name:

Top 10 active identities by risk index

Description:

Find ten active identities with the highest risk indexes on a daily basis.

Calculation schedule:

Calculate statistics

Measurements query:

select top 10 p.InternalName as ElementName,

Round(100 * IsNull(p.RiskIndexCalculated, 0), 0) as ElementValue,

p.XObjectKey as ElementObjectKey,

ROW_NUMBER() over (order by IsNull(p.RiskIndexCalculated, 0) desc, p.InternalName) as ElementOrder

from Person p

where p.IsInActive = 0

order by ElementOrder

Configure the web project in the Web Designer, to display statistics in the Web Designer Web Portal info system.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating