Server Management Suite

 View Only

Need a query to show emailed recipients of Tasks on Monitor Policies

  • 1.  Need a query to show emailed recipients of Tasks on Monitor Policies

    Posted Oct 19, 2012 05:09 PM

     

    I am trying to build a query to show all of the Monitor Policies we currently run that have an “Send Email” task type attached to it, then I want it to show me the recipients of each alert.  So far, I am able to find all monitor policies that have a “Send Email” task, but I can’t find out which table holds the configuration items for Tasks.  Here is what I have so far:

     

    select *

    from item i

    inner join itemreference ir

    on i.guid = ir.childitemguid

    where i.guid in (

    select guid from item

    where Guid in (select guid from vNonResourceItem where ClassGuid = 'FF818A1B-584E-478E-B4FB-102B95B91B33'))