You will need to change the event from DDL_EVENT to the correct event type which is DDL_LOGIN_EVENTS

DDL Event Tree - http://msdn.microsoft.com/en-us/library/bb510452%28v=sql.100%29.aspx

You will need to query the eventdata() to get the data which is contained with in which is an XML format, so you need to pull out the information needed from that