Chat now with support
Chat with Support

Identity Manager 9.2.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
Overview of the One Identity Manager schema Table types and default columns in the One Identity Manager data model Notes on editing table definitions and column definitions Table definitions Column definitions Table relations Dynamic foreign key Supporting file groups
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 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

Formulating queries in the One Identity Manager query language

The One Identity Manager query language can be used to create queries or Where clause expressions against the One Identity Manager object layer.

The query language is not case sensitive. Keywords can be written in upper or lower case. To be able to identify them more easily, keywords are always written in capital letters in the following examples. In a lot of parts, the query syntax is based on SQL syntax.

Detailed information about this topic

Query header

Data queries in the One Identity Manager query language always start with the FROM keyword and a table name. An optional alias for the table can be specified after the AS keyword.

FROM <table name>

FROM <table name> AS <table alias>

An alternative is to query directly using an object key.

Example of the query in long form

FROM Table WHERE PRIMARYKEY '<Key><T>Table</T><P>UID</P></Key>'

Example of the query in short form

FROM '<Key><T>Table</T><P>UID</P></Key>'

You can specify a list of clauses after the query header. The clause types do not have to be in any particular order.

Where clauses

Where-clauses in the One Identity Manager query language start with the WHERE keyword and contain a condition that the resulting data must match. Unlike SQL syntax, multiple Where clauses can be combined in a One Identity Manager query language query.

Examples of Where clauses

WHERE Lastname = 'User1'

WHERE Lastname = 'User1' AND Firstname = 'Chris'

WHERE [isnull(lastname, '') = N'User1]

WHERE Lastname IN ('User1', 'User2')

WHERE XDateInserted IN RANGE LAST MONTH

Related topics

Search clauses

In the One Identity Manager query language the SEARCH keyword is used to search for all matching entries from the full text index. To use this type of clause, a full text index must be installed and accessible from the application.

SEARCH 'Search string'

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating