Yammer Analytics and Powershell

%3CLINGO-SUB%20id%3D%22lingo-sub-2143%22%20slang%3D%22en-US%22%3EYammer%20Analytics%20and%20Powershell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2143%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20to%20provide%20Yammer%20usage%20data%20to%20our%20internal%20communications%20department%20on%20a%20regular%20basis.%26nbsp%3B%20I'd%20like%20to%20user%20PowerShell%20to%20grab%20the%20info.%26nbsp%3B%20Is%20there%20a%20Yammer%20snappin%20for%20PowerShell%3F%26nbsp%3B%20Does%20anyone%20have%20some%20suggestions%20for%20resources%20out%20there%3F%20%23powershell%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2143%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EYammer%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2175%22%20slang%3D%22en-US%22%3ERe%3A%20Yammer%20Analytics%20and%20Powershell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2175%22%20slang%3D%22en-US%22%3EHi%20Heather%20-%20if%20you%20are%20an%20Admin%2C%20you%20can%20use%20the%20simple%20Dashboard%20within%20the%20Network%20Admin%20settings%2C%20or%20export%20all%20data%20(probably%20untick%20the%20include%20attachments)%20and%20load%20the%20various%20CSV%20files%20you%20get%20into%20an%20Excel%20Tool%20-%20such%20as%20PowerPivot%20or%20PowerBI.%20You'll%20need%20to%20do%20a%20bit%20of%20manual%20work%20here.%3CBR%20%2F%3E%3CBR%20%2F%3EThere%20are%20also%20some%20great%203rd%20party%20tools%20to%20do%20this%20for%20you%20if%20you%20have%20budget..%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2177%22%20slang%3D%22en-US%22%3ERe%3A%20Yammer%20Analytics%20and%20Powershell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2177%22%20slang%3D%22en-US%22%3E%3CP%3EOn%20the%20existing%20Yammer%20IT%20Pro%20Network%20a%20pre-built%20excel%20power%20view%20tool%20exists%20here%20-%20%3CA%20href%3D%22https%3A%2F%2Fwww.yammer.com%2Fitpronetwork%2F%23%2Ffiles%2F31278603%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.yammer.com%2Fitpronetwork%2F%23%2Ffiles%2F31278603%3C%2FA%3Ethat%20you%20can%20make%20use%20of%20for%20some%20reporting%20if%20it%20helps.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2201%22%20slang%3D%22en-US%22%3ERe%3A%20Yammer%20Analytics%20and%20Powershell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2201%22%20slang%3D%22en-US%22%3E%3CP%3EHere%20is%20the%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FYammer%2FYammer-Analytics-and-Powershell%2Fm-p%2F2201%3Fattachment-id%3D93%23M156%22%20target%3D%22_self%22%3Eattached%20excel%20document%3C%2FA%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F2983%22%20target%3D%22_blank%22%3E%40Rich%20Burdes%3C%2FA%3E%26nbsp%3Bis%20referring%20to.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2328%22%20slang%3D%22en-US%22%3ERe%3A%20Yammer%20Analytics%20and%20Powershell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2328%22%20slang%3D%22en-US%22%3EDo%20you%20have%20to%20resort%20to%20PowerShell%3F%3CBR%20%2F%3E%3CBR%20%2F%3EOne%20option%20is%20to%20give%20them%20an%20admin%20roll%20in%20the%20Office%20365%20Admin%20Centre%20so%20they%20can%20see%20the%20Yammer%20Reports%20though%20I%20do%20not%20think%20the%20reports%20will%20quench%20their%20thirst%20for%20information.%20You%20may%20not%20be%20able%20to%20grab%20the%20underlying%20report%20information%20by%20PowerShell%20as%20Yammer%20is%20not%20listed%20%3CA%20href%3D%22https%3A%2F%2Ftechnet.microsoft.com%2Fen-gb%2Flibrary%2Fdn683774.aspx%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Ftechnet.microsoft.com%2Fen-gb%2Flibrary%2Fdn683774.aspx%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3ELater%20this%20summer%20(crosses%20fingers)%20PowerBI%20Content%20Packs%20will%20be%20released%20and%20that%20may%20help%20with%20the%20data%20mash-up.%3CBR%20%2F%3E%3CBR%20%2F%3EYou%20can%20go%20with%20a%20third%20party%20app%20provider%20like%20TyGraph%20(%20%3CA%20href%3D%22http%3A%2F%2Ftygraph.com%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttp%3A%2F%2Ftygraph.com%2F%3C%2FA%3E%20)%20or%20SWOOP%20(%20%3CA%20href%3D%22http%3A%2F%2Fwww.swoopanalytics.com%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttp%3A%2F%2Fwww.swoopanalytics.com%2F%3C%2FA%3E%20)%20.%20%7Bother%20products%20do%20exist%20-%20these%20are%20the%20two%20that%20I%20am%20familiar%20with%7D%20Both%20are%20excellent%20products%20and%20provide%20customisable%20insight%20that%20can%20be%20tailored%20exactly%20to%20your%20needs.%3CBR%20%2F%3E%3CBR%20%2F%3EIf%20you%20want%20to%20build%20from%20the%20ground%20up%20then%20you'll%20be%20effectively%20replicating%20what%20the%20likes%20of%20TyGraph%20do.%20You'll%20need%20to%20leverage%20the%20Yammer%20API%20(%20%3CA%20href%3D%22https%3A%2F%2Fdeveloper.yammer.com%2Fdocs%2Frest-api-rate-limits%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdeveloper.yammer.com%2Fdocs%2Frest-api-rate-limits%3C%2FA%3E%20e.g.%20messages.json%20)%20and%20poll%20it%20on%20a%20regular%20basis%20to%20build%20up%20your%20dataset.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3207%22%20slang%3D%22en-US%22%3ERe%3A%20Yammer%20Analytics%20and%20Powershell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3207%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F82%22%20target%3D%22_blank%22%3E%40Simon%20Denton%3C%2FA%3E%26nbsp%3Band%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F2937%22%20target%3D%22_blank%22%3E%40Heather%20Betzhold%3C%2FA%3E.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESpot%20on%20re%20referencing%20the%20Yammer%20API.%20Happy%20to%20give%20you%20a%20demo%20of%20SWOOP%20if%20relevant.%20Just%20send%20me%20a%20message.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%2C%26nbsp%3B%3C%2FP%3E%3CP%3ECai%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-4314%22%20slang%3D%22en-US%22%3ERe%3A%20Yammer%20Analytics%20and%20Powershell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-4314%22%20slang%3D%22en-US%22%3E%3CP%3EJust%20a%20side%20note.%20The%20others%20might%20be%20better%20long%20term%20solutions%20but%20if%20you%20do%20need%20to%20interact%20with%20it%20via%20PowerShell%20or%20are%20a%20PowerShell%20nerd%20like%20myself%20this%20is%20a%20really%20great%20blog%20series%20on%20interacting%20with%20Yammer%20via%20PowerShell%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fblog.kloud.com.au%2F2015%2F06%2F26%2Fprogrammatically-interacting-with-yammer-via-powershell-part-1%2F%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fblog.kloud.com.au%2F2015%2F06%2F26%2Fprogrammatically-interacting-with-yammer-via-powershell-part-1%2F%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I need to provide Yammer usage data to our internal communications department on a regular basis.  I'd like to user PowerShell to grab the info.  Is there a Yammer snappin for PowerShell?  Does anyone have some suggestions for resources out there? #powershell

