SQL report to show currently open tickets from a specific location

Hi Everyone,

Wondering if I could get some help with the SQL code for a report.  I can't get a report to do this with the Wizard without having the results collapsed and that's irritating plus it looks like crap.  Here's what i'd like if possible...

1. List of currently open tickets from a specific location.
a. Pulls from the location field in the user accounts
b. Displays the following columns from tickets in this order
i. Time Opened
ii. Ticket ID
iii. Description
iv. Priority
v. Status
vi. Owner
vii. Submitter
c. Sorted by Time Opened
d. Filters:
i. User account location = LA
ii. Ticket status is != Closed. 
There's a location field in our help desk tickets but for some reason you can't filter on that in a report.  Maybe that's a field in SQL that can be used, but it's not an option in the filtering of a report.  I spoke with Quest's support and they told me I would need to get the report done in SQL from Professional Services.  

Is this something that someone can help me with or do I need to contact Pro Services?

Thanks everyone!

0 Comments   [ + ] Show comments

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