How can I remove only the old CA 7 data from the iDash database - job run data, SLA data etc. Is there any SQL to perform this task?
Release : 12.1.02
Here are some queries to delete the information from the DB. For the queries that reference instanceName, you will need to run the query for each CA 7 instance you have defined, replacing instanceName with the actual instance name they defined.
delete from idash_average_runtime where instance = 'instanceName';
delete from idash_doc where type like '%joblink' and name like '%instanceName%';
delete from idash_config where type = 'sla' and id like '%instanceName';
delete from idash_config where type = 'ca7instance';
delete from idash_config where type = 'ca7avgtime';
delete from idash_config where type = 'ca7lasteventid';
delete from idash_config where type = 'ca7.run.report';
delete from idash_hist_jfm_console_message;
delete from idash_jfm_console_message;
delete from idash_hist_job_run_ca7;
delete from idash_job_run_ca7;
delete from idash_sla_problematic_jobs where instance = 'instanceName';
delete from idash_sla_run where sla_name like '%instanceName';