Is there a way to list email recipients by schedule We woul...

[Debra Waybright]

Is there a way to list email recipients by schedule We would like to find schedules that email to specific email addresses.

Thanks!

[VisuaLizeFOCUS .]

I think this information should be available in WebFOCUS Repository.

Where is your WebFOCUS repository is it derby or External Database

Ill check if the list is there or not but i am not sure as it will also depends how is your distribution list created.

[Debra Waybright]

It is a SQL Server database. Im just looking for reports that use email addresses to distribute reports. We just have so many, it is too time consuming to look at each individually. Im sure there must be a query that could be built to pull that data. Im just not familiar enough with the tables.

Thanks!

[SATHEESH B]

Create connection to your repository

Create synonym for the for the following bot tables.

BOTSCHED

BOTDIST

BOTSIT

 

Email Schedules can have email address or distribution list. The blow code will help you get the emails.

JOIN

BOTSCHED.BOTSCHED.SCHEDULEID IN botsched TO MULTIPLE BOTSIT.BOTSIT.SCHEDULEID

IN botsit TAG J1 AS J1

END

JOIN

LEFT_OUTER BOTSCHED.BOTSCHED.SCHEDULEID IN botsched TO MULTIPLE

BOTDIST.BOTDIST.SCHEDULEID IN botdist TAG J0 AS J0

END

TABLE FILE BOTSCHED

PRINT

J0.BOTDIST.DISTDESC

BY BOTSCHED.BOTSCHED.JOBDESC AS Job

BY BOTSCHED.BOTSCHED.CASTER_USER AS User

BY BOTSCHED.BOTSCHED.ACTIVE NOPRINT AS Status

BY BOTSCHED.BOTSCHED.LASTEXSTATUS AS Job Status

BY J0.BOTDIST.DISTLIST

BY BOTSCHED.BOTSCHED.FULLDISTLIST

ON TABLE SUBHEAD

ReportCaster Schedules

WHERE ( BOTSCHED.BOTSCHED.ACTIVE EQ Y ) AND ( J0.BOTDIST.DISTDESC EQ Email );

ON TABLE SET PAGE-NUM NOLEAD

ON TABLE SET ASNAMES ON

ON TABLE NOTOTAL

ON TABLE PCHOLD FORMAT HTML

END

[Debra Waybright]

Satheesh to the rescue! It works a charm! Thank you!!