Bottleneck in your sprint? How to generate a Sprint Workload Report

1project = "SRCLOUD" AND sprint in openSprints () and statusCategory not in (Done)

1/*
2* This example script console script can be run in the in the script console inside ScriptRunner for Jira Cloud in order to see how many issues each user has assigned to them in a sprint. 
3* "All right, title and interest in this code snippet shall remain the exclusive intellectual property of Adaptavist Group Ltd and its affiliates. Customers with a valid ScriptRunner
4* license shall be granted a  non-exclusive, non-transferable, freely revocable right to use this code snippet only within their own instance of Atlassian products. This licensing notice cannot be removed or
5* amended and must be included in any circumstances where the code snippet is shared by You or a third party." 
6*/
7
8def projectKey = "<ProjectKeyHere>"; // Specify the project key here
9
10def jqlQuery = "project = ${projectKey} AND sprint in openSprints() and statusCategory not in (Done)";
11
12def searchRequest = get("/rest/api/2/search")
13        .queryString("jql", jqlQuery)
14        .queryString("fields", "status, assignee, key")
15        .asObject(Map);
16
17// Assert that the API call to the search API returned a success response        
18assert searchRequest.status == 200;
19
20// Extract the issue properies returned from the search results to a List
21def issues = (List<Map<String, Object>>) searchRequest.body.issues;
22
23// Call the returnSprintReport utility method passing it the list
24returnSprintWorkloadReport(issues);
25
26// A utility method that returns the sprint report information. 
27def returnSprintWorkloadReport(List<Map<String, Object>> issues) {
28
29// Loop over all issues and log out a report to the Logs detailing who is assigned to each issue and what status it is in.
30// as well as to construct an object of how many issues each assignee has in descending order including unassigned issues and display this information. 
31    return issues.groupBy { issue ->
32        println("${issue.key} is assigned to ${issue.fields.assignee?.displayName ?: 'Unassigned'} and is in the ${issue.fields.status.name} status.")
33        ((Map<String, Map>) issue.fields).assignee?.displayName ?: 'Unassigned'
34    }.collectEntries { assignee, issueList ->
35        [(assignee): issueList.size()]
36    }.sort({ a, b -> b.value <=> a.value })
37};