I am working on Identityiq 8.4p4 . We have run performance identity request maintence task with option "
Max age (in days) for Identity Request objects value to 3" and run the task. We terminate task but its shows prune identity request 100 count. How we can validate which access requet removed and how we can restore those.
When you run the Identity Request Prune task with “Max age 3 days”, it removes IdentityRequest objects older than 3 days.
Hello @sunilbalasahebd
By using Max age 3 days 100 identity requests has been deleted. You can validate them by using below query:-
SELECT * FROM spt_audit_event
WHERE event_type LIKE '%delete%'
AND object_class = 'sailpoint.object.IdentityRequest'
ORDER BY timestamp DESC;
Only way to recover these identity requests if you have backup you can restore from Database Backup by extracting tables
spt_identity_request
spt_provisioning_plan
spt_workflow_case
By the time you have terminated the task, it has already pruned 100 identity request objects. You cannot restore the objects once they are pruned.
If you’re having multi-database host architecture and if there is a delayed sync between both hosts, probably you can get the old data in your secondary database but this scenario is very rare and also completely depends on your environment’s architecture.
Welcome to the SailPoint Developer Community!
Just a small observation regarding the version and patch details: on IIQ 8.4, the latest patch is P2, but you mentioned P4.
You could consider the option of restoring a DB backup, if that’s feasible and suitable for you and if there haven’t been many changes.
Thank You @asharma65 .
Sorry for confusion. Its 8.3p4