Como monitorar logs no event viewer de permissões no sql

Question

Preciso monitorar alterações de permissões dentro do sql, porem em um server tenho 4 instâncias no Operation manage gostaria de configurar para pegar o evento 33205 porem alarmar somente a instancia dentro do servidor que recebeu a modificação, atualmente quando modifico uma instancia, alarma no operation managem todas instancias que existem no server com a informação somente da instancia alterada, preciso filtrar isso para mostrar somente a instancia alterada.

I need to monitor permission changes within SQL, however on a server I have 4 instances in Operation Manage I would like to configure it to catch event 33205 but only alarm the instance within the server that received the modification, currently when I modify an instance, it alarms in Operation Managem all instances that exist on the server with information only about the changed instance, I need to filter this to show only the changed instance.

Answer 1

Hi,

You can consider the following steps, use Operation Manager to catch the specific instance.

https://learn.microsoft.com/en-us/system-center/scom/sql-server-management-pack-monitoring-modes?view=sc-om-2022