Click HERE to see how Saviynt Intelligence is transforming the industry. |
10/29/2024 05:23 AM
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.
10/29/2024 05:46 AM
@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.
10/29/2024 06:46 AM - edited 10/29/2024 06:47 AM
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;
10/30/2024 12:37 AM
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
10/30/2024 12:51 AM
@Karthi as such no ..
10/30/2024 07:03 AM