Hi,
We are using 4.0 and 4.1 versions
How do I get list of reports scheduled to particular email address
bob2210 (BOB member since 2010-09-23)
Hi,
We are using 4.0 and 4.1 versions
How do I get list of reports scheduled to particular email address
bob2210 (BOB member since 2010-09-23)
That’s a challenge because there is no way to get the info for a specific email address from a QueryBuilder query.
You can get to the info you’re looking for by running this query in QueryBuilder:
Select SI_ID, SI_NAME, SI_SCHEDULEINFO.SI_DESTINATIONS from CI_INFOOBJECTS where SI_INSTANCE = 1
However, you can’t filter the data down to a specific destination. Instead, you need to manually look at the results for Scheduling Info >> SI_DESTINATIONS >> 1 >>
SI_DEST_SCHEDULEOPTIONS >> SI_PROGID = “CrystalEnterprise.Smtp”. From there, the email addresses will be in one or more of the properties of SI_DEST_SCHEDULEOPTIONS just below the SI_PROGID entry.
You can also get to this information by writing code using either the Java or the .NET SDK.
-Dell
hilfy (BOB member since 2007-04-16)