I need to run the following SQL queries after enabling alert synchronization
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'
Release : 4.2
Component : SOI REPORTS
In the Administration page, go to the Manager Configuration page. Enable the alert synchronization in the Synchronization Configuration page.
Stop all SOI services.
Open the SQL Server Management Studio, run the following SQL queries against the SAMStore DB.
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'