NOTE: Reports with historical data changes analyze data changes in a One Identity Manager History Database. If the One Identity Manager History Database is linked by an ID to the database’s TimeTrace, you must log in to the Report Editor through an application server that has this ID in its configuration file (web.config). For more information about connecting to the One Identity Manager History Database through an application server and the required configuration, see the One Identity Manager Data Archiving Administration Guide.
Create and edit reports with the Report Editor program. Reports are stored in the database DialogReport table. The following steps are required to create a report:
-
Defining report properties, data sources, and report parameters.
-
Designing the report form with the Report Designer.
Predefined reports supplied with One Identity Manager by default, automatically customized during schema installation. If customizations are required to the default reports:
-
Create a copy of the report.
-
Edit the required report properties.
-
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 (www.stimulsoft.com) as a basis for the report design.
To create a new report
To copy a report
-
In the Report Editor, select the report in the report list and then, in the context menu, click Copy.
This creates a new report and the property dialog opens. The properties in the new report are take from the original.
To edit a report
-
In the Report Editor, select the report in the report list and open it by double-clicking or clicking Edit in the context menu.
This opens the report form in the Report Designer.
-
To open the property dialog, select the Report > Edit menu item.
To edit the report properties without loading the report in the Report Designer
-
In the Report Editor, select the report in the report list and then 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. These change labels are offered in the Database Transporter as export criteria when a customer transport package is created.
Detailed information about this topic
To edit general report properties
-
In the Report Editor, open the report.
-
Select the Properties tab in the properties dialog.
-
Edit the general properties.
-
Save the changes.
Table 150: General report properties
|
Name |
Report name Label custom reports with the CCC_ prefix. |
|
Display name |
Display name of the report. The display name is available when the report is created as ReportAlias. It can, for example, be used to compose the title of the report or the file name when you export a report in the Web Portal. 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% |
|
Max. runtime [sec] |
Maximum number of seconds available to generate the report If this period is exceeded, the report stops generating. |
|
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 Common, Mail, Attestation, and Dashboard categories. |
|
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 > Spare field 01 ... Spare field no. 10 |
Additional company-specific information. Use the Designer to customize display names, formats, and templates for the input fields. |
|
Extended properties > Report |
UID for finding the report in the database. |
Related topics
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. You can test the results while processing a data source.
To edit a data source
-
In the Report Editor, open the report .
-
Select the Data source tab in the properties dialog box.
-
Select the data source from the Defined queries list.
- OR -
Click Add.
This creates a new data source.
-
Edit the data source properties.
-
Save the changes.
To test a data query
-
In the Report Editor, open the report .
-
Select the Data source tab in the properties dialog box.
-
Select the data source from the Defined queries list.
-
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, which you can run on the database with an appropriate SQL query tool. To copy the data query, use the 
button next to Query module.
To delete a data source
-
In the Report Editor, open the report .
-
Select the Data source tab in the properties dialog box.
-
Select the data source from the Defined queries list.
-
Click Delete.
-
Save the changes.
Detailed information about this topic
Related topics
Data queries with the SQL query module are run directly on the database without checking user access permissions. This means that a column to be used in the report is displayed even though the user may not have access permission to it.
Table 151: Data source SQL properties
|
Name |
Name of the data source. |
|
Description |
Description of data source. |
|
Max. lines |
Maximum number of result lines for this query.
NOTE: The report only displays results up to this maximum even if the number of results exceeds it. In the default, no error messages or tips are displayed. Any possible messages must be customized in the report. |
|
Parent query |
Not used. |
|
Query module |
Select the SQL query module. |
|
Query |
Full database query SQL syntax. The query must contain all the columns used in the report. You can also use SQL parameters in the query. Add these parameters subsequently to the report by entering them on the Parameters tab.
Syntax for parameters:
@<parameter name>
Syntax for parameters of Date data type and a scope (time period from/until):
@<parameter name>Start
@<parameter name>End
Example of usage in the SQL query:
and StartDate between @<parameter name>Start and @<parameter name>End |
Example:
The query should return the employees (Person table) assigned to an department. The department (UID_Department) is found with the object key (XObjectKey). This is passed as a parameter to the report. The query queries employee‘s first name (firstname), last name (lastname), and department name (departmentname).
Select Firstname, Lastname, Departmentname
from person join Department
on person.uid_Department = department.uid_Department
where Department.XObjectKey = @ObjectKeyBase
Related topics
