When creating custom alerts, I would like to be able to include information that can be retrieved by running a SQL query.

One example is using the pre-built Failed SQL login custom alert that is available to setup. The alert notifies when this event occurs, but it fails to include information like which login failed, etc.

It would be nice to be able to build part of the e-mail body in the alert to include some critical data that can be queries using T-SQL.