Click HERE to see how Saviynt Intelligence is transforming the industry. |
08/03/2023 01:58 AM
Hello,
Saviynt is not considering the status of users on putting work items (Approvals and certifications) on delegates queue.
THough inactive users will not be allowed to login to Saviynt. As further to have consistency in the delegates table, we need to have delegates entry expiring (end dating).
As an immediate solution we are using below customquery to immediately end date the delegates where parent or delegate user status is inactive.
update delegates set enddate=SYSDATE() where userkey in (select u.userkey from delegates d left join users u on d.userkey = u.userkey where u.statuskey=0 and d.enddate > sysdate() UNION select u.userkey from delegates d left join users u on d.delegateuserkey = u.userkey where u.statuskey=0 and d.enddate > sysdate())
Please confirm the use of this solution.
Thanks,
Jaydeep Mehta
08/04/2023 06:47 PM
@Saviynt please confirm if below is acceptable solution
Execute Extension Query Job (once a day)
Update delegates set enddate=SYSDATE(), updatedate=SYSDATE(), updateuser=1 where delegatekey in (
select * from(
(select delegatekey from delegates d left join users u on d.userkey = u.userkey where u.statuskey=0 and d.enddate > sysdate()
UNION select delegatekey from delegates d left join users u on d.delegateuserkey = u.userkey where u.statuskey=0 and d.enddate > sysdate()) ) )
08/06/2023 03:10 PM - edited 08/06/2023 03:20 PM
If Saviynt accepted as defect and workaround is working then you can use query.
Please submit idea ticket for same