SOLVED

Yammer Group Cleanup

%3CLINGO-SUB%20id%3D%22lingo-sub-96183%22%20slang%3D%22en-US%22%3EYammer%20Group%20Cleanup%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-96183%22%20slang%3D%22en-US%22%3E%3CP%3EDoes%20anyone%20know%20how%20to%20get%20a%20list%20of%20Yammer%20groups%20that%20meet%20the%20following%20criteria%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1.%20All%20groups%20not%20used%20in%201%20year%3C%2FP%3E%3CP%3E2.%20All%20groups%20that%20have%20less%20than%2050%20posts%3C%2FP%3E%3CP%3E3.%20Group%20Admin(s)%20Info%20(email%2Fname)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20are%20trying%20to%20conduct%20a%20group%20cleanup%20of%20inactive%20groups%20but%20need%20a%20way%20to%20get%20this%20data.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%20in%20advance!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECC%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F3761%22%20target%3D%22_blank%22%3E%40Antoine%20Snow%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-96183%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EYammer%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-96679%22%20slang%3D%22en-US%22%3ERe%3A%20Yammer%20Group%20Cleanup%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-96679%22%20slang%3D%22en-US%22%3E%3CP%3EFWIW%20that%20%22number%20of%20posts%22%20is%20only%20the%20number%20of%20posts%20in%20the%20reporting%20period%20(e.g.%20180%20days)%2C%20not%20literally%20the%20number%20of%20posts%20in%20the%20group.%26nbsp%3B%20The%20total%20number%20of%20posts%20is%20available%20in%20the%20Network%20Admin%2Fdata%20export%2C%20however%20it%20is%20not%20user-friendly%20(this%20is%20where%20the%20kind%20folks%20at%20TyGraph%20may%20be%20helpful).%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-96455%22%20slang%3D%22en-US%22%3ERe%3A%20Yammer%20Group%20Cleanup%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-96455%22%20slang%3D%22en-US%22%3EHey%20Joseph%2C%20if%20you%20are%20interested%20in%20a%203rd%20party%20solution%20that%20has%20this%20very%20capability%2C%20please%20let%20me%20know.%20Happy%20to%20discuss%20further.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-96440%22%20slang%3D%22en-US%22%3ERe%3A%20Yammer%20Group%20Cleanup%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-96440%22%20slang%3D%22en-US%22%3E%3CP%3EYes!%20%26nbsp%3BThere%20is%20some%20new%20functionality%20available%20to%20help%20you%20with%20this.%20%26nbsp%3BFrom%20the%20O365%20Admin%20Center%20if%20you%20click%26nbsp%3B%3CSTRONG%3EReports%26nbsp%3B%3C%2FSTRONG%3E%26gt%3B%26nbsp%3B%3CSTRONG%3EUsage%3C%2FSTRONG%3E%2C%20you%20can%20now%20access%20some%20Yammer%20Group%20reporting%20options%20that%20previously%20were%20not%20available.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAt%20the%20top%20of%20that%20usage%20reports%20page%2C%20click%20on%26nbsp%3B%3CSTRONG%3ESelect%20a%20report%3C%2FSTRONG%3E%2C%20and%20then%20click%26nbsp%3Bon%26nbsp%3B%3CSTRONG%3EYammer%20Groups%20activity%3C%2FSTRONG%3E.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20will%20show%20you%20the%20number%20of%20posts%2C%20the%20admin%20info%2C%20and%20you%20can%20add%20other%20columns%20as%20well.%20%26nbsp%3BIt%20also%20allows%20you%20to%20export%20the%20report.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20646px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F18669iED0A9E244EB16399%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22YammerReports.png%22%20title%3D%22YammerReports.png%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EYammer%20Groups%20Report%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-96184%22%20slang%3D%22en-US%22%3ERe%3A%20Yammer%20Group%20Cleanup%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-96184%22%20slang%3D%22en-US%22%3E%3CP%3EI%20would%20add%20to%20this%20-%20a%20way%20to%20get%20Group%20Admin%20information%20in%20the%20same%20report.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Does anyone know how to get a list of Yammer groups that meet the following criteria? 

 

1. All groups not used in 1 year

2. All groups that have less than 50 posts

3. Group Admin(s) Info (email/name)

 

We are trying to conduct a group cleanup of inactive groups but need a way to get this data.

 

Thanks, in advance!

 

CC: @Antoine Snow

4 Replies

I would add to this - a way to get Group Admin information in the same report. 

Best Response confirmed by Joseph Reynoso (Occasional Contributor)
Solution

Yes!  There is some new functionality available to help you with this.  From the O365 Admin Center if you click Reports Usage, you can now access some Yammer Group reporting options that previously were not available. 

 

At the top of that usage reports page, click on Select a report, and then click on Yammer Groups activity.

 

This will show you the number of posts, the admin info, and you can add other columns as well.  It also allows you to export the report.

 

Yammer Groups ReportYammer Groups Report

Hey Joseph, if you are interested in a 3rd party solution that has this very capability, please let me know. Happy to discuss further.

FWIW that "number of posts" is only the number of posts in the reporting period (e.g. 180 days), not literally the number of posts in the group.  The total number of posts is available in the Network Admin/data export, however it is not user-friendly (this is where the kind folks at TyGraph may be helpful).