Symantec IGA

  • Private Community

  • 1.  How can we purge requests in CA Identity Portal (SIGMA)

    Posted Jun 21, 2017 10:40 AM

    I can't find a way to purge / delete requests in CA Identity Portal.

     

    Is there any task in portal or sql script we could use to clean requests which are completed or failed ?



  • 2.  Re: How can we purge requests in CA Identity Portal (SIGMA)
    Best Answer

    Broadcom Employee
    Posted Jun 27, 2017 04:45 AM

    Hi Vincent,

     

    There is no IP task to purge/delete requests. You can cancel requests but not delete them from the system, that's due to compliance/auditing requirements in which you need to keep the history of the actions in your system.

    The IP request system is very light weight and there's no need to archive it, that is in case performance is what you're concerned about.

     

    Regards,

    Hila

    Product Management



  • 3.  Re: How can we purge requests in CA Identity Portal (SIGMA)

    Posted Jun 27, 2017 06:22 AM

    Hi Hila,

     

    thank you for your answer.

     

    I was asking because I have a user which sees a request in its dashboard / approval screen and can not validate or cancel

     

    Approval pending

     

    I was wondering if we could complete or delete this in the database

     

    Regards



  • 4.  Re: How can we purge requests in CA Identity Portal (SIGMA)

    Broadcom Employee
    Posted Jun 28, 2017 08:36 AM

    I suggest opening a support case and they can assist you with it.



  • 5.  RE: Re: How can we purge requests in CA Identity Portal (SIGMA)

    Posted Sep 18, 2023 11:39 PM

    sorry for opening old case, but this is similar to problem i am experiencing right now, i dont have workflow designer gui, is there any other method for example cancelling directly from database?


    Original Message


  • 6.  RE: Re: How can we purge requests in CA Identity Portal (SIGMA)

    Posted Sep 19, 2023 09:16 PM

    Pls refer to this link, someone where sigma REST API solution before.

    Identity Portal - My Requests items | Symantec IGA (broadcom.com)


    Original Message


  • 7.  RE: Re: How can we purge requests in CA Identity Portal (SIGMA)

    Posted Sep 20, 2023 09:29 AM

    https://[hostname]/sigma/rest/admin/request/delete/xxx 

    worked, thank you :)


    Original Message


  • 8.  RE: Re: How can we purge requests in CA Identity Portal (SIGMA)

    Posted Sep 21, 2023 12:54 PM
    Edited by Jason McClellan Oct 02, 2023 09:08 AM

    sorry to bother you again, when i use https://[hostname]/sigma/rest/admin/request/delete/xxx on testing server, the task deleted successfully. however when i use it on production server, the request id is gone but the error task stayed on the bottom of the list. can you or someone else who read this help me again please?

     


    Original Message


  • 9.  RE: Re: How can we purge requests in CA Identity Portal (SIGMA)

    Posted Sep 21, 2023 07:59 PM

    Hi Joe, the sigma REST Api is for delete request in identity portal DB only.

    To remove the approval workflow, pls follow the advice given by losru01, using workflow designer UI


    Original Message


  • 10.  Re: How can we purge requests in CA Identity Portal (SIGMA)

    Broadcom Employee
    Posted Jun 29, 2017 09:01 AM

    Hello Vincent,

     

    So essentially you are asking how to delete the workflow job instances, not Identity Portal requests. Identity Portal does not store the workflow instances. They are stored in the workflow database.

     

    You can delete these workflow instances by connecting to the Workflow Designer GUI.

     

    Go to Basic Tasks, Open Job, select the workflow process you have configured for your workflows, for example TwoStageApprovalProcess and then select and delete or suspend the job instances you want to eliminate. Active State means the workflow still has not completed.