Hi Expert Team,
I need help to automate a SQL database alert generated from SCOM . We used to get an alert 'database backup should be performed' for SQL database servers. But in our project we have Always-on cluster(Mirror) database servers and database backups are performing on Primary database servers. But SCOM is complaining the same for secondary databases and many such alerts are generating from SCOM. All these SCOM alerts we receive as incidents in ticketing tool via Orchestrator2012. Our goal is reduction of such incidents. Therefore i want to automate this kind of alert to identify which is primary database and trigger alert for only primary database servers and not for secondary database servers. . Is it possible to resolve within SCOM console or can we do anything in Orchestrator2012.
Please guide me how to automate.
Thanks for support!!!