Trying to get last 7 days email logs with exact time

[saikiranbh3]

Hi everyone,

Trying to get last 7 days email logs with exact time

Ex: I am trying to query the email logs from BR at "2024:11:01 08:00:00 ". It needs to retrieve the logs

From "2024:10:26 08:00:00" to "2024:11:01 08:00:00 ".

Any suggestions on this.

Thankyou.

[SumanKumarM]

Hello Saikiran,

Please use below filter,

sys_created_onBETWEENjavascript:gs.dateGenerate('2024-10-26','08:00:00')@javascript:gs.dateGenerate('2024-11-01','08:00:00')

Please mark helpful, if it helps you in resolving the issue.

BR,

Suman.

[saikiranbh3]

Thanks for your kind response SumanKumar.

Unfortunately it's not taking between dates query I'm adding the screenshots of the error please check that

BR

Sai kiran

[saikiranbh3]

Hi suman

Thanks for your kind response but it's not working can you please look into my code once. Its not giving any error but retriving all the notifications. Not only for perticular perios

var gdt = new GlideDateTime(gs.nowDateTime());
gs.log(gdt);
var dateArr = gdt.getDisplayValue().split(' ');
var starttime = dateArr[1];//Return time
var startdate = dateArr[0];//return date
gs.log(startdate);
gs.log(starttime);

var ed = new GlideDateTime(gdt);
ed.addDays(-7);
ed.addSeconds(3600);
var enddateArray = ed.getDisplayValue().split(' ');
var endtime = enddateArray[1];//Return time
var enddate = enddateArray[0];//return date
gs.log(ed);
gs.log(enddate);
gs.log(endtime);

var demo = "'sys_created_on1BETWEEN@javascript:gs.dateGenerate('"+enddate+"','"+endtime+"')@javascript:gs.dateGenerate('"+startdate+"','"+starttime+"')'";
gs.log(demo);

var agg = new GlideAggregate('sys_email_log');
agg.addEncodedQuery("sys_created_on1BETWEEN@javascript:gs.dateGenerate('"+enddate+"','"+endtime+"')@javascript:gs.dateGenerate('"+startdate+"','"+starttime+"')");
agg.addAggregate('count', 'notification');
agg.query();
while (agg.next()) {
    var count = agg.getAggregate('count', 'notification');
    var tables = agg.notification.collection;
    var message = count + ' | ' + agg.notification.getDisplayValue() + ' | ' + tables;
    gs.log(message);
}
// sys_created_onBETWEENjavascript:gs.dateGenerate('2024-11-01','00:00:00')@javascript:gs.dateGenerate('2024-11-04','23:59:59')

BR

Sai kiran.