Highest number of incidents created

[servicenow14710]

Hello developers, 

I need to get the highest number of incidents created by a particular person. Any help is appreciated, Thanks!

[Mark Roethof]

Hi there,

And in what setting? Scripted? Something else?

You could query matching the particular person + the opened on and order by that date descending.

[dgarad]

Hi @servicenow14710 

 Refer to the below script.

var ga = new GlideAggregate('incident');
//var arr = [];
ga.addAggregate('COUNT', 'caller_id');
ga.groupBy('caller_id');
ga.query();
while (ga.next()) {
    //arr.push(ga.getValue('caller_id'));
    gs.print(ga.getDisplayValue('caller_id') + " has " + ga.getAggregate('COUNT', 'caller_id') + " incidents");
}