how to get most recent created incident

[EswarS]

Hi Team,

Can anyone help me  on this

how to get the latest created incident or sctask through scripts

Thanks in advance

[Dr Atul G- LNG · Accepted solution]

Hi @EswarS 

What is the use case you have here? You can do it via list view and sort by created date.

Try this script:

var incidentList = [];

var incident1 = new GlideRecord('incident');

incident1.query();

while(incident1.next()){

    var incident2 = new GlideRecord('incident');

    incident2.orderByDesc('sys_created_on');

    incident2.query();

    if(incident2.next()){

        incidentList.push(incident2.number.toString());

    }

}

var uniqueIncidentList= new ArrayUtil().unique(incidentList);

gs.print(uniqueIncidentList);

I tested this in my PDI and it is working fine.

[OlaN · Accepted solution]

Hi,

Not sure what you want to do with the record you retrieve through the script, but here's something to show how to do.

var latestIncGR = new GlideRecord('incident');
latestIncGR.orderByDesc('sys_created_on');  // sort by created
latestIncGR.setLimit(1);  //only retrieve one record
latestIncGR.query();
if (latestIncGR.next()){
	gs.info('Number: ' + latestIncGR.getValue('number'));
}

[Dr Atul G- LNG · Accepted solution]

Hi @EswarS 

What is the use case you have here? You can do it via list view and sort by created date.

Try this script:

var incidentList = [];

var incident1 = new GlideRecord('incident');

incident1.query();

while(incident1.next()){

    var incident2 = new GlideRecord('incident');

    incident2.orderByDesc('sys_created_on');

    incident2.query();

    if(incident2.next()){

        incidentList.push(incident2.number.toString());

    }

}

var uniqueIncidentList= new ArrayUtil().unique(incidentList);

gs.print(uniqueIncidentList);

I tested this in my PDI and it is working fine.

[OlaN · Accepted solution]

Hi,

Not sure what you want to do with the record you retrieve through the script, but here's something to show how to do.

var latestIncGR = new GlideRecord('incident');
latestIncGR.orderByDesc('sys_created_on');  // sort by created
latestIncGR.setLimit(1);  //only retrieve one record
latestIncGR.query();
if (latestIncGR.next()){
	gs.info('Number: ' + latestIncGR.getValue('number'));
}

[EswarS]

Thank U OlaN

ur script worked fine

[Mimi Edet · Accepted solution]

Hi @EswarS

You can execute this script in background script or any other script execution environment in ServiceNow. I recently created three incidents on my PDI, and use this script in background script to test. Kindly find attached.

Regards,

Mimi Edet

LinkedIn: https://www.linkedin.com/in/edet-promise/

=========================================================
If my response proves useful, please indicate its helpfulness by selecting "Accept as Solution" and " Helpful."