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

Support for processing scripts in the Script Editor

A special input field is used for editing scripts. It has an advanced edit mode that provides additional actions.

To switch to advanced mode

  • Press Ctrl + Alt + Enter or click the button at the bottom right.

Figure 30: Directly entering a database query

Table 135: Meaning of icon in advanced edit mode
Icon Meaning

Quits advanced edit mode.

Undoes last change.

Redoes last change.

Cuts selected code.

Copies selected code into clipboard.

Inserts code from clipboard.

Deletes selected code.

Decreases insert.

Increases insert.

Automatic text formatting.

Formats text selection automatically.

Shows/hides line numbers.

Inserts comments.

Removes comments.

Inserts or removes line numbers.

Inserts or removes automatic line breaks.

Enable or disable automatic completion of words when they are entered.

Shows or hides spaces and tabs.

Searches within code.

Inserts code snippet.

Shows list of objects properties.

Shows auto completion list.

Shows list with parameter information.

Shows additional information.

Table 136: Shortcut for editing scripts

Shortcut

Description

Ctrl + C

Copy to clipboard.

Ctl + Ins

Copy to clipboard.

Ctrl + X

Cut and copy to clipboard.

Shift + Del

Cut and copy to clipboard.

Ctrl + L

Cut row and copy to clipboard.

Ctrl + V

Paste from clipboard.

Shift + Ins

Paste from clipboard.

Ctrl + Y

Redo action.

Ctrl + Shift + Z

Redo action.

Ctrl + Z

Undo action.

Backspace

Remove character behind cursor.

Shift + Backspace

Remove character behind cursor.

Ctrl + Backspace

Remove word behind cursor.

Del

Delete character in front of cursor.

Ctrl + Shift + L

Delete row.

Ctrl + Del

Delete to end of next word.

Data

Insert line break.

Shift + Return.

Insert soft line break.

Ctrl + Return

Insert row above.

Ctrl + Shift + Return

Insert row below.

Ctrl + Space

Auto-complete.

Ctrl + Space + Space

Show list with parameter information.

Tab

Insert indent/tab.

Shift + Tab

Remove indent/tab.

Ctrl + U

Change marked characters to lowercase.

Ctrl + Shift + U

Change marked characters to uppercase.

Ins

Toggle insert mode.

Ctrl + T

Swap characters in front and behind cursor.

Ctrl + Shift + T

Swap words in front and behind cursor.

Shift + Alt + T

Swap row with previous row.

Alt + PgUp

Move row up.

Alt + PgDn

Move row down.

PgUp

Move up

PgDn

Move down.

Left arrow

Move left.

Right arrow

Move right.

Ctrl + Left arrow

Move to previous word.

Ctrl + Right arrow

Move to next word.

Home

Move to start of line.

End

Move to end of line.

Ctrl + Home

Move to start of script.

Ctrl + End

Move to end of script.

PgDn

Move up a page.

PgUp

Move down a page.

Ctrl + PgUp

Move to visible start.

Ctrl + PgDn

Move to visible end.

Ctrl + ]

Move to next bracket. (not possible on German keyboard)

Ctrl + Down arrow

Scroll down.

Ctrl + Up arrow

Scroll up

Ctrl + F

Open search dialog.

F3

Search next.

Ctrl + F3

Search forward.

Shift + F3

Search backward.

Ctrl + Shift + F3

Find previous.

Ctrl + H

Replace.

Ctrl + I

Search forward incrementally.

Ctrl + Shift + I

Search backward incrementally.

Ctrl + Shift + Num-

Reduce code block selection.

Ctrl + Shift + Num+

Extend code block selection.

Esc

Remove selection.

Shift + Down arrow

Extend selection down.

Shift + Up arrow

Extend selection up.

Shift + Left arrow

Extend selection left.

Shift + Right arrow

Extend selection right.

Ctrl + Shift + Left arrow

Extend selection to previous word.

Ctrl + Shift + Right arrow

Extend selection to next word.

Shift + Home

Extend selection to start of line.

Shift + End

Extend selection to end of line.

Shift + Alt + Home

Extend selection to start of script.

Ctrl + Shift + End

Extend selection to end of script.

Shift + PgUp

Extend selection by one page up.

Shift + PgDn

Extend selection by one page down.

Ctrl + Shift + PgUp

Extend selection to visible start.

Ctrl + Shift + PgDn

Extend selection to visible end.

Ctrl + A

Select all.

Ctrl + Shift + W

Select word.

Ctrl + Shift + ]

Select up to the next bracket. (not possible on German keyboard)

Shift + Alt + Down arrow

Extend selected block down.

Shift + Alt + Up arrow

Extend selected block up.

Shift + Alt + Left arrow

Extend selected block left.

Shift + Alt + Right arrow

Extend selected block right.

Ctrl + Shift + Alt + Left arrow

Extend selected block by one word to the left.

Ctrl + Shift + Alt + Right arrow

Extend selected block by one word to the right.

Ctrl + mouse wheel

Adjust text size.

There is additional help provided for creating script code.

Syntax highlighting

The input fields support syntax highlighting depending on the syntax type.

Auto-completion

