SQL Query to run a Report on Service Desk Tickets


Management have asked to too run a monthly report on the following - Any help will much appreciated

All tickets for a specified month by Priority.
information to be shown is 
Submiter username
Ticket ID
Modified - But what they want to see the first time the owner of the ticket modified the ticket, not the last
Time closed

Please can anyone help or point me in the right direction as i have minimal SQL experience

4 Comments   [ + ] Show comments
  • When you say by priority do you mean that priority should be one of the columns and the report should be sorted on that column? - chucksteel 4 years ago
  • report should be sorted by Priority, all tickets that are High, Medium and Low as a Header Breaker - hitesh.premji 4 years ago
  • "the first time the owner of the ticket modified the ticket"
    So the first time the first owner did anything to the ticket, other than being assigned to it? What about if someone besides the owner (e.g. approver) updates the ticket before that? Or what if the only action of the 'first' owner is to assign it to another user? - JasonEgg 4 years ago
  • Managers want to see how quickly IT reacted to the a ticket coming in. Only possible owners to the ticket are IT Members. So they want to see the first course of action they took to acknowledge the request - hitesh.premji 4 years ago

Answers (0)

Be the first to answer this question

This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