search cancel

Remove existing SLA's

book

Article ID: 215217

calendar_today

Updated On:

Products

iDash Workload Automation for CA 7

Issue/Introduction

Is there a way where we can remove existing sla definitions completely in one shot?

Environment

Release : 12.1

Component : CA WORKLOAD AUTOMATION iDASH FOR CA 7

Resolution

The easiest and fast way to do this would be via the DB:


update idash_config set deleted = 5 where deleted = 0 and type = 'sla'

This tells iDash all of the current SLAs are now deleted. Logs would still be there since the SLAs have to be processed for the logs to get moved around.
You could just delete those if you want. 

Setting deleted = 5 leaves the definitions in the DB, in case you change your mind about some of the SLA's and want to reactivate them.

 

To retrieve the SLA's back run the following query:

update idash_config set deleted = 0 where deleted = 5 and type = 'sla' and tag = 'idash.sla.name' and value = 'slaName^instanceName'