Saviynt unveils its cutting-edge Intelligence Suite products to revolutionize Identity Security!
Click HERE to see how Saviynt Intelligence is transforming the industry.
Saviynt Copilot Icon

is there a way to identify the taskkey of tasks that are closed from pending tasks to completed task

Karthi
New Contributor
New Contributor

Hi Team,

we have created an enhanced Query Job that will close the pending task to completed tasks that are more than 15 days. we would like to know whether there is a way to identify the list of task key for the tasks that were moved to completed state.

5 REPLIES 5

NM
Esteemed Contributor
Esteemed Contributor

@Karthi , especially from enhanced query ? If yes then I don't think so as it directly updates the DB.

As a workaround try to add prov comments when ever using enhanced query to move the task so .. after a soan of time you can filter them out.


If this helped you move forward, click 'Kudos'. If it solved your query, select 'Accept As Solution'

rushikeshvartak
All-Star
All-Star
  • When we close tasks from enhanced query we also added comments to identify its closed from enhanced query in such cases 

 

 

SELECT 
    at1.taskkey AS arstasks__primarykey,
    '4' AS arstasks__status,
    'Access retained as part of skip list, so discontinuing the deprovisioning task.' AS arstasks__provisioningcomments
FROM 
    arstasks at1
JOIN 
    arstasks tk ON at1.taskkey = tk.taskkey
JOIN 
    users u1 ON tk.userkey = u1.userkey
JOIN 
    entitlement_values ev ON tk.entitlement_valuekey = ev.entitlement_valuekey
WHERE 
    at1.tasktype = 2
    AND tk.status = 1
    AND tk.source IN ('PROVRULE', 'ZERODAY')
    AND (ev.customproperty11 IN ('Unified', 'DynamicMembership') 
         OR ev.customproperty17 = 'True' 
         OR ev.customproperty21 = 'Skiplist')
    AND u1.statuskey = 1;

 

 


Regards,
Rushikesh Vartak
If this helped you move forward, click 'Kudos'. If it solved your query, select 'Accept As Solution'.

Karthi
New Contributor
New Contributor

Thanks for your suggestions. we have already added provisioning comments ,but the issue is with the tasks that were closed without provisioning comments which were done earlier.is it possible to identify the taskkey for those tasks that have been closed without having any provisioning comments 

NM
Esteemed Contributor
Esteemed Contributor

@Karthi as such no .. 


If this helped you move forward, click 'Kudos'. If it solved your query, select 'Accept As Solution'

  • No you can't identify if past task does not have any identiifier

Regards,
Rushikesh Vartak
If this helped you move forward, click 'Kudos'. If it solved your query, select 'Accept As Solution'.