Unsubscribe all request

Question

Hi all 
 We need to know if there is anyway to unsubscribe some request based on some where clause we have. We don't want to modify dynamic roles for ITShop as we need to also in some cases retain items on relocation. 
 We had execute SQLComponent updating OrderState to OrderUnsubscribe as we need to also perform an approvalworkflow but sometimes it doest perform the operations.

Markus Weiss-Ehlers · Answer

I do not recommend to use SQL to patch some order states only. In that case, without knowing exactly what you are doing, you may get unwanted side-effects. 
 There is a customizer method called Unsubscribe for the requests you should call by .Net code. And, yes you can call them using SQL using some wrappers. 
 You will information about that in the following posts: 
 https://www.quest.com/community/products/one-identity/f/identity-manager/20224/how-can-i-generate-unsubscribe-request-on-a-user-termination 
 https://www.quest.com/community/products/one-identity/f/identity-manager/5574/unsubscribe-using-vid_insertforhandleobject_freeze?pi8709=1 
 and another one for a discussion around the Abort method. 
 https://www.quest.com/community/products/one-identity/f/identity-manager/6025/administratively-remove-something-assigned-via-the-it-shop 
 HtH