AnsweredAssumed Answered

SQL Query to get tickets resolved by group?

Question asked by hebertuz on May 9, 2018
Latest reply on May 11, 2018 by hebertuz

Good day everyone,

 

Hope some can enlightenment me up here, Ihave CA SDM at work and have access to the SQL DB, I been tryong for days now to check a query to get what group closed the tickets (my filter will be by dates let´s say report for each month).

What I want to accomplish is to get some kind of resolution rate by solving group, let me be more detail about it, my Service Desk engineers create a ticket and assigned to second level IT, or second level infrastructure or you call it, I want to have a report that states out of 100 tickets, 20 where resolved by second level IT and 80 by infra group, is that possible or i´m lost here?

Outcomes