How do we query in query builder reports that have a schedule email address

[former_member445476]

We need to identify all webi reports that have a destination with an email address,

cheers if you can Help

[former_member445476]

Hi Many thanks, a question related, how do we find all reports that use a particular universe "measure"

regards

Nick

[Joe_Peters]

A CMS query will do it:

select static from ci_infoobjects where si_recurring = 1 and si_scheduleinfo.si_destinations like '%email.address@here.com%'