Write a script to print Incident count based on priority.

[Parth_S]

Below is my script which is not giving expected O/P.

var gr = new GlideAggregate('incident');

gr.groupBy('priority');

gr.query();

var count = 0;

while(gr.next()){

    gs.info(gr.priority);

    count = count + 1;

    gs.info('Count is ' + count);

}

[Dr Atul G- LNG]

Hi @Parth_S 

I am not a developer but these links might be helpful

https://www.servicenow.com/community/developer-articles/get-last-updated-date-record-using-glideaggr...

https://www.servicenow.com/community/developer-forum/script-for-printing-count-of-incidents-per-assi...

[Abhishek_Thakur]

Hello @Parth_S ,

You can follow the below script, that will work:-

var gr = new GlideAggregate("incident");
gr.groupBy("priority");
gr.addAggregate("COUNT","priority");
gr.query();
while(gr.next()){
	gs.info("Priority is: "+ gr.priority + " and count is: "+ gr.getAggregate("COUNT","priority"));
}

Please mark my solution as accepted and give thumbs up, if it helps you.

Regards,

Abhishek Thakur

[sanketpatil09]

Hi @Parth_S ,

You can use the script below to obtain the count of incidents based on priority.

[Anand Kumar P]

Hi @Parth_S ,

Use below script

var agg = new GlideAggregate('incident');

agg.addAggregate('COUNT','priority');

agg.groupBy('priority');

agg.query();

while (agg.next()) {

    var priority = agg.getDisplayValue('priority');

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

    gs.info('Priority: ' + priority + ', Count: ' + incidentCount);

}

If my response helped, please mark it as the accepted solution ✅ and give a thumbs up👍.
Thanks,
Anand