With the Enterprise version of Yammer as an admin you can export your network from a selected date up to current. The files that are exported contain the information within your network. This post is a quick run through the data model from the files. Where I can see examples of the data types in the csv I have detailed them.
Files that come from the export page:
Admins.csv
- Id > number
- Name > text
- Email > email
- Verified > TRUE/FALSE
Files.csv
- Id > number
- File_id > number
- Name > text
- Description > text
- Uploader_id > number
- Uploader_type > enum (User/
- Group_id > number
- Group_name > text
- Reverted_to_id > ?? Assume number
- Deleted_by_user_id > ?? Assume number
- In_private_group > TRUE/FALSE
- In_private_conversation > TRUE/FALSE
- File_api_url > URI
- Download_url > URI
- Path > file path
- Uploaded_at > date
- Deleted_at > date
Groups.csv
- Id > number
- Name > text
- Description > text
- Private > TRUE/FALSE
- Moderated > TRUE/FALSE
- Api_url > URI
- Created_by_id > number
- Created_by_type > enum (USER/)
- Created_at > date
- Updated_at > date
- Deleted > TRUE/FALSE
Messages.csv
- Id > number
- Replied_to_id > number
- Thread_id > number
- Conversation_id > ?? Assume number
- Group_id > number
- Group_name > text
- Participants > text
- In_private_group > TRUE/FALSE
- In_private_conversation > TRUE/FALSE
- Sender_id > number
- Sender_type > enum (USER/)
- Sender_name > text
- Sender_email > email
- Body > text
- Api_url > URI
- Attachments > text (opengraphobject:)
- Deleted_by_id > number
- Deleted_by_type > enum
- Created_at > date
- Deleted_at > date
Pages.csv
- Id > number
- Page_id > number
- Creator_user_id > number
- Published_by_user_id > number
- Collaborator_user_ids > number (something weird with this column)
- Name > text
- Group_id > number
- Group_name > text
- Reverted_to_id > number
- Deleted_by_id > number
- Deleted_by_type > Enum
- In_private_group > TRUE/FALSE
- Page_api_url > URI
- Download_url > URI
- Path > file path
- Published_at > date
- Deleted_at > date
Topics.csv
- Id > number
- Name > text
- Created_by > number
- Created_at > date
- Api_url >URI
Users.csv
- Id > number
- Name > text
- Email > email
- Job_title > text
- Location > text
- Department > text
- Api_url > URI
- Deleted_by_id > number
- Deleted_by_type > enum
- Joined_at > ?? Assume date
- Deleted_at > date
- Suspended_by_id > number
- Suspended_by_type > enum (USER)
- Suspended_at > date
- Guid > guid
- State > enum (soft_delete/active
