Background script

[shid077]

Write a script to Print the last 5 incident of yesterday.

Write a script to print the Category and Subcategory of incident count.

[Community Alums]

Hi @shid077 ,

var inc= new GlideRecord('incident');

inc.orderByDesc('sys_created_on');

inc.setLimit(5);

while(inc.next())

{

arr.push(inc.number.toString());

}

gs.print(arr);

And follow this thread  for the next ask :https://www.servicenow.com/community/platform-analytics-forum/incident-count-based-on-category-subca...

[SunilKumar_P]

Hi @shid077, You can refer to https://developer.servicenow.com/dev.do#!/reference/api/vancouver/server/no-namespace/c_GlideAggrega... 

var ga = new GlideAggregate('incident');
ga.addAggregate('COUNT', 'category');
ga.query();
while (ga.next()) {
   var incidentCount = ga.getAggregate('COUNT', 'category');
   gs.info('{0} count: {1}', [ga.getValue('category'), incidentCount]);
}

Regards,

Sunil

[shid077]

Hi Sunil,

Thanks for response.

what about subcategory how to handle that.

[swathisarang98]

Hi @shid077 ,

You can try below code In background script or any server side scripting,

var inc = new GlideRecord('incident');
inc.addEncodedQuery('sys_created_onONYesterday@javascript:gs.beginningOfYesterday()@javascript:gs.endOfYesterday()');
inc.orderByDesc('sys_created_on');
inc.setLimit(5);
inc.query();
while(inc.next())
{
    var category = inc.category;
    var subcategory =inc.subcategory;
    var created = inc.sys_created_on;

    gs.print('\n'+'Incident:' + inc.number + '\n' + 'Category: ' + category + '\n' + 'Subcategory: ' + subcategory + '\n' + 'Created:' + created);
}

For second query you can use below,

var agg = new GlideAggregate('incident');
agg.addAggregate('COUNT');
agg.query();
  while (agg.next()) {
     var category = agg.category;
     var count = agg.getAggregate('COUNT');
     gs.info('\n' +"Total Incidents"+count);
     var agg2 = new GlideAggregate('incident');
     agg2.addAggregate('count', 'category');
     agg2.orderBy('category'); 
    agg2.query();
        while (agg2.next()) {
         var category = agg2.category;
         var count = agg2.getAggregate('count', 'category');
         gs.info(category + ": Current number of incidents:" + count);
                            }
        
        var subcategory = agg.subcategory;
     var count1 = agg.getAggregate('COUNT');
     gs.info('\n' +"Total Incidents"+count1);
     var agg3 = new GlideAggregate('incident');
     agg3.addAggregate('count', 'subcategory');
     agg3.orderBy('subcategory'); 
    agg3.query();
        while (agg3.next()) {
         var subcategory = agg3.subcategory;
         var count1 = agg3.getAggregate('count', 'subcategory');
         gs.info(subcategory + ": Current number of incidents:" + count1);
                            }
                    }

Please mark this comment as Correct Answer/Helpful if it helped you.

Regards,

Swathi Sarang