Annual Report Stats

Customer requests resolved

Rough meaning: How many requests from customers and users did we resolve this year?

More precise meaning: count of JSM Incidents and Service Requests assigned to OIT Support Teams in centrally-managed campus-facing support desks (not OITSD or TSD or AUXS) resolved between October 1 - September 30

Exact JQL: project in ("IT Service Desk","PSU Support Desk","TC Service Desk","Agent Support Desk","Faculty Support Desk","Student Support Desk") AND "Support Team[Select List (cascading)]" in ("OIT") AND issuetype in("Incident","Service Request","Service Request with Approvals","Service Request with Approvals - All Required") AND resolved >= 2023-10-01 AND resolved < 2024-10-01

Execute the JQL query above, then click on “1000+” below results to “See the total number of issues.”

Average customer satisfaction score

Rough meaning: How satisfied were our customers and users with how we handled their requests this year?

More precise meaning: average of all Satisfaction scores for JSM Incidents and Service Requests assigned to OIT Support Teams in centrally-managed campus-facing support desks (not OITSD or TSD or AUXS) resolved between October 1 - September 30

Exact JQL: project in ("IT Service Desk","PSU Support Desk","TC Service Desk","Agent Support Desk","Faculty Support Desk","Student Support Desk") AND "Support Team[Select List (cascading)]" in ("OIT") AND issuetype in("Incident","Service Request","Service Request with Approvals","Service Request with Approvals - All Required") AND resolved >= 2023-10-01 AND resolved < 2024-10-01 AND Satisfaction IS NOT EMPTY (same as above, with the added final clause)

Execute the JQL query above, making sure that Satisfaction is one of your visible columns. Select Apps > Open in Microsoft Excel to download all search results (not just the single screen of results you get using Export issues). Open the exported file in Excel. Highlight all Satisfaction values and correct error with “Convert to Number”. Highlight entire Satisfaction column to see Average in lower right corner of application window.

Projects completed

Rough meaning: How many projects (larger chunks of planned work; sequences of unique, complex, and connected activities that have one goal or purpose) did we complete this year?

More precise meaning: count of Done OIT Portfolio issues with Due Date between October 1 - September 30

Exact JQL: project ="OIT Project Portfolio" AND issuetype="OIT Project" AND status=Done AND due >= 2023-10-01 AND due < 2024-10-01

Execute query, note count below results.

Operational changes completed

Rough meaning: How many changes (smaller chunks of formally documented work; additions, modifications, or removals of anything that could impact IT services) did we complete this year?

More precise meaning: count of Resolved JSM Change issues in TSD with Change Start Date between October 1 - September 30

Exact JQL: project="Technical Service Desk" AND issuetype="Change" AND status="Resolved" AND "Change Start Date" >= 2023-10-01 AND "Change Start Date" < 2024-10-01

Execute query, note count below results.