SailPoint IIQ: Delete WorkItems assigned to a User

• Query the 'spt_work_item' table. Pay attention to 'id' column(used for deleting the workitem) and 'owner' column (used to identifying the owner
• Use the console utility to delete the workitem
• Navigate to <tomcat>/webapps/iiq/WEB-INF/bin/
• Execute ./iiq console
• delete workitem ff8080817bffde5f017c029a820700ab (where id is the one you queried from database)
• If multiple ids have to be deleted, you can create a file with content like:

delete workitem ff8080813eb1de6f013eb3d811f10081
delete workitem ff8080813eb1de6f013eb3d82b6b0095
delete workitem ff8080813eb1de6f013eb3d83b1000a9
delete workitem ff8080813eb1de6f013eb3d846b900bd
delete workitem ff8080813eb1de6f013eb3d855cb00d1

•  Within IIQ console: source deleWorkItem.txt