Joseph Jude

Y-A-T-S-Y 0.1 - DB and Reports

2008.07.23 / /

What reports should a helpdesk system have?

For the first version, I want to keep the system very simple and easy (as I matter of fact, I'm a die-hard proponent of simplicity; but that is for another post).


A Helpdesk system revolves around 'Case' (or ticket or problem). The DB design I've shown below supports 'Case' and other support data - like Priority and Category.

DB model for helpdesk system

I haven't included Level, SLA (which will include holidays, business hours) and so on. Those are for next version.


These are not exhaustive, but should provide a quick view of reports needed out of a Helpdesk System.

Summary Reports

  1. Month-wise report on reported Cases
  2. Month-wise reported Cases by Priority
  3. Month-wise reported Cases resolved by Agent
  4. Customer Satisfaction Score by Agent
  5. Customer Satisfaction Score by Priority

As features are added, there will be need for other reports.

It should be possible to export these reports as pdf, xls. (By default it will be just html).

If you've any questions/comments, please feel free to comment.

In case you would like to follow up progress of Y-A-T-S-Y, you can follow me on Twitter.

Share this post on

Twitter | | |
Sign up for my weekly newsletter

I will send blog updates to this email. You can unsubscribe at any time using the link in those emails.