SQL queries after enabling alert synchronization

Products

• CA Service Operations Insight (SOI)

Issue/Introduction

How do you run the following SQL queries after enabling alert synchronization so that issues are not created in the database?

 

delete from ca_ssa_tags where tagname like '%synchronization.inprogress%'

delete from ca_ssa_tags where tagname like '%synched.pending%'

delete from ca_ssa_tags where tagname='synched.known.mdrs'

 

Environment

Release : 4.2

Component : SOI REPORTS

Resolution

1. In the Administration page, go to the Manager Configuration page. Enable the alert synchronization in the Synchronization Configuration page.
   
   
2. Stop all SOI services.
   
   
3. Open the SQL Server Management Studio, run the following SQL queries against the SAMStore DB.
   1. delete from ca_ssa_tags where tagname like '%synchronization.inprogress%'
   2. delete from ca_ssa_tags where tagname like '%synched.pending%'
   3. delete from ca_ssa_tags where tagname='synched.known.mdrs'
4. Restart the SOI services