Best Practices Question
Dashboard for Service Desk
12/28/2016 3403 views
My boss is wondering if there is any way to analyze help desk tickets and put them on a screen in our office. First by showing how many tickets are open per technician, then showing by category, and how many were closed in the last 7 days. I have tried to join to the dB through access and sql workbench neither one seems to allow me to put data in a table. Turns out the date and other fields in the kace tables are actually plain text not numbers therefore you can't create any kind of graph or represent the data in anyway. Is there anyone that is doing anything like this ? Or showing the default queue on a big screen with custom graphs? I did see the software from the UK but that software is way to expensive.
Answer Chosen by the Author
Please log in to answer
KACE doesn't support what you're looking for. However, I have spent many hours looking into a solution and one does exist. Through the use of Microsoft Power BI Desktop (which is free) you can create visually appealing metrics. I wrote a guide on the Blogs section describing what you have to do. Check it out.
Answered 12/29/2016 by: MAXintosh