The Site Membership History report gives administrators visibility into when users were added to and removed from sites, including users who are no longer associated with any site. It reads an automatic record of membership changes and presents that history. The report only reflects membership history. It does not change any memberships.

1. What is the Site Membership History report?

It is a report that shows the history of user-to-site memberships in your organization. Every time a user is added to a site, an Added event is recorded. Every time a user is removed from a site, a Removed event is recorded. The report reads and organizes these events so you can see both current memberships and past site relationships.

2. Where do I find it?

You can open the report in two places:

• From the organization Reports page, select the Site membership history card under the Profile Data group.
• From the Database page, open the view dropdown and select Site Membership Report under Default views.

The Database page link appears only for organizations that use sites. If your organization does not use sites, the link is hidden.

3. Who can access the report?

Access requires the report-data access permission. An administrator without that permission will see an access-restricted message instead of the report.

What you can see also depends on your site scope:

• A site-restricted administrator can only see the sites assigned to them. This limit is enforced and cannot be bypassed.
• An administrator with unrestricted database access can view all sites. If they are also assigned to specific sites, the report opens scoped to those sites by default, and they can switch to all sites.

The My sites and All sites control only appears for administrators who are allowed to view all sites. For a site-restricted administrator, this control is hidden and the report always reflects their assigned sites.

4. What are the two views?

You can switch between two views using the View toggle in the left filter panel.

Summary view shows one row per user-and-site relationship that has ever existed within your scope. Each row reflects the current state of that relationship and includes:

• First name
• Last name
• Site
• Status (Active or Removed)
• Date added
• Date removed

Activity log view shows the raw event stream within your scope, ordered newest first, and includes:

• First name
• Last name
• Site
• Event (Added or Removed)
• Date

The Activity log shows up to the most recent 2000 events for your current scope.

5. How is the status determined in the Summary view?

Status always reflects the most recent event for that user-and-site relationship:

• Active means the user's most recent event for that site is an Added event. The user is currently in that site.
• Removed means the user's most recent event for that site is a Removed event. The user is not currently in that site.

Because status is based on the latest event, a user who was added, removed, and then added again to the same site reads as Active. The earlier removal still appears in the Activity log.

6. What do the date columns mean?

• Date added shows the earliest date the user was added to that site within your scope.
• Date removed shows the date of the most recent removal when the current status is Removed. When the status is Active, this shows N/A.

7. How do the status and event indicators look?

Status and event values appear as colored chips. Active and Added appear as a green chip. Removed appears as a red chip.

8. How do I filter the report?

Filters appear in the left panel and apply to the rows currently loaded for the selected view and scope:

• Search: free-text search matching a user's first name, last name, full name, or site name.
• Status (Summary view): choose an operator (is or is not) and a value (All, Active, or Removed). When the value is All, no status filter is applied.
• Event (Activity log view): choose an operator (is or is not) and a value (All, Added, or Removed).
• Site: choose an operator (is or is not) and select one or more sites from the list.
• Date: choose an operator (on, before, after, or between) and one or two dates. In the Summary view this filters on Date added. In the Activity log view it filters on the event date.

When one or more filters are active, a Clear filters control appears showing the number of active filters and resets them all when selected.

9. Can I customize the columns and export the data?

Yes. Columns can be reordered and resized, and you can show or hide individual columns using Manage fields. A results count above the grid reflects the number of rows currently displayed after filtering. The Export action downloads the current data as a spreadsheet file named after the report title and the current date.

10. How does the report handle users in more than one site?

In the Summary view, each user-and-site relationship is its own row. A user who was removed from one site but is still active in another will appear as Removed for the first site and Active for the second.

11. What happens when a profile or site is later deleted?

Each recorded event stores a snapshot of the user, site, and organization information at the time of the event, so the history remains readable even if the user or site is deleted afterward.

12. Are administrator site assignments tracked here?

No. This history records only user-to-site membership changes. Changes to which sites an administrator is assigned to are not part of this report.

13. Good to know

• Removals are recorded whenever a user-to-site link is removed, including through actions such as un-siting a user or archiving a profile.
• If a user has no separate first or last name on record, the first name column falls back to the user's full name or username, and the last name column may be empty.
• The Summary view is sorted by Status by default. The Activity log view is sorted by date, newest first, by default.