I created a script that would do this for any users that has a pending request for approvals, you could modify this for your need.
execute();
function execute() {
/* query approval table with GlideAggregate*/
var approval = new GlideAggregate('sysapproval_approver');
/* select only requested records */
approval.addEncodedQuery('state=requested');
/* group by approver in orer to get unique values (one distinct user at a time) */
approval.groupBy("approver");
approval.query();
while (approval.next()) {
/* Create a unique Scheduled Report */
createScheduleReport(approval.approver);
}
}
function createScheduleReport(user) {
/* set the appropiate sys_id of your 'Weekly Pending Approvals Report' report */
var TARGET_REPORT = "ec83ce72933e1e506f7ef36f3bba1080";
/* create the scheduled report */
var scheduled_report = new GlideRecord('sysauto_report');
scheduled_report.initialize();
/* set all the values */
scheduled_report.active = true;
scheduled_report.name = "WeeklyAutoApprovalReminder";
scheduled_report.run_as = user.getValue("sys_id");
/* this will replace "is (dynamic) Me" with the real name of the user */
scheduled_report.user_list = user.getValue("sys_id");
/* the scheduled report it's unique, hence it should run only once */
scheduled_report.run_type = 'once';
//scheduled_report.report_title = "Your Bi-Weekly SE Forms Pending Approval Report";
scheduled_report.report_title = "SE Forms Pending Approval - Action Required";
scheduled_report.report = TARGET_REPORT;
scheduled_report.omit_if_no_records = true;
/* it will attach the records using a spreadsheet attached to the email notification; check the choice list to see other options */
scheduled_report.output_type = "XLSX";
var answer = scheduled_report.insert();
}
