We are seeing SCOM alerts cleared in SOI console are not clearing out in SCOM console. So every time SOI re query SCOM, old alerts get populated all over again. Management want to know process involve to ensure alerts cleared in SOI automatically get cleared out in SCOM concurrently.
Release : 4.2
Component : Service Operations Insight (SOI) Manager
Steps tp resolved issue:
1) Stop all SOI Services
2) Ran SQL queries
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'
3) Start all SOI Services