Dashboard for Service Desk
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.
Thanks
1 Comment
[ + ] Show comment
Answers (2)
Answer Summary:
Please log in to answer
Posted by:
MAXintosh
7 years ago
Top Answer
JC_Chi,
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.
http://www.itninja.com/blog/view/power-bi-desktop-setup-for-visual-kace-reports
Comments:
-
Worked like a charm with an added update query too. Thanks! - JC_Chi 7 years ago
Posted by:
Myth0S
7 years ago
A solution does exist and the name is Metabase, which is similar to Power BI but easier to write queries and as it works through a web browser is accessible from everybody that has an account.
http://www.metabase.com/
Have a look at our dashboard 
Numbers are hidden on purpose.
Comments:
-
I'm using metabase, but I'm having issues getting a question setup that will show me the average time to close a ticket. Can you provide some guidance? - wmforgey 7 years ago
JC_Chi - another option is Twitter Bootstrap for Kace, http://www.itninja.com/blog/view/twitter-bootstrap-for-kace-service-desk - Jbr32 7 years ago