Could you please provide me the script to find number of incidents opened this month

[kpkumar2k9]

Could you please provide me the script to find number of incidents opened this month

[dgarad]

Hi @kpkumar2k9 

Please refer below script.

var inc= new GlideRecord('incident');
inc.getEncodedQuery('opened_atONThis month@javascript:gs.beginningOfThisMonth()@javascript:gs.endOfThisMonth()');
inc.query();
while(inc.next()){
    gs.print("count"+inc.getRowCount());
}

Regards,

Dharmaraj

[_Gaurav]

Hi @kpkumar2k9 
Please use the below code to get the number of the incident opened this month.

var grIncident = new GlideRecord('incident');
grIncident.addEncodedQuery("opened_atONThis month@javascript;gs.beginningOfThisMonth()@javascript;gs.endOfThisMonth()");
grIncident.query();

gs.print(grIncident.getRowCount());

Please mark this as helpful and accept it as a solution if this works for you.
Thanks!

[swathisarang98]

Hi @kpkumar2k9 ,

You can try the below code in background script or in Fix script,

var ga = new GlideAggregate('incident');
ga.addQuery('sys_created_onONThis month@javascript:gs.beginningOfThisMonth()@javascript:gs.endOfThisMonth()');
ga.addAggregate('COUNT');
ga.query();
var incidents_opened = ga.next() ? ga.getAggregate('COUNT') : 0;
gs.info("Total number of incidents created on this month are :- " + incidents_opened);

Result:

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

Regards,

Swathi Sarang

[AndersBGS]

Hi @kpkumar2k9 ,

Please provide some additional context to why you need a script? Incidents opened this month is basic condition in the condition builder used across ServiceNow.

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

best regards

Anders