Send a screen shot and description of a solution you're particularly proud of. We'll post it here. Send your submissions to Sonja Froyen.
Submitted by: Sonja Froyen, Office of International Programs
We're an IT department of three, plus two student workers. We support a approximately 150 users in five units scattered across campus. We built this database to track requests for technical support:
Users submit tickets using a simple web form. They can browse past tickets and add notes to open tickets. As IT staff, we also have a web interface to manage tickets:
Then we created an iPhone app (well, we spoofed and iPhone app). It appears as a button on our iPod Touches:
We can browse open tickets...
...assign new tickets and add notes to tickets: