ITSM

[SomyaG]

Hello,

script to get the list of incident number according to all category .

 Can anyone help?

Thanks in advance

[Vishal Jaswal]

Hello @SomyaG 

var incidentGR = new GlideAggregate('incident');
incidentGR.addNotNullQuery('category');
incidentGR.groupBy('category');
incidentGR.query();
while (incidentGR.next()) {
   var category = incidentGR.getValue('category');
   gs.print('Category: ' + category + '\n');
   var incGR = new GlideRecord('incident');
   incGR.addQuery('category', category);
   incGR.query();
   while (incGR.next()) {
       gs.print('  - ' + incGR.getValue('number'));
   }
}