Report for tickets closed within same queue (First Level Resolution)
05/14/2019 235 views
Hi, could some one assist us with creating an sql report? We have multiple queues in Kace representing different levels of IT L1, L2, L3. Our default queue where all tickets begin is the L1 queue. We are looking for a way to report tickets that were created in the L1 queue, were never transferred, and subsequently closed under the same L1 queue (First Level Resolution). How would an sql query check that a ticket was never transferred.