Clearing out Backups History in OpsCenter 6.0 and 6.1 GUI – DataStax Support

Via the GUI there is no way to clear out the events in the backup activity. One way though is that you can truncate the "OpsCenter".backup_reports then synchronize the backup data to just have the most recent available.

http://docs.datastax.com/en/opscenter/6.1/opsc/online_help/services/syncBackupData.html

the following is the keyspace table for the `"OpsCenter".backup_reports:

CREATE TABLE "OpsCenter".backup_reports (
    week text,
    event_time timestamp,
    backup_id text,
    type text,
    destination text,
    deleted_at timestamp,
    full_status text,
    keyspaces text,
    status text,
    PRIMARY KEY (week, event_time, backup_id, type, destination)
) WITH CLUSTERING ORDER BY (event_time DESC, backup_id ASC, type ASC, destination ASC)
    AND bloom_filter_fp_chance = 0.01
    AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
    AND comment = '{"version": [6, 1, 0], "info": "OpsCenter management data."}'
    AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32', 'min_threshold': '4'}
    AND compression = {'chunk_length_in_kb': '64', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
    AND crc_check_chance = 1.0
    AND dclocal_read_repair_chance = 0.1
    AND default_time_to_live = 0
    AND gc_grace_seconds = 864000
    AND max_index_interval = 2048
    AND memtable_flush_period_in_ms = 0
    AND min_index_interval = 128
    AND read_repair_chance = 0.0
    AND speculative_retry = '99PERCENTILE';

here is Sample Data:
cqlsh:OpsCenter&gt; select * from backup_reports ;

week | event_time | backup_id | type | destination | deleted_at | full_status | keyspaces | status
--------+--------------------------+-----------------------------------------+--------+------------------------------------------------------------+------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------+---------
201721 | 2017-05-23 21:08:49+0000 | opscenter_adhoc_2017-05-23-21-08-49-UTC | backup | {"path": "", "provider": "server", "id": "OPSC_ON_SERVER"} | null | {"destinations": [], "started": 1495573729, "finished": 1495573730, "datacenters": [], "cluster_id": "dse", "keyspaces": {"dse_perf": ["node_slow_log"]}, "details": {"subrequests": {"10.200.178.27": {"started": 1495573730, "finished": 1495573730, "cluster_id": null, "details": {}, "id": "9b860f7f-75fe-4cdc-8e99-1af5938bd4aa", "state": "success"}, "10.200.178.26": {"started": 1495573730, "finished": 1495573730, "cluster_id": null, "details": {}, "id": "897b2c64-5d0d-4294-be45-c60afdc18288", "state": "success"}, "10.200.178.30": {"started": 1495573730, "finished": 1495573730, "cluster_id": null, "details": {}, "id": "4260899a-d1a8-40bb-8ff8-88eac6e169c9", "state": "success"}}, "message": ""}, "id": "1b50dd86-9ca0-4226-a2f0-8222eeea5a5a", "state": "success", "tag": "opscenter_adhoc_2017-05-23-21-08-49-UTC"} | {"dse_perf": ["node_slow_log"]} | success

(1 rows)

Related articles