Have you seen the Team Server API? You could write an application to query this and send out alerts where necessary. Hope this helps.