1
How to query SQL DB
Question asked by ASB Admins - 10/18/2023 at 5:42 AM
Unanswered
I have a user that would like to run a query on the SmarterTrack DB for for the ticket number, the timestamp for when the ticket was assigned to a rep, and the userid number of the user id it was assigned to. Is there a way to do this? Thanks!

3 Replies

Reply to Thread
0
Kyle Kerst Replied
Employee Post
If you use an on-premise installation of SmarterTrack you should be able to query the underlying database using the same mechanisms you would query other SQL databases with. In this particular case you'd be looking for the st_tickets table which should contain data about the ticket itself. I recommend reviewing the other tables and table structure though as some of these details may be found in other areas. 
Kyle Kerst IT Coordinator SmarterTools Inc. www.smartertools.com
0
ASB Admins Replied
I was looking through the tables, but I don't find ticket transferred to agent time. 

@Ron - I'm not too familiar with using API's. I was looking through the instructions, but have no idea where to start.
0
Kyle Kerst Replied
Employee Post
Ticket transfers will be tracked in the st_TicketEvents table and are referenced by the event ID 1208 specifically. You may need to reference a few tables to get exactly what you're looking for, so your best bet is to leverage the API where possible. Our products are all API driven as well, so you can use the developer tools in your browser to get started in understanding how different functions work, then work your way back from there. Let us know if you get stuck or have questions we're always happy to help out where we can!
Kyle Kerst IT Coordinator SmarterTools Inc. www.smartertools.com

Reply to Thread