Chat now with support
Chat with Support

Identity Manager 8.0 - Configuration Guide

One Identity Manager Software Architecture Working with the Designer Customizing the One Identity Manager Default Configuration Checking Data Consistency Compiling a One Identity Manager Database Working with Change Labels Basic System Configuration Data
One Identity Manager Authentication Module Database Connection Data Configuration Parameters for System Configuration Setting up the Mail Notification System Enabling More Languages for Displaying and Maintaining Data Displaying Country Information Setting Up and Configuring Schedules Password Policies in One Identity Manager Reloading Changes Dynamically TimeTrace Databases Machine Roles and Server Functions Files for Software Update Operating Systems in Use System Configuration Reports Using Predefined Database Queries Managing Custom Database Objects within a Database
The One Identity Manager Data Model Granting One Identity Manager Schema Permissions Working with the User Interface
Object definitions for the User Interface User Interface Navigation Forms for the User Interface Statistics in the 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 Language Dependent Data Representation
Process Orchestration in One Identity Manager
Declaring the Job Server One Identity Manager Service Configuration Handling Processes in the One Identity Manager
Tracking Changes with Process Monitoring Conditional Compilation using Preprocessor Conditions One Identity Manager Scripts Maintaining Mail Templates Reports in the One Identity Manager Custom schema extensions Transporting One Identity Manager Schema Customizations Importing Data Web Service Integration SOAP Web Service One Identity Manager as SPML Provisioning Service Provider Searching for Errors in the One Identity Manager Processing DBQueue Tasks One Identity Manager Configuration Files

Logging Database Queries

Use database query logging in the Report Editor to look for errors and to optimize the report during the design phase. The execution time and the command that was run are recorded.

  • Open the log window in the bottom part of the application using the option SQL log.
Table 292:

Toolbar Functions for Logging Database Queries

Icon Meaning
Starts logging database queries.
Stops database query logging.
Copies recorded data to the clipboard.
Save logged data in a file.
Deletes the recorded data.
Displays the recorded data in an editor.

Creating and Editing Reports

Create and edit reports with the Report Editor program. Reports are stored in the database table DialogReport. The following steps are required to create a report:

  1. Defining report properties, data sources and report parameters
  2. Designing the report form with the Report Designer

Predefined reports supplied with the One Identity Manager by default, automatically customized during schema installation. If you need to make changes to a default report:

  1. Create a copy of the report.
  2. Edit the required report properties.
  3. Use the customized report from now on.

When you add or copy a report, the property dialog box opens first, which you use to enter the general data for the report, the data source required and an parameters for the report definition. Then a new report form is created in the edit view with the Report Designer. This forms the basis of the report design. Using the Report Designer’s toolbar, you can place the controls you want on the report form.

NOTE: Use the online help from Stimulsoft StimulReport.Net ( as a basis for the report design.

To create a new report

  • Select Report | New from the menu.

To copy a report

  • Select the report in the report list and select the menu item Kopieren.

    This creates a new report and the property dialog box opens. The properties in the new report are take from the original.

To edit a report

  1. Select the report in the report list and open it with double-click or with Edit from the context menu.

    This opens the report form in the Report Designer.

  2. To open the property dialog, select Report | Edit from the menu.

To edit the report properties with loading the report in the Report Designer

  • Select the report in the report list and select Edit properties... from the context menu.

    This opens the property dialog.

NOTE: After you have customized a report, you can mark it by setting change labels. Change labels are offered in the program "Database Transporter" as export criteria when a customer transport package is created.

Detailed information about this topic

General Report Properties

To edit general report properties

  • Select the tab Properties in the properties dialog box.
Table 293: General Report Properties
Property Meaning
Name Report name Label custom reports with the prefix "CCC_".
Display name

Display name of the report. The display name is available when the report is created as ReportAlias and can, for example, be used to compose the title of the report or the file name when a report is exported to a web front-end. Translate the given text using the button.

The report display name can contain variables, permitted are system variables such as report parameters. The variables are passed using a percent character.


Name of report %variable%

Description Report description. Translate the given text using the button.
Filter criteria Filter criteria for displaying the report in the web front-end.
Base table

Basis table for the report.

Category Category for classifying reports. Permitted values are the categories "Common", "Mail" and "Attestation".
Preprocessor condition Preprocessor conditions can be added to reports. In this case, a report is only available if the preprocessor condition is fulfilled.
Custom properties

Enter additional company specific information. Enter display names, formats and templates for the input fields (by default Spare field no. 01 to spare field no. 10) with the Designer to meet your requirements.

Extended properties An extended property is the UID under which the report is stored in the database.
Related Topics

Creating a Data Source

For each report you need to create a data source from which to read the report data to be displayed. Normally one data source is sufficient for one report. However, you can define several data sources for each report.

To edit a data source

  1. Select the Data source tab in the properties dialog box.
  2. Select the data source from Defined queries.

    - OR -

    Click Add.

    This creates a new data source.

  3. Edit the data source properties.

To delete a data source

  1. Select the Data source tab in the properties dialog box.
  2. Select the data source from Defined queries.
  3. Click Delete.

You can test the results while processing a data source.

To test a data query

  1. Select the Data source tab in the properties dialog box.
  2. Select the data source from Defined queries.
  3. Click the button next to Query module.

    The result of a data source is shown in a separate dialog.

NOTE: When a data query is copied to the clipboard, a database query is generated in SQL syntax that you can run on the database with an appropriate query tool. To copy the data query, use the button next to Query module.

Detailed information about this topic
Related Topics
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating