Manually move Smarts RPE events from the events_live table to the events_archive table in the APG database.
search cancel

Manually move Smarts RPE events from the events_live table to the events_archive table in the APG database.

book

Article ID: 304630

calendar_today

Updated On:

Products

VMware Smart Assurance

Issue/Introduction

Steps to manually move Smarts RPE events from the events_live table to the events_archive table in the APG database.

Environment

Watch4net/MnR - 7.x

Resolution

  1. Log into the Watch4net APG datastore-client/mysql-client depending on the location in your environment:
     
    • Linux/Unix: /opt/APG/bin
       
  2. Run the following sequence of SQL query commands at the mysql> prompt:

    mysql> use events;

    mysql>  insert into events_archive select * from events_live where ClosedAt < TIMESTAMP;

    mysql> delete * from events_live where ClosedAt < TIMESTAMP;

    NOTE: Where TIMESTAMP is an epoch timestamp.