What are some of the best software available that i can use to analyze my k1000 database
I am required to find out how can i use reports to make an inform decision about my k1000 service desk eg
I get 500 tickets for the month of January about email problems, how could i then determine the leading cause of this emails
eg 300 would be server related
and 200 would be password related
1 Comment
[ + ] Show comment
-
Excellent - so then why not write a report in KACE? If you can screenshot a ticket screen that would help, we can then maybe create a report that gives you that information? - Hobbsy 8 years ago
Answers (4)
Please log in to answer
Posted by:
Hobbsy
8 years ago
Part of the answer to your question is actually depending on how you have your queue configured. Ironically I answered another post about categorisation of tickets last week which you may find useful, so below is the link to the article:
http://www.itninja.com/question/how-do-you-organize-your-ticket-categories?utm_source=itn_email&utm_medium=comment_alert_answer&utm_campaign=notifications&utm_content=question_permalink
What you are asking for is part of the Problem management discipline within the ITIL framework, if you categorise your tickets according to the above article, you will then need to add in a Root Cause field that must be populated before every ticket can be resolved, or alternatively add in a 4th level of categorisation that can hold the root causes and cannot be seen by the customer, but that can get a bit complicated
i.e.
Hardware Issue::Laptop PC::No Power to unit::Hardware failure::PSU Failure
Hardware Issue::Laptop PC::No Power to unit::Hardware failure::Faulty Power Lead
Within KACE you can add in a custom field format it as a dropdown and then I recommend starting pretty highlevel in the contents so maybe just:
Hardware Issue
Software Issue
Network Issue
Server Issue
End-user Education Issue
At least then you can start to report and see what root cause fields were selected the most and target your problem management guns there. You can always then remove and update the fields as you need to i.e. remove End-user Education Issue and addi End-user Education Issue - Password Reset and End-user Education Issue - Application Training
Hopefully that helps a little
Comments:
-
Thanks...i do understand what your saying and that's how i setup my queues...but what i would like to know is if there is any tool available that i can use to get summary information so i can then analyse the data
eg
Hardware issues = 50
Software issue = 40
when i drill down on hardware issues i get
PSU Failure 45
Faulty Power Lead 5
so then i could conclude from the data that Top tickets were Hardware issues and this was because of PSU Failure - emorrison 8 years ago-
My point is that you need to record that data within your ticket and then you will be able to create reports within KACE that will provide the information. There is no tool on the market that is able to apply BI if the information is not first recorded. - Hobbsy 8 years ago
-
This in formation is recorded - emorrison 8 years ago
Posted by:
nshah
8 years ago
The answer is no tool is available that will do it for you. Whether you use the KBOX reporting, BI, excel you will still have to write a sql query looking for the data you want and the correct syntax to do counts so you can get a number like Hardware issues = 50 etc instead of seeing 50 tickets.
In short, you'll need to have the data in the ticket and be able to write custom sql queries.
Posted by:
Hobbsy
8 years ago
We may be able to help with that
https://indigomountain.co.uk/project/dashboard/
But didn't want to "ram our solution down your throat"
Posted by:
michaellynton
7 years ago
Hi -
I know your post is old. I couldn't help but wonder: is getting actionable data from your Kace unit still a need for you? If so, I believe I could help. I have several years of experience working with Kace (and ticketing systems in general), as well as data visualization. I am a Tableau developer and build a lot of executive level and operational dashboard that provide insights to mountains of data. Naturally, like other commenters mentioned, the data you get out is only as good as the data you put in. Assuming you have good data in your system, I could help you extract insights. Are you interested in exploring some opportunities?
-Michael
