How to get List of RITM's records from Script Include

[Supriya25]

Hi All,

Could you please help me how to get list of  RITM's records, which RITM has only All Closed Tasks
Conditions : 
1.RITM should have at least one Task record 
2.All  tasks should be closed ,no single task should be open state,
3.If any Task Open State, that RITM should not consider

IF we see there RITM0010002 tasks  all  are closed task, 
RITM0010001 has still open tasks. 

Only Which RITM of all Tasks closed that RITM numbers only should Return. (result should be RITM0010002)

[Dr Atul G- LNG]

Hi @Supriya25 

Try this:

[Supriya25]

IF we see there RITM0010002 tasks  all  are closed task, 
RITM0010001 has still open tasks. 

Only Which RITM of all Tasks closed that RITM numbers only should Return. (result should be RITM0010002)

[RAMANA MURTHY G]

Hello @Supriya25 ,

Please find below background script, you can change script according to your requirements

var gr = new GlideAggregate('sc_task');
gr.addAggregate('COUNT','request_item');
gr.groupBy('request_item');
gr.addEncodedQuery('stateIN-5,1,2');     // state is one of open, pending, work in progress
gr.query();
gs.info(gr.getRowCount());
while(gr.next()){
    gs.info(gr.request_item.getDisplayValue() + "->"+gr.getAggregate('COUNT','request_item'));
}

Please mark my answer helpful & correct, it it helps you

Thank you

[Supriya25 · Accepted solution]

It was resolved , Thanks to Ankur
https://www.servicenow.com/community/platform-analytics-forum/report-on-all-open-ritms-but-all-the-r...