6 Replies
Hi Heather - if you are an Admin, you can use the simple Dashboard within the Network Admin settings, or export all data (probably untick the include attachments) and load the various CSV files you get into an Excel Tool - such as PowerPivot or PowerBI. You'll need to do a bit of manual work here.

There are also some great 3rd party tools to do this for you if you have budget..

On the existing Yammer IT Pro Network a pre-built excel power view tool exists here - https://www.yammer.com/itpronetwork/#/files/31278603 that you can make use of for some reporting if it helps.

Here is the attached excel document @Rich Burdes is referring to. 

Do you have to resort to PowerShell?

One option is to give them an admin roll in the Office 365 Admin Centre so they can see the Yammer Reports though I do not think the reports will quench their thirst for information. You may not be able to grab the underlying report information by PowerShell as Yammer is not listed https://technet.microsoft.com/en-gb/library/dn683774.aspx

Later this summer (crosses fingers) PowerBI Content Packs will be released and that may help with the data mash-up.

You can go with a third party app provider like TyGraph ( http://tygraph.com/ ) or SWOOP ( http://www.swoopanalytics.com/ ) . {other products do exist - these are the two that I am familiar with} Both are excellent products and provide customisable insight that can be tailored exactly to your needs.

If you want to build from the ground up then you'll be effectively replicating what the likes of TyGraph do. You'll need to leverage the Yammer API ( https://developer.yammer.com/docs/rest-api-rate-limits e.g. messages.json ) and poll it on a regular basis to build up your dataset.

Hi @Simon Denton and @Heather Betzhold.

 

Spot on re referencing the Yammer API. Happy to give you a demo of SWOOP if relevant. Just send me a message.

 

Cheers, 

Cai

Just a side note. The others might be better long term solutions but if you do need to interact with it via PowerShell or are a PowerShell nerd like myself this is a really great blog series on interacting with Yammer via PowerShell:

 

https://blog.kloud.com.au/2015/06/26/programmatically-interacting-with-yammer-via-powershell-part-1/