Interpreting a Yammer User Export

By Alex Blaine + David Schmitt

Admins can use this document to assist with looking up data on your users, as well as being able to perform an audit of the users who are members of your network. Additionally, admins can perform user maintenance based off the current state of your users based on this data.

Performing the Export

Yammer Network Admins have the ability to export user information for their network. To export the data use the Export Users feature. (Settings > Network Admin > Export Users). There are two options available for the User Export:

  • Export All Users: This will export every user on the Yammer Network
  • Export All users since – to specify a date range


Contents of the Export

User Export will export the data into a zip file containing a CSV file and txt files. There will be five files within the User export Folder:

  • Admins.csv: Contains a list of all Network and Verified admins.

  • Networks.csv: Contains data pertaining to your network.

  • Users.csv: Contains a list of all users on the network within the specified time period.

  • log.txt: Contains a summary of the number of users who were exported.

  • request.txt: Contains a summary of the parameters that were used for the data export.

 

Interpreting the Export


Users CSV

Export Field Explanation
id User ID
name Users Display Name
email Users E-Mail Address
job_title Users Job Title
location Users Location
department Users Department
api_url The URL used to obtain user metadata (More information)
deleted_by_id If user was deleted by another user, the ID of the user who performed the deletion
deleted_by_type Describes the method by which the user was deleted
joined_at The date the user first logged into Yammer (In an External Network export, this indicates the date the user joined the network)
deleted_at Date users account was deleted
suspended_by_id The ID of the user who suspended an account
suspended_by_type The method used to suspend a user
suspended_at The date a user was suspended
guid A unique ID generated by your Active Directory for each user. In Yammer, we receive that GUID followinga successful synchronization
state The current state of the user (active or soft_delete)


NOTE:

A user who is in a soft_delete state indicates the user is either:

  • Pending if there are no joined_at, suspended_at, or deleted_at values
  • Suspended if the user has a suspended_at value and not a deleted_at value
  • Deleted if the user has a deleted_at value.

Guest users can be identified in the user export by reviewing the email address field. Guests would be any user whose email address does not match the domains that have been added to your network. You can identify the domains currently merged into your network by navigating to the Network Migration page under Network Admin. See https://aka.ms/YamNetMig for additional details on this.
 

Admins.csv

Description of fields:
Export Field Explanation
id User ID
name Users display name
email Users email address
verified Indicates if user is a Verified Admin


Networks.csv

Description of fields:
Export Field Explanation
id Networks ID
permalink Networks permalink
name Networks Name
url Networks URL
paid If a network is paid free
created_at The date the network was created at
moderated If the network is moderated
usage_policy If the network has a usage policy implimented
number_of_users Number of users on the network
secure_browser_token If the network has an authentication token


About the authors

David Schmitt is a Support Engineer and Alex Blaine is a Support Escalation Engineer and code monkey on the Yammer Support Escalation team..

Export