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

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.