K1000 Reporting: Getting Simpler Reports
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 (http://www.itninja.com/blog/view/creating-true-sla-timers-in-the-kbox-helpdesk-part-ii-considerations-for-the-rules-we-will-create) 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.