This article explains how to generate an audit report for users who were added to or removed from groups within a specific timeframe.
- System Log
- Reports
- Navigate to the Okta Admin Console.
- Go to Reports > System Logs.
- Set the time frame (and timezone) required to search.:
- In the search field, use one of the following System Log queries:
eventType eq "group.user_membership.add"- For users who were added to a group.eventType eq "group.user_membership.remove"- For users who were removed from a group.
- To generate a report containing both group membership additions and removals, chain the 2 queries with an or operator between them:
- To generate a report containing group membership additions and removals for a specific group, determine the group's ID:
- While in the System Log, click the name of the group, which will copy the group ID to the search field in the format target.id
eq "<GROUP_ID>". - Navigate to Directory > Groups > Search and select the group from the list. Once on the group's Okta page, the groupId will be visible in the browser's URL field.
- While in the System Log, click the name of the group, which will copy the group ID to the search field in the format target.id
- The final search query should be like the following:
- Export the logs by clicking the Download CSV button, and manipulate the file to suit the organization's operational needs.
