Clarity Service Management

Expand all | Collapse all

Delete SLA instance in SC

Jump to Best Answer
  • 1.  Delete SLA instance in SC

    Posted 06-03-2016 06:06 PM


    Some users have created a request that had a SLA associated, then we canceled them so we could delete the instances associated in the SOG but we are not able to do it. We tried Deleting them but no luck.

    Is the any way to do it??

     

    Thanks in advance!



  • 2.  Re: Delete SLA instance in SC
    Best Answer

    Posted 06-06-2016 10:11 AM

    Hi Hernan.

     

    There is no option/function available from within the CA Service Catalog(SC) GUI.

    Some background information to be given on this subject though is the following:
    Tables with their columns involved are:

    select * from usm_request_status where request_id = <request_id> and status = 4
    >status
    The status value means:
    4 means Cancelled

    select * from usm_request_sla_instance offering_sla_def_id
    >sla_status
    The sla_status value means:
    0 means is started
    1 means warning threshold meet
    2 means Violation threshold meet
    3 means Reach to the to status
    6 means request is canceled

    >is_sla_active
    The is_sla_active value means:
    0 means INactive
    1 means Active

    >cancelled_time

    >request_id
    >offering_sla_def_id
    The offering_sla_def_id is the column which relates to the SLA itself:
    select * from usm_offering_sla
    >offering_sla_def_id
    where usm_offering_sla.offering_sla_def_id = usm_request_sla_instance.offering_sla_def_id

     

    For situations like this, where a user asks for a change of behaviour of the current release of the product, I can propose to add an Idea in the Communities.
    So, as to this question, we then encourage you to open an Idea in the CA Service Catalog Community.
    To get your idea voted for and review by us there after.
    And then, for us to see whether it is possible to get this functionality implemented in a future release of the product.

    Thanks in advance for your efforts on this.

     

    Kind regards, Louis.



  • 3.  Re: Delete SLA instance in SC

    Posted 06-07-2016 10:02 AM

    Thanks a lot LOUIS! very detailed your answer



  • 4.  Re: Delete SLA instance in SC

    Posted 06-08-2016 07:36 AM

    Hi Hernan.

     

    I voted for your idea in the Community.

    Thanks for that and kind regards, Louis.