API to get the incident count in servicenow

[Dnyaneshwaree · Accepted solution]

Hello @SireeshaV ,

You can use the GlideAggregate API to get the incident count. Refer below example:

var ga = new GlideAggregate('incident');
ga.addAggregate('COUNT');
ga.query();

if (ga.next()) {
    var incidentCount = ga.getAggregate('COUNT');
    gs.info('Total number of incidents: ' + incidentCount);
}

[Mohan raj · Accepted solution]

Hi @SireeshaV ,

Do you mean REST API or Glide API ?

[Harish Bainsla · Accepted solution]

Hi @SireeshaV  use Glide aggregate 

var ga = new GlideAggregate('incident');

ga.addAggregate('COUNT');

ga.query();

if (ga.next()) {

var incidentCount = ga.getAggregate('COUNT');

gs.print('Total number of incidents: ' + incidentCount);

} else {

gs.print('No incidents found.');

}

[Dnyaneshwaree · Accepted solution]

Hello @SireeshaV ,

You can use the GlideAggregate API to get the incident count. Refer below example:

var ga = new GlideAggregate('incident');
ga.addAggregate('COUNT');
ga.query();

if (ga.next()) {
    var incidentCount = ga.getAggregate('COUNT');
    gs.info('Total number of incidents: ' + incidentCount);
}

[Mohan raj · Accepted solution]

Hi @SireeshaV ,

Do you mean REST API or Glide API ?

[Harish Bainsla · Accepted solution]

Hi @SireeshaV  use Glide aggregate 

var ga = new GlideAggregate('incident');

ga.addAggregate('COUNT');

ga.query();

if (ga.next()) {

var incidentCount = ga.getAggregate('COUNT');

gs.print('Total number of incidents: ' + incidentCount);

} else {

gs.print('No incidents found.');

}

[SN_Learn · Accepted solution]

Hi @SireeshaV ,

You can utilize the Glide Aggregate API for this.

Navigate to Rest API Explorer and fill out the details as below:

[active^true] encoded query will filter all the active incident records.

Click on Send button, the response will be as below:

Mark this as Helpful / Accept the Solution if this helps