/build/static/layout/Breadcrumb_cap_w.png

Report - How fast can the KBOX complete different tasks per machine?

Let's say you want to do a report on how long the various task types (inventory, patching, scripting, etc) are taking to complete, or averages of how long they're taking to complete.

 

Below are some reports you can run to see this type of information.

 

*****

Report Name:

CALCULATE AVERAGE TIME PER TASK today 

Deescription:
Takes a snapshot for today, how long each different task type takes to complete on average.
 
QUERY:
SELECT TYPE, count(*) as tasks, AVG(TIME_TO_SEC(TIMEDIFF(COMPLETED, STARTED))) as avg_time_in_seconds_to_complete
FROM KBSYS.KONDUCTOR_TASK
WHERE DATE(NOW()) = DATE(COMPLETED)
GROUP BY TYPE
ORDER BY 1;
 
*****
Report Name:
Calculate Avg. Time Per Task Per Hour
 
Description:
Takes a snapshot on each hour, how long each different task type takes to complete on average.
 
QUERY:
Select TYPE, hour(completed) as hour_of_day, minute(completed) as minute_of_day, count(*) AS TASK_TYPE_PER_HOUR_COMPLETED
from KBSYS.KONDUCTOR_TASK
WHERE DATE(NOW()) = DATE(COMPLETED)
GROUP BY TYPE, HOUR(COMPLETED), MINUTE(COMPLETED)
ORDER BY 2,3;
 
*****
Report Name:
Throughput of tasks per hour & minute completed for today
 
Description:
This shows how many tasks were actually completed at exactly what hour and minutes past the hour.
 
QUERY:
Select TYPE, hour(completed) as hour_of_day, minute(completed) as minute_of_day, count(*) AS TASK_TYPE_PER_HOUR_COMPLETED
from KBSYS.KONDUCTOR_TASK
WHERE DATE(NOW()) = DATE(COMPLETED)
GROUP BY TYPE, HOUR(COMPLETED), MINUTE(COMPLETED)
ORDER BY 2,3;
 
 
******
Report Name:
Throughput of tasks per hour completed for today
 
Description:
This shows how many tasks completed total within each hour for the day this report is ran on.
 
QUERY:
Select TYPE, hour(completed) as hour_of_day, count(*) AS TASK_TYPE_PER_HOUR_COMPLETED
from KBSYS.KONDUCTOR_TASK
WHERE DATE(NOW()) = DATE(COMPLETED)
GROUP BY TYPE, HOUR(COMPLETED)
ORDER BY 2,3;

Comments

  • Great reports, thanks for sharing!

    John - jverbosk 11 years ago
This post is locked
 
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