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

  • Run database compilation within script

    Hello,

    In order investiguate on issues, we need to copy production database in another environment.

    The customer want to create a task to copy the database every day and maintain the two environments with the same data.

    We are using RMAN to copy the Oracle…