How to export Skype for Business conversation history into text or excel format?

%3CLINGO-SUB%20id%3D%22lingo-sub-44076%22%20slang%3D%22en-US%22%3EHow%20to%20export%20Skype%20for%20Business%20conversation%20history%20into%20text%20or%20excel%20format%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-44076%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20All%2C%3C%2FP%3E%3CP%3EAs%20I%20know%2C%20the%20conversation%20history%20for%20Skype%20for%20Business%20is%20only%20saved%20in%20user's%20mailbox%20folder.%20May%20I%20know%20if%20there%20is%20any%20way%20which%20could%20export%20the%20conversation%20history%20into%20some%20analytics%20platform%2C%20like%20text%20or%20excel%3F%20Thanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-44076%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESkype%20Operations%20Framework%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-44083%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20export%20Skype%20for%20Business%20conversation%20history%20into%20text%20or%20excel%20format%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-44083%22%20slang%3D%22en-US%22%3E%3CP%3EYou%20can%20open%20the%20PST%20file%20in%20Outlook%20and%20start%20a%20CSV%20export.%20I've%20seen%20on%20google%20that%20there%20are%20some%203rd%20Party%20tools%20to%20convert%20PST%20into%20CSV's.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%2FAndy%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-44082%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20export%20Skype%20for%20Business%20conversation%20history%20into%20text%20or%20excel%20format%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-44082%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Andy%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20your%20info.%20Our%20infra%20is%20in%20online.%20So%20the%20best%20we%20could%20export%20is%20pst%20file%3F%20Will%20there%20be%20any%20text%20format%3F%20As%20we%20would%20like%20to%20do%20the%20analytsis%20based%20on%20the%20conversation%20history%2C%20I%20have%20no%20idea%20how%20to%20do%20the%20analytsis%20based%20on%20a%20pst%20file%20so%20far.%20Thanks!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20Regards%3C%2FP%3E%3CP%3EEriol%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-44079%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20export%20Skype%20for%20Business%20conversation%20history%20into%20text%20or%20excel%20format%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-44079%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Eriol%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20depends%20where%20your%20SfB%20infrastructure%20is%20located.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EOnline%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3ETo%20archive%20your%20IM's%20you%20can%20use%20the%20Exchange%20Online%20or%20Exchange%20On-Prem.%20There%20is%20an%20Exchange%20Cmdlet%20(%3CA%20href%3D%22https%3A%2F%2Ftechnet.microsoft.com%2Fen-us%2Flibrary%2Fff607299(v%3Dexchg.160).aspx%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3ENew-MailboxExportRequest%3C%2FA%3E)%20to%20export%20the%20conversation%20folder%20into%20a%20PST%20file.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EOn-Premise%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3EArchive%20and%20export%20from%20your%20Exchange%20Server%20or%20use%20the%20SQL%20archiving%20features.%20Microsoft%20delivers%20an%20SfB%20Cmdlet%20(%3CA%20href%3D%22https%3A%2F%2Ftechnet.microsoft.com%2Fen-us%2Flibrary%2Fdn951378.aspx%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EExport-CsArchivingData%3C%2FA%3E)%20to%20export%20the%20archived%20SQL%20data%20into%20EML%20files.%20You%20can%20also%20build%20your%20own%20script%20to%20get%20this%20data%20directly%20from%20the%20database.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%20Andy%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hello All,

As I know, the conversation history for Skype for Business is only saved in user's mailbox folder. May I know if there is any way which could export the conversation history into some analytics platform, like text or excel? Thanks!

3 Replies

Hi Eriol

 

It depends where your SfB infrastructure is located.

 

Online

To archive your IM's you can use the Exchange Online or Exchange On-Prem. There is an Exchange Cmdlet (New-MailboxExportRequest) to export the conversation folder into a PST file. 

 

On-Premise

Archive and export from your Exchange Server or use the SQL archiving features. Microsoft delivers an SfB Cmdlet (Export-CsArchivingData) to export the archived SQL data into EML files. You can also build your own script to get this data directly from the database. 

 

Cheers Andy

 

 

Hi Andy,

 

Thanks for your info. Our infra is in online. So the best we could export is pst file? Will there be any text format? As we would like to do the analytsis based on the conversation history, I have no idea how to do the analytsis based on a pst file so far. Thanks!

 

Best Regards

Eriol

You can open the PST file in Outlook and start a CSV export. I've seen on google that there are some 3rd Party tools to convert PST into CSV's. 

 

/Andy