Recovering a Deleted Jive Event Attendee/RSVP List (Self-Hosted)

Solution

Issue

An event was deleted in Jive, and the organizers need to recover the attendee list (including RSVP state) to send follow-up communication.

Common symptom

• Database query attempts return no rows (reported as: “our database isn’t returning any results”).

What data to retrieve

Event attendees/invitees are stored as invitation records at the database level for self-hosted Jive instances and are typically retrievable via invite-related tables. Use the event’s numeric ID (from the event URL) as the object ID in your queries.

• Event URL pattern: https://your_instance.domain.com/events/<event_id>
• Use <event_id> as objectid in queries.

Step 1: Query the invite table for internal users

Run the following query to return invitees associated with the event:

SELECT userid, email, state
FROM jiveinvite
WHERE objectid = <event_id>;

Expected result

• One row per invite/attendee, including:
  • userid (internal user identifier)
  • email
  • state (RSVP state)

Step 2: Check external invite storage (if applicable)

If your event supported external invitees, also check the external invite table:

• Query jiveextinvite for the same <event_id>. (Table structure may vary by schema/version; the goal is to locate external invite rows tied to the event’s object ID.)

If the query returns no results

If jiveinvite (and jiveextinvite, if used) return no rows for the event, the invitation records are no longer present in the active database—most commonly because they were removed when the event was deleted.

Important note about AuditLog

• The AuditLog table can contain a record that an event was deleted.
• AuditLog does not store a structured attendee list or RSVP snapshot that can be used to reconstruct the attendee list after the invite rows are gone.

Final recovery option (when invite rows are missing)

If the invite records no longer exist in jiveinvite/jiveextinvite, the remaining option is to retrieve the data from a database backup taken prior to the deletion:

1. Identify the most recent backup created before the event deletion time.
2. Restore the backup to a non-production environment (recommended) or otherwise query the backup data source.
3. Run the same invite-table queries against the restored/backup dataset using <event_id>.
4. Export the attendee list for organizer follow-up.

Validation

• Successful recovery: queries return rows with attendee identifiers/emails and RSVP state.
• If queries return no rows in both the live database and the pre-deletion backup, the attendee list is not recoverable from database invite records.