I'll go right to the point. I'm writing this on my friend's behalf. He's a computer science major (senior) and currently an intern at the IT support somewhere. He was asked to come up with a project idea that benefits his department and bring it into reality. It definitely has to involve programming. His department uses BMC Remedy, and they prefer something that has to deal with it.
So, ideas please? Thank you! :)