Overview

You would like to find out who made changes to a user's account. For example, you want to find out who changed their permissions, activated or deactivated their user account, made updates to their user profile information, or other details associated with their user account.

Information

Identifying the source of a user account change can be done differently according to the type of Jive community you are using. Please review the section that matches your community type:

• Jive On-Premise
• Jive Hosted
• Jive Cloud

Jive On-Premise

Please run the following query on your application database, replacing <User Name> with the name of the user who had their account changed:

SELECT to_timestamp(timestamp/1000) AS timestamp, b.firstname,b.lastname,
a.userid, a.description, a.details
FROM jiveauditlog a JOIN jiveuser b ON a.userid=b.userid
WHERE description iLIKE '%<User Name>%'
LIMIT 100

If you want to filter the results to only return permission changes, you can use this query instead, replacing <User Name> with the name of the user who had their permissions changed:

SELECT to_timestamp(timestamp/1000) AS timestamp, b.firstname,b.lastname,
a.userid, a.description, a.details
FROM jiveauditlog a JOIN jiveuser b ON a.userid=b.userid
WHERE description iLIKE '%<User Name>%permissions%'
LIMIT 100

Jive Hosted

If you have access to a copy of your application database (available through the Jive Cloud Admin tool), the queries listed in the Jive On-Premise section above can be used. Otherwise, please contact us.

Jive Cloud

Users with the Manage System or Manage Community permission levels can use the Analytics Export Tool to determine who made changes to a user's account by following these steps:

1. Click on your user avatar.
2. Click on Analytics Export.
3. Click on the button with the + icon, then search for DestinationActionObject.Name, and select it in the dropdown that appears:
   
4. In the popup that appears, type/paste in the user's name, then click on the + button:
   
5. Click on Apply.
6. Click on the ActivityTime filter, and expand the date range to match the date when you suspect the change occurred:
   
7. Click on Apply.
8. Click on the Preview button.
9. Click on Download User CSV.
10. Open the file in a spreadsheet editor.
11. This file will contain a list of all the actions that have been performed on the user account, sorted by date, in descending order.
12. The action column indicates the type of action that was taken on the account. For example:
    • ACTIVITY_APPLY_PERMISSION will appear will someone granted the user account more permissions.
    • ACTIVITY_REMOVE_PERMISSION will appear will someone revoked permissions from the user account.
    • ACTIVITY_UPDATE_USER will appear whenever changes are made to the user account.
13. The Actor columns will have all the related information regarding who made the change and when they made it. For example, Actor.Email will indicate the email address of the user account that made the change.
14. For more information on the fields that are in this file, review this documentation.

If it's still unclear who made the change to the user account, please contact us.