Table 53: Measurement query properties
Measurements query |
Enter the complete database query in SQL syntax to determine the statistic measurements. The query must return the ElementName and ElementValue columns as results.
To display statistic information in the Web Portal, you can also optionally output the ElementObjectKey, ElementObjectKey2, and ElementValue2 columns.
You can, optionally, control the display order of statistic measurements with the ElementOrder column. If the ElementOrder column does not exist, they are sorted by the ElementName column. |
Base measurements query |
Enter the complete database query in SQL syntax to determine the statistic measurements. The query must return the ElementName and ElementValue columns as results.
To display statistic information in the Web Portal, you can also optionally output the ElementObjectKey, ElementObjectKey2, and ElementValue2 columns.
You can, optionally, control the display order of statistic measurements with the ElementOrder column. If the ElementOrder column does not exist, they are sorted by the ElementName column.
The threshold factors entered in the fields Threshold green and Threshold red refer to the result in the ElementValue column. To determine the base measurement percentage, the result from column ElementValue is applied with 100%.
NOTE: The name of the ElementName column in the base measurements query must match the name of the ElementName column in the measurements query. |
Condition |
Formulate a condition to limit the statistics data that are displayed to the current user. The condition has to be formulated as a valid WHERE clause for database queries and limits the result of the query further based on the ElementObjectKey column. To restrict the database query to the logged in user, use the "%useruid%" variable.
NOTE: The condition is only taken into account for statistics that are shown in the Web Portal. |
Example: Calculating the threshold
Threshold factors are used to determine the percentage of the base measurement that reflects a correct or acceptable status.
Table 54: Example of finding the state
100 |
0.25 |
0.75 |
< = 25 |
correct |
>25 to >75 |
acceptable |
>= 75 |
unacceptable |
0.75 |
0.25 |
> = 75 |
correct |
<75 to <25 |
acceptable |
<= 25 |
unacceptable |
Related topics
You have the option to disable individual statistic elements as required. Statistic definitions that are disabled are not calculated. Predefined user statistic definitions remain disabled even after the schema has been updated.
To edit an statistic definition
-
In the Designer, select a statistic definitions in the User Interface > Statistics definitions category.
-
In the edit view, select the Properties view.
-
Select the Properties tab and set the Disabled option.
-
Select the Database > Commit to database and click Save.
In addition, statistic definitions can be disabled through pre-processor conditions.
Related topics
In order to visualize statistics in the One Identity Manager administration tools, such as the Manager, you have to link the statistics into the user interface as a custom menu item.
You will typically find statistics in the Manager under the Info System navigation item in nearly any category. You should set up custom menu items for statistics under an info system like this. All statistics that are defined at one menu level are displayed on one form.
You can show reports that you create in the Report Editor or in the Manager in the statistics. In the Manager's info system, the report opens when you double-click on the statistics header.
Statistics can also be linked as form elements into overview forms. To do this, use the Overview Form Editor.
NOTE: If you set up a custom info system, ensure that the menu item under which you define the statistics, is labeled with Not expandable by user and Force open menu item.
For more information about general properties of menu items, see General menu item properties. Take note of the following properties for menu items.
Table 55: Statistics properties
Entry type |
Select the entry type Statistics. |
Caption |
The caption given here, overwrites the statistic definition caption. Leave this field empty if you want to use the statistic definition display name. |
Statistics |
Enter the statistic definition to be displayed. |
Diagram type |
Select the diagram type that is going to represent the statistic.
|
Alignment |
Positioning of statistics on the overview form. This layout information is used if the statistic is used as a form element on an overview form. |
Background |
Background color of the form elements on the overview form. This layout information is used if the statistic is used as a form element on an overview form. |
All menu items that are to be displayed in an application user interface have to be assigned to a permissions group and an application.
Related topics
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
-
In the Designer, create a user interface form.
-
In the Designer, select the User interface > Forms > User interface forms category.
-
Select the Edit form task.
-
Select the Form > Insert menu item.
-
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>
-
Assign the user interface form to the applications and permissions groups.
-
In the Designer, create a menu item.
-
In the Designer, select User interface > User interface navigation category.
-
In the User Interface Editor, select the menu item for the statistics item to show the report.
-
Select New.
-
Edit the main data of the menu item.
-
Assign the menu item to the Manager application and permissions groups.
-
Assign the user interface form to the menu item.
-
Select the Database > Commit to database and click Save.
Related topics