Symantec IGA

Expand all | Collapse all

Identity Manager tasks usage

  • 1.  Identity Manager tasks usage

    Posted 03-20-2018 05:10 PM

    Hi,

    Recently some customers asked us to provide a simple report regarding most used IM tasks plus tasks no longer used.

    Anyone has already developed some queries to obtain this ?

     

    thanks, Roberto



  • 2.  Re: Identity Manager tasks usage

     
    Posted 03-21-2018 05:02 AM

    Hi Roberto,

    I recently used the following query to highlight tasks most used:

     

    select TASK.FRIENDLYNAME, TASK.TASKTAG, vst.num_runs

    from IM_OS.dbo.IM_TASK as TASK

    LEFT OUTER JOIN

    (select name, COUNT(name) as num_runs

    from IM_TP.dbo.tasksession12_5

    where

    user_dn != '<userid_inbound>'  -- exclude inbound

    and environmentid=<envid_to_analyze> -- used environment

    GROUP BY name

    UNION ALL

    select name, COUNT(name) as num_runs

    from IM_AR.dbo.archive_tasksession12_5

    where

    user_dn != '<userid_inbound>'  -- exclude inbound

    and environmentid=<envid_to_analyze>  -- used environment

    GROUP BY name) as vst

    ON TASK.FRIENDLYNAME = vst.name

    where

    TASK.ENV_OID = <envid_to_analyze>  -- used environment

    order by vst.num_runs DESC

     

    where

    <userid_inbound> = userid inbound user

    <envid_to_analyze> = id of the IM environment to be analyzed

    IM_OS = Object store DB

    IM_TP = Task Persistence DB

    IM_AR = Archive DB

     

    Starting from the IM_TASK table, it will show also not used task.

    You would also like to add some time restriction to show only task used in the last months, year…

     

    last_access_time > DATEADD(mm,-3,GETDATE()) /*3 month */

     

    I hope this can help you.

     

    Ciao

    Fabrizio 



  • 3.  Re: Identity Manager tasks usage

    Posted 03-21-2018 07:04 AM

    Thanks Fabrizio,

     

    I will check this at customer site and feedback you.

     

    regards, Roberto



  • 4.  Re: Identity Manager tasks usage

    Posted 03-22-2018 05:49 AM

    Hi Fabrizio,

     

    Your query was helpful to identify IM customized tasks no more used (5 years old !).

    A lot of people developed IM tasks at customer site without any control.

    Before migrating to latest release we need to cleanup tasks and related logic.

     

    thanks, Roberto