KACE Product Support Question

What are some of the best software available that i can use to analyze my k1000 database

01/18/2016 922 views
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?

Community Chosen Answer

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:


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

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
Answered 01/19/2016 by: Hobbsy
Red Belt

  • 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


    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
    • 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.
      • This in formation is recorded

All Answers

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. 
Answered 01/19/2016 by: nshah
Red Belt

We may be able to help with that


But didn't want to "ram our solution down your throat"
Answered 01/21/2016 by: Hobbsy
Red Belt

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? 

Answered 01/30/2017 by: michaellynton
Yellow Belt

Don't be a Stranger!

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

Sign up! or login


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