Tuesday, June 13, 2017

Introducing CxdCallData for Skype for Business Online

Well folks this is my first post in a long time but it's a good one. I've been working on a PowerShell module to extract call data, rate my call (RMC) data, and a host of other great information retrievable from Skype for Business Online.

If you're new to PowerShell Gallery, get your read on here: https://blogs.msdn.microsoft.com/powershell/2014/11/19/introducing-powershell-gallery/. Otherwise, it's essentially a Git repository for publicly hosted scripts and modules all searchable from PowerShell 5.0. After writing this module a few times, collecting feedback, and dealing with version nightmares and co-development woes, I adopted a new working style and environment. More on that later on...

Finding the module

So here we go, to find the module you'll need PowerShell 5.0. To use the module you'll need the SkypeOnlineConnector.

PowerShell 5.0: http://www.microsoft.com/en-us/download/details.aspx?id=50395
SkypeOnlineConnector: https://www.microsoft.com/en-us/download/details.aspx?id=39366

Chances are you'll have to install a NuGet provider before you're able to find the module on PowerShell Gallery. No problem though, as you'll be prompted to install it automatically at first launch. Simply specify "Y" at the prompt to install the package provider.


Open an admin-mode PowerShell 5.0 session after installing the NuGet provider and type: "Find-Module CxdCallData". This will show you the current version(s) and the repository location.

Installing & importing the module

Run "Install-Module CxdCallData" and accept the untrusted repository message. Load the module by running "Import-Module CxdCallData".


To view the loaded module, run "Get-Module CxdCallData".

Using the module

There is only one exported function called "Get-CxdCallData". You can get full help and examples by using "Get-Help Get-CxdCallData" once the module has been installed and loaded.

Examples:


Get-CxdCallData -NumberOfDaysToSearch 180 -CsvFileWithUsers C:\users.csv -ReportSavePath C:\reports


Get-CxdCallData -NumberOfDaysToSearch 90 -ReportSavePath C:\reports -Verbose

The reports generated are in both CSV and HTML format for easy viewing on a server or desktop with Office installed.

Updating the module

PowerShell 5.0 lets you update a module from PowerShell Gallery simply by running "Update-Module CxdCallData".