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!
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>statusThe status value means:4 means Cancelled
select * from usm_request_sla_instance offering_sla_def_id>sla_statusThe 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_activeThe is_sla_active value means:0 means INactive1 means Active
>request_id>offering_sla_def_idThe offering_sla_def_id is the column which relates to the SLA itself:select * from usm_offering_sla>offering_sla_def_idwhere 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.
Thanks a lot LOUIS! very detailed your answer
I voted for your idea in the Community.
Thanks for that and kind regards, Louis.