Hello community,

I am developing a workflow for access removal processes. I'm using One Identity Manager 8.2. Could you help me with this problem?

I need to apply a rule to skip the hierarchical manager when the reason is "AQL" or "Termination".…

Hi everyone,

We are working on an implementation for a process that will, in the Pre-Script, make a Select SQL Query to the DB to retrieve few data to then perform an Insert.

We were still looking at how to use IColDBObject but it looks like it's deprecated…

Hi everyone,

I'm currently testing the API Server / Web Portal (oneidentity/oneim-api:9.2) deployed in Kubernetes, and I’m encountering a critical issue.

The App Server is deployed and reachable (tested separately).

The API Server has 2 replicas…

Hello Everbody,

i have create the Report below with the "VI_Reporting_DefaultTemplate" Template

<DatabaseExportDefinition BaseTable="ADSAccount">
<WhereClause>
uid_person in
(
Select ad.UID_person
from adsaccount ad
left join…

Hi folks. I am new to the community and have been working with 1IM for around 4 months. I have not been able to find any scripting guides in the official documentation, so I am wondering if there's any articles or guides on scripting in 1IM, as for example…

Hi,

We are using an Azure pipeline to deploy our packages using Intragen.

Currently we are using change labels to do the changes in our system.

For a change I am currently working on we need to extend the length of an attribute, I used the following…

Hi everyone,

I've been facing challenges with the script-based installation of Identity Manager using the quantum.migratorcmd.exe tool. However, everything proceeds smoothly when I use the Configuration Wizard for installation.

From what I understand…

The supported SQL version mentioned in the original Identity Manager 9.0 LTS Release Notes is SQL Server 2019, which is at this moment already some 5 years old. So for newly installing or upgrading from 8.x to 9.0 LTS, it would be preferred to use a more…

Hello OIM community,

We are using One Identity, running the database as an Azure SQL Database, with OIM servers running containerized on Azure cloud. We would like to start authenticating with Azure SQL Database using Azure Active Directory instead of…

Hi One Identity Manager Community,

We have some complex SQL scripts that are run from processes that we would like to store as prepared statements (QBMLimitedSQL) rather than as the parameter to a SQLComponent task.

So far I have not been able to find…

Hello,

I am currently preparing for SQL interviews and have come across a resource that contains SQL query interview questions. The resource can be found here SQL Query-based Interview Questions I believe this will be helpful for others as well.

However…

In One Identity Manager 8.2 I would like to edit the (viewing) condition of a Case inside a Switch in the Web Designer:

The problem is that I don't know how to convert the query from SQL to the language supported by the condition. The docs says it's…

I'm working on a Dynamic Role for users that are currently not members of a group that begins with specific value.  An example would be an SQL statement that excludes all users that are in groups beginning with "ARS."  I've tried to use the…

Hello, everyone,
I am using One Identity - Identity Manager v. 8.2.
I would like to create a View on the Database using the launchpad's 'Extend Schema' tool.
The query that generates the view is very complex and requires many JOINs. The tool…

Hello Community,

we are using One Identity Manager version 8.1.5

we have created our own table indexes for some tables. In doing so, we noticed the following message in the system journal

Element name longer then 30 chars ... from the Application QBM_PCustomSQLFill…

I have these problems, has anyone experienced this? I'm using version 8.1.4, sql server 2017 and windows server 2016, I also tried it on another system with version 2019 and got the same problems.

when trying to modify permissions or synchronize…

I'm compiling the database on a sql server 2017, installed on a windows server 2019 and I get the following message during compilation: "Could not find referenced assembly VI.TSUtils.Dll.", when I close the error message is prompted for a authentication…

Hello,

we are preparing the update of our environments to version 8.1.5. In the development environment we have noticed that within the daily maintenance work not all table indexes are
being rebuilt. A look into the Relase Notes explained us why this…

Currently a few test users in one of our Pre-production environment are having logon issues while logging on to the web portal. The issue is that once they try to logon using their username and password (authentication method - Employee (role based) they…

Hi everyone,

I installed One Identity Manager 8.1.4 on a machine and when I try to compile the DB I get the error in the image below

Here some information:

     - Job Server status is up and running

     - service is running

    - log file contains only "Requesting…

Hello - we are currently using OneIM 8.1.3 and have a question regarding executing a SQL query automatically and exporting data results.  As of right now, we use Object Browser to manually execute a SQL query that essentially runs a comparison between…

Hi, I am trying to write the data to SQL target using ADO.net connector since I need to use stored procedure and direct db access is not available. I need a sample code to write code in Multiple Processing steps to create, update and delete user. We are…

Hello,
recently was found that all makedecision jobs just stuck in processing state and nothing happens.
All other jobs successfuly executes and there is no isReset in dbqueue. Which means that object layer don't see any "contested" operations.…

Hi,

I try to install a demonstration envionment with SQL Server Developer Edition, but it does not work.

Processing step 'ATT CheckInsertJob (insert post processing jobs)' failed.
4 - Sql command failed.
Error during execution of statement: exec…

Hi,

We need to install 2 CAM and we would like to know if is it possible to install them on the same SQL instance but in a different DB.

Thanks