You can use auto-completion when you write script code. You can enable automatic completion in the input fields with the button in advanced edit mode. This suggests a word to automatically complete the keyword as it is entered. If a keyword is expected at a certain position in the source code, auto-completion comes up automatically after a few letters. Although, after specific characters, such as period (.) or parenthesis ((), automatic completion is always offered. Alternatively, you can use the Ctrl + space shortcut in the relevant positions within the input fields to call up autocomplete.

The amount of scripted code to enter is reduced by displaying the names of properties or functions that can be used. The contents of the list is determined by the key words in the code.

Entering code snippets

Input fields that require data in VB.Net syntax support code snippets. In the Visual Basic category, general code snippets are provided. The Object Layer category contains special code snippets for the One Identity Manager object layer. In the SQL Formatter category, code snippets database queries are formatted from VB.Net.

You can insert code snippets using the following options:

  1. Using the icon
    1. Select the icon.

    2. Select the Object Layer, SQL Formatter, or Visual Basic category.

    3. Select the code snippet.

  2. Using a shortcut
    1. Press F2.

    2. Select the Object Layer, SQL Formatter, or Visual Basic category.

    3. Select the code snippet.

  3. Using an aliases

    1. Enter an alias.
    2. Use Tab to insert the code snippet.

      NOTE: Be aware of case sensitivity when you enter the alias.

NOTE: If you select a code snippet directly using a shortcut or the icon, a short description and the shortcut name are displayed in a tooltip.

Custom code snippets

You can use custom code snippets. To do this, create a CustomSnippets directory in the One Identity Manager installation directory to store the code snippets. Use Visual Studio documentation to develop your own code snippets.

To sort custom code snippets, use the following syntax to enter a sort order in the code snippet header in the code snippet file. When the code snippet is entered, the numbering is hidden.

<Title>(1) Your title for the code snippet</Title>

<Title>(2) Your title for the code snippet</Title>

Inputting values using dollar ($) notation

In input fields where a VB.NET term is expected, a help list opens when you enter $. All properties of the current object are displayed. You can also see a tooltip with a detailed description of the property. When you select a foreign key (FK) column, you can navigate to the columns in the relevant table using the arrow keys. To end the selection in the target column, press Enter or double-click. The complete $ notation for your selection should now be shown in the input column. To close the help list without copying any data, press Esc or leave the input field.

Figure 31: Help list for dollar notation

Table 137: Meaning of icons used in the help list for dollar notation.
Icon Meaning

Property of current object.

Primary key (PK).

Foreign key (FK).

Dynamic foreign key

Table

Special properties

Script

Table 138: Help list functions for dollar notation
Shortcut Action

Arrow down key

Opens the help list.

Arrow up key, arrow down key

Navigate to previous or next entry.

Arrow left key, arrow right key

Navigate to the object above or below over the foreign key.

Data

Accepts the value in dollar notation.

Creating and editing scripts in the Script Editor

IMPORTANT: After creating and editing the script, you should test compiling the script. Compile the scripts in the script library for this script to take effect.

NOTE: You can find detailed examples for syntax and usage of scripts on the installation medium in the QBM\dvd\AddOn\SDK\ScriptSamples directory.

To create a new script

  1. In the Designer, select the Script Library category.

  2. Start the Script Editor using the Create a new script task.

  3. Edit the main data.

    Table 139: Script main data
    Property Description

    Script

    Name of the script. Prefix custom scripts with CCC_.

    Description

    Detailed description about the script's function

    Script code

    One Identity Manager scripts are written in VB.Net syntax, which allows all VB.Net functions to be used. The values to be edited are given as preprocessor instructions.

    Locked

    Specifies whether the script is locked and therefore may not be used. Locking the script is useful, for example, if it is currently being edited.

To edit a script

  1. In the Designer, select the script in the Script Library.

  2. Select the Edit script task.

  3. Edit the script main data.

Detailed information about this topic

Copying scripts in the Script Editor

IMPORTANT: After creating and editing the script, you should test compiling the script. Compile the scripts in the script library for this script to take effect.

To copy an existing script

  1. In the Designer, select the script that you want to copy from the Script Library category.

  2. Select the Copy script task.

  3. In the Copy script dialog, check the following information and correct if necessary.

    Table 140: Copying a script

    Property

    Description

    Old script name

    Name of the copied script.

    script

    The name of the new script is made up of the CCC_ prefix and the name of the old script. You can change the name. Prefix custom scripts with CCC_.

    Script code

    The script code from the original is copied over. If necessary, you can modify the script code of the script to copy beforehand.

  4. To create the copy, click OK.

  5. In the Script Editor, edit the main data of the script.

Related topics

Testing scripts in the Script Editor

You can use the Script Editor to test a script.

To test a script

  1. In the Designer, select the script in the Script Library.

  2. Select the Edit script task.

  3. Select the View > Test script menu item.

  4. In the Test script view, select the script from the menu and modify the parameters as required.

    All the parameters to be passed to the script are displayed with their data types. You can edit the values. You can also predefine values for the Base and Value script base class variables as input parameters and use these in the script.

  5. Use Options to select one or more of the following options for running the test.

    • Use main database connection: Specifies whether the script test is tested against the main database or an internal SQLite database. Scripts that relate to the application part of the One Identity Manager data model should always be tested with the main database. Scripts for system parts can be test with against the main database or the internal SQLite database.

    • Use transaction: Specifies whether the script is run within a transaction with subsequent rollback or whether the script is run immediately against the database.

    • Record SQL log: Specifies whether the database actions should be recorded in an SQL log while the script is running. The output is displayed in a separate dialog window. The time to run the script is output in addition to the statement run.

  6. Select the Start button to run the script test.

    The test results are displayed in the Result field after the script has been run.

Related topics
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating