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.

[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..

[Shivalika]

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

[Shivalika]

Hello @Zubair Alam 

You need to create metric_definition on change_request table. 

Refer the below screenshot - 

 Now after creating this metric definition I created a change request and made some changes in the assignment group field and they are being recorded. 

You can always set the filter as created in last 12 months to get the groups you want for any particular change request. 

Also you do reporting on this. 

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

Regards,

Shivalika 

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

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

[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.