PRD table which stores the Email Address for a Recurring Report in Learning Administration

[sitapati2]

Hi All

I am looking for the PRD table name in SuccessFactors learning which stores the Email Address for a Recurring Report to be sent in Learning Administration.

Thanks and Regards

Sitapati

[SF-Dan]

https://groups.community.sap.com/t5/q-a-forum-archive/report-on-scheduled-reports-and-email-recipien...

[sitapati2]

Thank You for the details. I will check and update if it worked or have any questions.

[SF-Dan]

PA_REPORT_JOB & PA_SCHEDULED_JOB both hold the data for report jobs. You can use the report_name in the pa_report_job table to get the job IDs. Then to see the info, it's PA_SCHEDULED_JOB_RESULT & PA_REPORT_JOB_RESULT - you can search by the job_id you got from previous table and get more info, like owner (this is the person who created the report). If the email of the owner had change you can use the user audit report to see the email addresses they had at the time of the creation of the recurring report job. Also within these tables you will be able to get any mail jobs which you can reference from the email summary audit reports to gather the to_addrs column (email address) for comparison.

[sitapati2]

Hi Daniel

I checked further and was able to fetch the data using the tables. I have 2 more questions:

1. There can be Email Address fields when we are scheduling a job which is different than the owner & owner's email id.

Like Person A schedules a job & is owner, but the Person A can add email id of Person B to receive those email notifications.

I got the Owner Name & Owner Email address but how to fetch the Person B's email address which may not be same

as owner email address?

And there are multiple tables where we have email address stored. Like which table will store?

2. There is a field - SCHEDULE in the table - PA_SCHEDULED_JOB which is String type and shows as example - 30 15 * * * Asia/Calcutta in the output file.

Can we convert this value to Date & Time format like Sep 06, 2019 3:30 PM? Is there any function or script to assist on this?

Thank You for the support on this.

[SF-Dan]

I'm not positive, but I believe the Person B email you mention is stored in the Blob field of the job details. As far as time conversion maybe reference the same provided in attachment under KBA 2379690, but I would not be familiar; hopefully someone else cna chime in with their experience.

[sitapati2]

Thank You for the help.