This would give you the date the article was flagged. It creates a new entry when articles are flagged, rated, commented, etc.
No scripting needed. Schedule that and check the box that says "Don't send if empty" (or something like that). I think that meets your requirements.
Ok, the notification email script:
(function runMailScript(/* GlideRecord */ current, /* TemplatePrinter */ template,
/* Optional EmailOutbound */ email, /* Optional GlideRecord */ email_action,
/* Optional GlideRecord */ event) {
// Add your code here
template.print("<p></p>Flagged Articles:<br />");
var flag = new GlideRecord('sys_history_line');
flag.addEncodedQuery('label=Flagged^new=true^update_timeONToday@javascript:gs.daysAgoStart(0)@javascript:gs.daysAgoEnd(0)');
flag.query();
while(flag.next()){
template.print(flag.set.id.number + ": " + flag.update_time + "<br />");
}
})(current, template, email, email_action, event);
the email notification when event is fired:
The resultant email:
Of course, add styling and spacing and whatever and you have a very basic email that you can schedule the event (schedule a run script: gs.eventQueue) and it will send it out every night upon your schedule.
