Does anyone know how I can return current open alerts for a particular group using t-sql?
I’m trying to setup a dashboard using this information.
I have various t-sql code segments to return Alerts, however I’m finding it impossible to tie this up to groups.
Within the Operations Manager Console, I’ve setup a few groups. e.g. GroupA which contains 20 servers.
I’ve then created an alert view, with “show data related too” scoped to ‘GroupA’
This Alert view, now only display alerts for ‘GroupA’
How do I get the same data using t-sql from the Operations Manager database?
Thanks in advance,