Video Screencast Help
Give us your opinion and win with Symantec! Please help us by taking this survey to tell us about your experience with Symantec Connect, so that we can continue to grow and improve.  Take the survey.

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