Email script

[Sironi]

Hi,

someone help on incident script,

send  incident details list to assigned to if incident state is OnHold on single notification .

ex: DavidLoo hasbeen assigned to 10-incidents , in 10-incidents there are 7 incidents have state -onhold. so DavidLoo should receive 7-incident details (number, shortdescription, caller , priority)  in a single email.

i tried with below script, it is getting single incident details, how to get all in single email.

template.print("number :"+"${number}\n");

template.print("number :"+"${priority}\n");

template.print("number :"+"${caler_id}\n");

template.print("number :"+"${short_description}\n");

[Sironi]

yes i m getting right email "Test-List" but if we see it is triggering multiple mails for Freedleddy .

if you see below image there are 12 assignedto records are there right,

but is it triggering for 2 -assigned-to  users 

[Sironi]

yes i m getting right email "Test-List" but if we see it is triggering multiple mails for Freedleddy .

if you see below image there are 12 assigned-to records are there right,

but it is  triggering for 2 -assigned-to  users only

[Ankur Bawiskar]

@Sironi 

the current script would trigger for every incident record.

So here you need to use GlideAggregate

Updated job script; it would trigger single email for each assigned_to user

var agg = new GlideAggregate('incident');
agg.addEncodedQuery('active=true^assigned_toISNOTEMPTY');
agg.groupBy('assigned_to');
agg.query();

while(agg.next()){

var incidentSysId = agg.getValue('sys_id');

var gr = new GlideRecord('incident');
gr.get(incidentSysId);

gs.eventQueue('test-list', gr, gs.getUserID(), gs.getUserName());
}

Regards
Ankur

[Sironi]

Hi Ankur,

sorry to say this, it is not working.

sendEmail();

function sendEmail() {
    var agg = new GlideAggregate('incident');
    agg.addEncodedQuery('active=true^assigned_toISNOTEMPTY');
    agg.groupBy('assigned_to');
    agg.query();

    while (agg.next()) {

        var incidentSysId = agg.getValue('sys_id');

        gs.info("Test-List : "+incidentSysId);

        var gr = new GlideRecord('incident');
        gr.get(incidentSysId);

        gs.eventQueue('test-list', gr, gs.getUserID(), gs.getUserName());
    }
}

[Ankur Bawiskar]

Hi,

let me check and inform

Regards
Ankur