Comparing parameters
In the One Identity Manager query language, parameters can only be compared against fixed values. All comparisons that are valid for columns can also be used for parameters.
NOTE: IN clauses and NOT IN clauses cannot be used.
Examples
WHERE @StringParameter = ''
WHERE @IntParameter > 5
WHERE @IntParameter BITSSET 4
Related topics
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 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.