Number of Change Tickets Assigned to active groups in last 12 months

[Zubair Alam]

Hello Enthusiasts!
How can we fetch the list of groups that were assigned a change ticket in the last 12 months?

All help is greatly appreciated. Thanks.

[Dr Atul G- LNG · Accepted solution]

Hi @Zubair Alam 

Your requirement is not entirely clear. Do you want to see how many changes have been assigned to the group in the last 12 months, or am I mistaken? If it's the first case, then..

[Ankur Bawiskar · Accepted solution]

@Zubair Alam 

use this in background script

var gr = new GlideRecord('change_request'); // Table for change requests
gr.addEncodedQuery('sys_created_on>=javascript:gs.beginningOfLast12Months()'); // Filter for the last 12 months
gr.query();

var groups = {};
while (gr.next()) {
    var group = gr.assignment_group.getDisplayValue();
    if (group) {
        if (!groups[group]) {
            groups[group] = 0;
        }
        groups[group]++;
    }
}

// Print the results
for (var groupName in groups) {
    gs.info(groupName + ': ' + groups[groupName] + ' change tickets');
}

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Ankur Bawiskar]

@Zubair Alam 

Hope you are doing good.

Did my reply answer your question?

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Zubair Alam]

Thanks for the help @Ankur Bawiskar 

[Shivalika · Accepted solution]

Hello @Zubair Alam 

Please confirm if you checked my answer. Kindly mark my answer as helpful and accept solution if it helped you in anyway. This will help me be recognized for my efforts and also it can move from unsolved bucket to solved bucket. 

Regards, 

Shivalika 

My LinkedIn - https://www.linkedin.com/in/shivalika-gupta-540346194

My youtube - https://youtube.com/playlist?list=PLsHuNzTdkE5Cn4PyS7HdV0Vg8JsfdgQlA&si=0WynLcOwNeE