Report for ticket based on Time Open field
I was wondering if anyone could assist with creating a report that has the Time Open field (shows the amount of time a ticket has been open) that is seen when looking at a listing of tickets in the Tickets queue.
I am looking for a report that shows ticket ID, requester, owner of SDCSC, title, and narrowed down for a time period of the last 2 years. I can get the report created via the wizard, but the field time open is not available.
Any assistance will be greatly appreciated.
Thank you!
I am looking for a report that shows ticket ID, requester, owner of SDCSC, title, and narrowed down for a time period of the last 2 years. I can get the report created via the wizard, but the field time open is not available.
Any assistance will be greatly appreciated.
Thank you!
2 Comments
[ + ] Show comments
-
Do you have experience with MySQL? This will be possible but the report will need to be modified from what the wizard creates. - chucksteel 9 years ago
-
I have very little experience with MySQL. But I am willing to give it a try. - annleacock 9 years ago
-
The first step is to enable the reporting user on your appliance so that you can connect with a database tool. The recommended software is MySQL Workbench. It is free and works very well. Once you have that setup you can browse the tables and work on queries. - chucksteel 9 years ago
-
thanks. - annleacock 9 years ago
Answers (0)
Please log in to answer
Be the first to answer this question
