• SQL Server 2017 Developer Edition

    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…

  • Migrating OneIM DB for upgrade to 8.1

    Hi All, 

    I am working with a customer to upgrade their installation to 8.1 (from 7.1.2).  To do so SQL had to be upgraded to 2016 and they chose to create a new server and migrate teh DB. 

    Now the DB is on the new host, we are able to connect, and need…

  • Approval procedure for delegations

    (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…

  • 1IM V7.1 Synchronisation Projects - One to Many Relationships

    I'm in the process of creating a connector to an application that has a specific use case; and wanted to see if anybody else has done anything similar.

    The application in question uses a simple SQL database that doesn’t have any primary keys set as…

  • How to find the current approver(s) for a ITShop request?

    Hi all,

    [1IM version 6.1.4 (soon to be 7.1), windows servers, MS SQL DB]

    I am writing or trying to write a query that will find the current approver or approvers for a PWO/ITShop request. 

    I have kind of got a product Owner approval step working, but it…

  • Has anyone every tried Spotlight Cloud for SQL with Identity Manager?

    Just curious if anyone has ever tried the new Spotlight cloud-based solution for SQL monitoring with Identity Manager? https://www.spotlightessentials.com/

    I'm not expert enough to know if it is useful for diagnosis or tuning? I like the fact they've…

  • Data Import from an SQL Database

    Hi, Apologies for my lack of knowledge in this area. We currently have our HR Oracle system sync'd into 1IM along with AD. Neither of which contains up to date contact telephone numbers for users. We have a separate SQL database that has some info in…

  • vid_insertforhandleobject_freeze

    Hello,

    we are migrating to V7.1.1.

    I can't find the function vid_insertforhandleobject_freeze in the database.

    How can we trigger an Dataset Insert / Update via SQL ?

    We have special programming in SQL, so DataImporter is no alternative.

    exec vid_insertforhandleobject_freeze…