I have a project where I want to pull data from the helpdesk database. However I am not very familiar on what tables I need to check to pull this data. Below is an example of the data I want to pull for helpdesk ticket status and history.
To simplify my request is I want to get a count of the ticket by the priority and if they were closed on time or not.
General related question for everyone, if not using the Reporting feature in WebHD, what software are you using? Do you link directly to the WebHD SQl tables to pull what you need? I assume that is what they mean saying use WebHD API to get what you need?
You can connect PowerBi to WHD database for reporting
You should be able to get this from the built-in reports.
Row Category = Priority
Column Priority = On-Time status
Table Data = Tickets
This should show something like this