KBOX report showing "Ticket Created" and by whom
We need to put together a report showing the Ticket Created date/time but also who created the ticket. We need to determine who is handling the majority of ticket creations within our org. So far, we've not been able to find a field that displays the information contained in the first line of the first comment in a new KBOX ticket. Can anyone provide the name of the table/field we can call to retrieve this information? We have all the other information we need in our custom SQL already, this is the last piece of data we need. Any assistance is appreciated!