Identity Manager 8.0 - Configuration Guide

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.

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.

Detailed information about this topic

• General Report Properties
• Creating a Data Source
• Editing Report Parameters
• Using Virtual Data Sources
• Editing the Report Form

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. Example: 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
• Editing Report Parameters

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.

Detailed information about this topic

• Data Retrieval using an SQL Query
• Data Retrieval using a Database View
• Data Retrieval using an Object
• Data Retrieval using Single Object History
• Data Retrieval using Multiple Object History
• Data Retrieval using Historical Assignments
• Data Query for Simulation Data

Related Topics

• Using Virtual Data Sources