Looking for a query or some type of way to get the system roles and entitlements associated with all employees, any ideas that can help would be greatly appreciated it

If I use the alias of Query.From(), I sometimes get the exception, e.g.

Database error 4104: The multi-part identifier "Org.UID_Org" could not be bound.

The simpliest example is this one-liner

session.Source().GetCollection(Query.From("Org"…

Hi everyone,

I'm creating a custom scrip in which I need to execute a query with the order by clause. I specified it in the where caluse but there is a default "order by cn" in the final query. Here you can see the two queries.

Where clasue…

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…

We need to run a query in a Script. We have created a View that we will query. It is done this way because we want to simplify the script

This is our code for the Query:

Dim qPersonWantsOrg = Query.From("View_Avbestilling")

View_Avbestilling is…

Hello community,

imagine you have a sync-project between IDM and a Microsoft SQL server.

Is it possible to log or debug the dynamicly genereated queries that are send to the target database?

For example in a "Insert" provisioning job?

Version…

(Ver 7.1.2)

Hello again experts,

Let me explain what we want to do and how have we tried to do so.

So our aim is to create an approval workflow for delegations in which the person you are delegating to has to approve it (“accept” that delegation). Sounds…

Hello

We are trying to use a join clause in a script on 1IM. The problem we have is that when we are using classes .Join and .On of the object Query, .On class only admit ExpressionClause Type. Is there any example of how to declare and initialize this…

Hello all,

We are facing a problem with the database. We found out that when we are using the web portal, some pages are taking a lot of time to load. Digging into the problem, in the logs we can see a problem with a query related with the AccProduct…

Hi all,

I need to get the reasonHead from Decisiontype Unsubscribe on a Request but if on that request are started more Unsubscribe I need to get the last one made.

Basically I need the orderby on Connection.getSingleValue or Connection.getSingleRow.