I'm wondering if I'm just missing something...

In the events module, we're able to see a list of names of people who have registered. I assume that this is a combination of first and last names in the system. The problem comes when the user only has a first name listed. We need to send them an email in Outlook and there is no way of knowing who these people are. Is there a way to list their email addresses along with their names? Or, alternatively, is there a way to see the user name of the person who enrolled? We have someone named "Susan" enrolled but there are 4 people in the system with just a first name of "Susan."

Any help would be appreciated, thank you!

Thanks for the reply.

I don't see a way to look up the displayname. I see username, first name, middle name, and last name. There isn't a way to see the username? That would be helpful because it's unique. Is there any way to modify it to show the username that was used to enroll? I would think that is recorded somewhere.
..

Great, thank you for the prompt! Off to augment my SQL knolwedge!

I'll post if/when I figure it out.