Video Screencast Help

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

Created: 19 Oct 2012

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'))