Delete SLA instance in SC

[Legacy User]

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!

[Louis van Amelsfort]

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.

[Legacy User]

Thanks a lot LOUIS! very detailed your answer

[Louis van Amelsfort]

Hi Hernan.

 

I voted for your idea in the Community.

Thanks for that and kind regards, Louis.