Use data queries with the Historical assignments query module to create reports with historical data from object assignments, for example, employee role memberships. This type is used for queries through foreign key relations as well as through assignment tables (many-to-many tables) and child relations.
Table 157: Properties of data source historical assignments
|
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 |
In a parent query, restrictions are applied to the data record that are passed on to subsequent queries, all members of a department, for example. Parameters that are defined in the parent query are also available in subsequent queries. |
|
Query module |
Select the Historical assignments query module. |
|
Assignment direction |
Assignment to be used in the report. Permitted values are Assignments (CR & MN) and Referenced objects (FK). |
|
Table |
Table for the assignment. |
|
Minimum date or range |
Use the minimum date to specify the point in time that the history data should start from. You can define the date directly or using a parameter. In the case of a parameter, the minimum date of all affected entries in the connected One Identity Manager History Database databases is determined. Add these parameters subsequently to the report by entering them on the Parameters tab. |
|
Criteria column |
Column in the table for linking to the base object. |
|
Criteria value |
The value of the criteria column can be queried directly or using parameters. Add these parameters subsequently to the report by entering them on the Parameters tab. Columns in a parent query are formatted with the following syntax:
<parent query name>.<parent query column> |
|
Foreign key to query |
Foreign key to retain historical assignments. |
|
Disabling columns |
Certain tables contain columns that can disable an object, for example, the AccountDisable column in the ADSAccount table. Enter these columns if an assignment should be labeled as "Deleted" when disabled and "Added" if enabled. |
|
Additional object columns |
Enter the columns from the table that should also be available in the report. |
|
Additional criteria |
Column of the table and value for further restriction of the base object. |
The data query returns the following columns. In addition, columns are supplied that are edited like object columns.
Table 158: Columns from a data query using historical assignments
|
BaseKey |
Object key for assignment base object. |
|
BaseUID |
Base object unique identifier. |
|
ObjectKey |
Assignment object key. |
|
DestinationKey |
Object key for assignment target object. |
|
DestinationUID |
Target object unique identifier. |
|
Display |
Target object display value. |
|
CreationUser |
User that created the assignment. |
|
CreationTime |
Time of assignment. |
|
DeletionUser |
User that deleted the assignment. |
|
DeletionTime |
Time of deletion. |
|
Type |
More detailed specification of the assignment, for example, assignment table name or target system type. |
|
Origin |
Bitmask for mapping the type of assignment. |
|
OriginDisplay |
Display name of the bitmask for mapping the type of assignment. |
Related topics
To select the simulation data generated during simulation in the Manager in a report, use the following query modules:
-
Front-end simulation resultYou can apply this query module to all parts of a simulation excluding rule violation analysis.
-
Front-end simulation result for complianceYou can apply this query module to publish the rule violation analysis in the report.
Table 159: Data source front-end simulation result properties
|
Name |
Name of the data source. |
|
Description |
Description of data source. |
|
Query module |
Select the Front-end simulation result query module. |
|
Parent query |
Not used. |
|
Simulation analysis |
Defines which part of the simulation analysis is shown in the report.
Permitted values are:
-
Überblick: Shows which actions were triggered through changes made during the simulation in an overview.
-
Changed properties: Shows objects and their properties affected by the changes made during simulation.
-
DBQueue: Shows the calculation tasks for the DBQueue Processor resulting from changes made during simulation.
-
Trigger changes: Shows all changes made to objects during simulations due to triggering.
-
Generated processes: Shows processes and process steps generated during simulation due to the changes. |
Table 160: Data source front-end simulation result for compliance properties
|
Name |
Name of the data source. |
|
Description |
Description of data source. |
|
Query module |
Select the query module Frontend Simulation Result for Compliance. |
|
Parent query |
Not used. |
Related topics
A report can contain several parameters that are determined when the report is created or when an email notification is generated and passed to the report. The generated report is then displayed or send by email to the subscriber corresponding to the report subscription set up. The user can query the report parameters before the report is displayed. This means, you can, for example, limit the time period or pass specific departments for displaying the report.
Report parameters are grouped internally into parameter sets. A separate parameter set is automatically created for very report, every subscribable report, and every report subscription. The parameters and their settings are passed down in the sequence report->subscribable report->report subscriptions.
Figure 33: Report parameter inheritance
You can configure report parameters at several places.
Parameters for reports
Define the report parameters to use when you create the report in the Report Editor. This is where you specify which report parameters are viewable or writable and which are already predefined in a subscribable report.
Parameters for subscribable reports
When you add a subscribable report viewable parameters are displayed in the Manager. You can make further changes to these report parameters assuming they can be overwritten. That means, you specify which report parameters can be viewed or overwritten by Web Portal users and define parameter values.
Parameters for report subscriptions
Report parameters labeled as viewable and editable in subscribable reports, are shown to Web Portal users when they are setting up their personal report subscriptions. If the report parameters are editable, Web Portal users can modify the values in them.
NOTE: In the report, you must define all the report parameters that users can apply. For example, when the report is displayed, when subscribable reports are generated in the Manager, or in Web Portal report subscriptions.
Detailed information about this topic
To edit report parameters
-
Open the report in the Report Editor.
-
Select the Parameters tab in the properties dialog box.
-
Select the report parameter from Defined queries.
- OR -
Click Add.
Creates a new report parameter.
-
Edit the report parameter properties.
-
Save the changes.
To delete a report parameter
-
Open the report in the Report Editor.
-
Select the Parameters tab in the properties dialog box.
-
Select the report parameter from Defined queries.
-
Click Delete.
-
Save the changes.
Related topics
