How to clear out the Report Manager tables

Products

• CA Spectrum
• DX NetOps

Issue/Introduction

Question: 

How to clear the data in report manager database

 

 

Resolution

 

1.Stop spectrum tomcat service

 

Windows:

• click on start
• click on run
• type services.msc and enter
• stop spectrum tomcat service 

 

Unix:

Below command stops spectrum tomcat

• $SPECROOT/tomcat/bin/stopTomcat.sh

 

2.Initialize the report manager database

 

Windows:

• open command prompt

click on start

click on run 

type cmd and enter 

• bash -l 
• cd bin 
• ./rpmgrinitializelandscape root root -initHist 45 -all 

 

Unix:

• cd $SPECROOT/bin
• ./rpmgrinitializelandscape root root -initHist 45 -all

 

NOTE: This will delete the current data completely and reprocess 45 days from Archive Manager.

To not process data from Archive Manager and to just clear the data:

./rpmgrinitializelandscape root root -all

 

3. Start spectrum tomcat service

 

Windows:

• click on start
• click on run
• type services.msc and enter
• start spectrum tomcat service 

 

Unix:

Below command starts spectrum tomcat

 

• $SPECROOT/tomcat/bin/startTomcat.sh