Sometimes all my boss wants is a number. For example, how many computers have 2G of RAM or less? Or in the Help Desk system with the custom ticket rules set up for a counter ( I would like to get an average number for total time opened or total time stalled. So, I just want a report that spits out a number.

Machines w/ less than 2G Ram = ??

Average time opened for all tickets in the last 7 days = ??

This is probably a simple SQL statement involving some sort of average command that I don't know. Thanks for any help.

Answer Summary:
0 Comments   [ - ] Hide Comments


Please log in to comment

Answer this question or Comment on this question for clarity



Typically SUM will give you a count, if that's what you're looking for.

Although there is an AVG function in SQL, based on the situation sometimes you have to create math-like statements to find the average, like here:

Some other functions you might read up on:

Hope that helps!


Answered 01/16/2013 by: jverbosk
Red Belt

  • I tried the second link and it works fine for giving me "time to close". The problem is that we have some stalled states that shouldn't be counted against technicians. What I really want is to track the time a ticket is in all opened states for particular users and then get an average of that to be more accurate. That's why i was setting up the sla timer to track time in stalled or open states.
Please log in to comment

I found this link and was able to create a sum for firefox versions, so this may help


Answered 01/16/2013 by: SMal.tmcc
Red Belt

  • Thanks! That's a really helpful link.
Please log in to comment