how i get the count of incidents which are created last month not in last 30 days with out specifying any date using background script

suprakash · ‎12-06-2016

how i get the count of incidents which are created last month not in last 30 days with out specifying any date using background script, without using any report types I dont want want to specify any date any month. suppose i am checking using background script in december the count will display the no. of incidents for the month of november .... how can i do it??

drjohnchun · ‎12-06-2016

Please try

var ga = new GlideAggregate('incident');
ga.addQuery('opened_atONLast month@javascript:gs.beginningOfLastMonth()@javascript:gs.endOfLastMonth()');
ga.addAggregate('COUNT');
ga.query();
var incidents_opened = ga.next() ? ga.getAggregate('COUNT') : 0;
gs.info(incidents_opened);

Please feel free to connect, follow, mark helpful / answer, like, endorse.

John Chun, PhD PMP