Chat now with support
Chat with Support

Identity Manager 9.1 - Configuration Guide

About this guide One Identity Manager software architecture Customizing the One Identity Manager default configuration Customizing the One Identity Manager base configuration One Identity Manager schema basics Editing the user interface
Object definitions for the user interface User interface navigation Forms for the user interface Statistics in One Identity Manager Extending the Launchpad Task definitions for the user interface Applications for configuring the user interface Icons and images for configuring the user interface Using predefined database queries
Localization in One Identity Manager Process orchestration in One Identity Manager
Mapping processes in One Identity Manager Setting up Job servers
The One Identity Manager Service functionality Tracking changes with process monitoring Conditional compilation using preprocessor conditions Scripts in One Identity Manager
Visual Basic .NET scripts usage Notes on message output Notes on using date values Tips for using Windows PowerShell scripts Using dollar ($) notation Using base objects Calling functions Pre-scripts for use in processes and process steps Using session services Using #LD-notation Script library Support for processing scripts in the Script Editor Creating and editing scripts in the Script Editor Copying scripts in the Script Editor Testing scripts in the Script Editor Testing script compilation in the Script Editor Overriding scripts Permissions for running scripts Editing and testing script code with the System Debugger Extended debugging in the Object Browser
One Identity Manager query language Reports in One Identity Manager Adding custom tables or columns to the One Identity Manager schema Web service integration One Identity Manager as SCIM 2.0 service provider Processing DBQueue tasks One Identity Manager Service configuration files

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.


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]


FROM Person

WHERE [isnull(LastName, N'') = N'Einstein']


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 (

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 One Identity Manager 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 Operational Guide.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating