Reporting on Skype for Enterprise Messaging Exercise utilizing the Dialog Historical past Folder in Trade

Reporting on Skype for Enterprise Messaging Exercise utilizing the Dialog Historical past Folder in Trade Skype for Enterprise (and formally Lync earlier than that) makes use of the Dialog Historical past folder in an Trade mailbox to retailer the historical past of your IM conversations. One message in your mailbox might characterize many messages in an IM dialog the place the dialog is damaged out itself into an XML string within the Message within the “ConversationXml.{CA2F170A-A22B-4f0a-B899-93439DEC3FBC}” prolonged property which appears one thing a little bit bit like this when you dumped its values

Which comes from the beneath underlying MAPI property

Whereas Instantaneous Messaging hasn’t been round so long as E-mail the statistics and Reporting on its utilization even from third get together distributors is fairly underwhelming as the info made accessible for reporting is proscribed. If nonetheless we make the most of a Mailbox API like EWS or the Graph API and delve into the above data you can begin to supply some extra helpful statistical reporting about your IM site visitors. This may very well be particularly helpful in the meanwhile if you wish to begin measuring extra precisely the engagement throughout Skype vs Groups (with reference to IM anyway). I’ve created an EWS script for doing this that firstly enumerates all of the dialog historical past gadgets for a specific time-frame, then will get the above dialog XML for every dialog thread (this requires a second request to Trade due to the dimensions of the property). Then it parses the XML right into a logentry that can be utilized both itself or summarized for additional reporting. I’ve three pattern abstract reviews that does this within the script eg

Report by date

Report by IM’s acquired From

 Report by IM’s Despatched To

Otherwise you simply have the log stream which you’ll be able to crunch additional in one thing like excel

I’ve put the code for this script up on GitHub right here https://github.com/gscales/Powershell-Scripts/blob/grasp/SkypeConversationStats.ps1

The script will work within the cloud or OnPrem, in case you are utilizing it onprem be sure to utilizing the -basicAuth swap within the cmdlet because the authentication defaults to utilizing oAuth in Azure. A number of examples of working the script

If the sip tackle your reporting is completely different from the mailbox SMTP (different then the sip prefix) you’ll want to use the -sipaddress parameter to specify this tackle. That is used within the Sender calculations simply cross this in minus the sip: prefix.  

To Get the final 30 days of dialog logs from a Mailbox within the cloud use

Get-ConversationLog -MailboxName gscales@datarumble.com -Days 30

for OnPrem use

Get-ConversationLog -MailboxName gscales@datarumble.com -Days 30 -basicAuth
To make use of the Reporting choices for report by date (see screenshot 1)
Get-ConversationLog -MailboxName gscales@datarumble.com -Days 30 -reportbyDate 
-htmlReport | Out-file c:temp30dayreport.html

if you would like the identical report in csv use

Get-ConversationLog -MailboxName gscales@datarumble.com -Days 30
 -reportbyDate | ConvertTo-Csv -NoTypeInformation -path c:temp30dayreport.csv


Get-ConversationLog -MailboxName gscales@datarumble.com -Days 30
 -reportFrom

To report the highest senders that despatched this Mailbox an IM


Get-ConversationLog -MailboxName gscales@datarumble.com -Days 30
 -reportFrom

To report the highest recipients of IM’s


Get-ConversationLog -MailboxName gscales@datarumble.com -Days 30
 -reportTo

Rent me – If you want to do one thing much like this or anything you see on my weblog I am at present accessible to assist with any Workplace365,Microsoft Groups, Trade or Energetic Listing associated improvement work or scripting, please contact me at gscales@msgdevelop.com(nothing too huge or small).

Leave a Reply