Script to count

[Avinash Dubey2]

Write a script to display callers who have more than 5 incidents

[Mohith Devatte · Accepted solution]

Hello @Avinash Dubey ,

TRY THIS SCRIPT

var arr=[];
var agg = new GlideAggregate('incident');
agg.addAggregate('COUNT', 'caller_id');
agg.query();
while (agg.next()) {
    //do things on the results
    var incidentCount = agg.getAggregate('COUNT', 'caller_id');

if(incidentCount>5)
{
arr.push(agg.caller_id.name.toString());
}
 }
gs.info(arr);

MARK MY ANSWER CORRECT IF IT HELPS YOU