Watch4Net/Smarts RPE: How can I manually move Smarts RPE events from the events_live table to the events_archive table in the Watch4net APG database?
search cancel

Watch4Net/Smarts RPE: How can I manually move Smarts RPE events from the events_live table to the events_archive table in the Watch4net APG database?

book

Article ID: 304630

calendar_today

Updated On:

Products

VMware

Environment

VMware Smart Assurance - Watch4Net/M&R

Resolution

How can I manually move Smarts RPE events from the events_live table to the events_archive table in the Watch4net database?



To manually move Smarts RPE events from events_live to events_archive table in the Watch4net database, do the following:
  1. Log into the Watch4net APG datastore-client/mysql-client depending on the location in your environment:
     
    • Linux/Unix: /opt/APG/bin
       
    • Windows: C:\Program Files\APG\Databases\<MySQL/Datastore>\<instance>\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;

    (Where TIMESTAMP is an epoch timestamp)