Authoritative location of ticket requestor WAS: Cannot find the current requestor from the database

Just in case anyone else is having a similar problem as Samuli here,, to easily
determine a ticket’s requestor when hitting the db the answer lies in
the Groups and GroupMembers tables. To get a list the most prolific
requestors use:

select distinct GroupMembers.MemberId, Count(Groups.Instance)
AS cnt from Groups, GroupMembers where Groups.Domain =
‘RT::Ticket-Role’ AND Groups.Type=‘Requestor’ AND
GroupMembers.GroupId = GROUP BY
GroupMembers.MemberId ORDER by cnt DESC LIMIT 10;

Cambridge Energy Alliance: Save money. Save the planet.