I am running Drupal 7.50. I'm using the Entity Registration module, and I have set up a small classroom enrollment content that I used to test this out.
My questions:
Where does Entity Registration store the signup data?
Looking at the module's .install file, those data should be stored in the table with name registration. Especially these columns of it should be close to what you're looking for:
'count' => array(
'description' => 'How many spaces this registration should use towards the total capacity for this event.',
'type' => 'int',
'not null' => TRUE,
'default' => 1,
),
'user_uid' => array(
'description' => 'The uid of the user associated with this registration.',
'type' => 'int',
'not null' => FALSE,
'default' => 0,
),
'author_uid' => array(
'description' => 'The uid of the user who created this registration.',
'type' => 'int',
'not null' => TRUE,
'default' => 0,
),
'state' => array(
'description' => 'The {registration_state}.name of this registration.',
'type' => 'varchar',
'length' => 32,
'not null' => TRUE,
'default' => '',
),
'created' => array(
'description' => 'The Unix timestamp when the registration was created.',
'type' => 'int',
'not null' => TRUE,
'default' => 0,
),
'updated' => array(
'description' => 'The Unix timestamp when the registration was most recently saved.',
'type' => 'int',
'not null' => TRUE,
'default' => 0,
How do I see the information collected?
Option 1: Just browse this table, using your preferred tool to do so.
Option 2: Use the Views module to create an appropriate view of it, as suggested also in its community documentation, i.e.: "Not happy with the default tabular list of registrations? No problem, registrations and their fields are all Views friendly. You can override the default event registrations list, create additional ones, etc". You probably want to enable its registration_views submodule for this.
How do I delete it?
It may be straight forward to just delete the relevant rows in the "registration" table mentioned above. However because of its integration with the Rules module, I'd rather use this module, possibly combined with the Views Bulk Operations module, to perform such deletes
