Measure Lync Online Adoption with PowerShell

Hello,

Recently I deployed Office 365 at customers, one of them wanted to measure Lync Online adoption and utilization. You can see that through your tenant webpage, in Administration, Report, Lync, Active Users.

Or, you can use PowerShell !

#Lync Online Connection
$Cred = Get-Credential
$Session = New-CsOnlineSession -Credential $Cred
Import-PSSession $Session

#Stats
#Weekly
Invoke-WebRequest 'https://reports.office365.com/ecp/reportingwebservice/reporting.svc/CsActiveUserWeekly?$select=Date,ActiveUsers&$format=Json' -Credential $cred | select -ExpandProperty content | ConvertFrom-Json | select -ExpandProperty d | select -ExpandProperty results
#Monthly
Invoke-WebRequest 'https://reports.office365.com/ecp/reportingwebservice/reporting.svc/CsActiveUserMonthly?$select=Date,ActiveUsers&$format=Json' -Credential $cred | select -ExpandProperty content | ConvertFrom-Json | select -ExpandProperty d | select -ExpandProperty results
#Daily
Invoke-WebRequest 'https://reports.office365.com/ecp/reportingwebservice/reporting.svc/CsActiveUserDaily?$select=Date,ActiveUsers&$format=Json' -Credential $cred | select -ExpandProperty content | ConvertFrom-Json | select -ExpandProperty d | select -ExpandProperty results

This will you export statistics in a list of objects. Thanks to those informations, you can tell the customer if his users are using Lync Online.

Leave a Reply