Project Join Requests

Sometimes we need to look at project join requests to watch for "doorknob rattlers". These are people who are trying to get attached to a project by sending lots of project join requests.

View recent join requests

To see who has submitted project join requests in the last 7 days:

select count(*), requestor
  from pa_project_member_request
  where creation_timestamp >= date(now()) - 7
  group by requestor;

This yields the following type of data:

 count |              requestor               
-------+--------------------------------------
     1 | 606D6C35-0CCD-4061-A73E-FB738D656A45
     1 | DDD0CFE7-5A1E-4A0C-ADD2-EC84F9390BA4
     1 | 00B060BF-0F1D-486D-954A-2FF23C138EF1
     1 | 1D8A0233-1E58-4DB4-850A-42BFE00FA4C3
     1 | F169A845-08F9-4CA7-B599-6852A459A262
(5 rows)

List pending requests

The command geni-list-pending-requests prints all pending requests, sorted by date. The project, requester user id, and date of request are listed.