/build/static/layout/Breadcrumb_cap_w.png

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
  • MAXintosh - the MS BI desktop is really neat, will have to look into that.

    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

Answers (2)

Answer Summary:
Posted by: MAXintosh 7 years ago
Senior Purple Belt
3

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
Yellow Belt
0
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 A0V0RZx.png

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 6 years ago

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