Using preformatted Where clauses
More complex Where clauses can be specified in the One Identity Manager query language in the format of the underlying database system. They are checked for SQL injection attempts when they are run. Preformatted where clauses are enclosed in square brackets ([ and ]).
WHERE [preformatted clause]
Example
FROM Person
WHERE [isnull(LastName, N'') = N'Einstein']
SELECT DISPLAYS
Related topics
Reports in One Identity Manager
One Identity Manager provides the means to create and run multi-object reports, including totals and other aggregate functions. It is also possible to create groups and graphically represent data. Predefined reports are supplied with the schema installation. You can create and edit custom reports with Report Editor.
You can also send reports to specified email addresses using scheduled subscriptions. You can create reports for the current state or over a specified period. For every report, you can create different subscribable reports that can be requested by Web Portal users. In addition, you can embed reports in the Manager or the Designer‘s user interface.
For more information about report subscription, see the One Identity Manager Report Subscriptions Administration Guide and the One Identity Manager Web Designer Web Portal User Guide.
Detailed information about this topic
Working with the Report Editor
The Report Editor is a program for creating and editing reports. The program uses StimulReport.Net components for designing the reports. You can find accurate descriptions and the functionality of individual components in the Stimulsoft online help (www.stimulsoft.com).
NOTE: When you start the Report Editor for the first time, you can select the configuration type (basic, default or professional) for the report. The configuration type determines the range of properties displayed when editing a report. You can change the configuration type later in the edit view using the context menu in the property view.
NOTE: Reports with changes in historical data analyze changes made to data 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 detailed information about connecting to the One Identity Manager History Database through an application server and the required configuration, see the One Identity Manager Operational Guide.
Menu items in Report Editor
Table 143: Meaning of items in the menu bar
Database |
New connection |
Establishes a database connection. |
Settings |
For configuring general program settings. |
Exit |
Exits the program. |
Report |
New |
Creates a new report. |
Save |
Saves the current report in the database. |
Delete |
Deletes the current report. |
Edit |
Opens the property dialog for the current report. |
Reload data |
Reloads the report data from the database. |
New virtual data source |
Opens a dialog box for creating a virtual data source. |
Help |
Community |
Opens the One Identity Manager community website. |
Support portal |
Opens the One Identity Manager product support website. |
Training |
Opens the One Identity Manager training portal website. |
Online documentation |
Opens the One Identity Manager documentation website. |
Search |
Opens the search dialog box. |
Report Editor help |
Opens program help. |
Info |
Shows the version information for program. |
Table 144: Meaning of icons in the general toolbar
|
Creates a new report. |
|
Deletes the current report. |
|
Saves the current report in the database. |
|
Opens a dialog box for editing change labels. |
|
Defines the current change label as default and applies it automatically. |
|
Opens the property dialog for the current report. |
|
Reloads with the newest report data. |
|
Opens a dialog for creating a new virtual data source. |
Table 145: Functions in the report list toolbox
|
Displays all reports. |
|
Uses a filter condition to limit the number of reports displayed. |
|
Runs the filter and shows all reports that satisfy the filter condition. The filter condition is interpreted internally as a LIKE comparison. |
|
Updates the report list. |
Table 146: Functions in the report list context menu
New |
Creates a new report. |
Edit |
Opens the property dialog box for the current report. |
edit properties |
Loads the properties dialog box for the selected report. |
Copy |
Copies the selected report. |
Delete |
Deletes the current report. |