Microsoft Teams - New PowerBi Reporting version 3.0.4

Microsoft has released a new version of the Powerbi template called: Power BI Query Template For Teams Voice Applications (Auto Attendant and Call Queue) on November 18.

There have been some signifant errors fixed.

• Corrected an error on the Agent Timeline -> Average Call Duration (seconds) by Agent visual
  • Average Call Duration tooltip has been changed to Average instead of Sum
• Corrected a typo on the Auto Attendant -> Call Results legend
• Improved call classifications on Auto Attendant and Call Queue tabs
• Added legend for Auto Attendant -> Directory Search Method
• Visuals have been locked in position

You can download the latest template right here

This Power BI template provides three reports that allow organizations to report on the number of calls being processed by auto attendants and call queues. It also provides agent performance insights.

Cheatsheet - Nmap Network Scanner

Nmap is the world’s leading port security network scanner. The Nmap hosted security tool can help you determine how well your firewall and security configuration is working.

This guide will show you how to use Nmap to scan all open ports. This cheatsheet applies to Windows, MacOS and Linux

Click here to download the latest version of Nmap.

Create Azure SQL Server and Database

This how to will guide you true the steps of creating a simple Azure SQL server and database.

Microsoft 365 - Assign licenses with PowerShell to users

During the working week i get a lot of questions about assigning licenses (mostly the Microsoft Teams Phone Standard license) to users in bulk. This can be easily resolved with PowerShell.

First logon to MSOnline, if you don’t have this module installed use: Install-Module -name MSOnline

Connect-MsolService

Let’s see your active licenses

Get-MsolAccountSku

In order to assign a license to one of your users use the following cmdlet

Set-MsolUserLicense -UserPrincipalName user@contoso.com -AddLicenses tenant:mcoev

In this example we’ve assigned the Microsoft Teams Phone Standard license to the user.

Microsoft Teams - Direct Routing Root Certificates Update

On May 12, 2025, the current root certificate “Baltimore CyberTrust Root” expires. This certificate now handles the encryption of Microsoft Teams but also Azure Communication Services and even still the old Skype for Business Online components.

The transition to the new root certificates has started by Microsoft in January 2022 and will be completed this month, October 2022. In case you are using Direct Routing with your Microsoft 365 tenant you probaly have uploaded the Baltimore CyberTrust Root certificate in to your SBC.

Audiocodes - Block spam calls

More and more we hear customers complaining about spam likely calls, There is a way to block these calls based on your dialplan and an IP-2-IP route in the Audiocodes Mediant SBC.

DialPlan

If you are not using the DialPlan you will need to create one first, if you already use a DialPlan we can reuse it.

Navigate to Signalling & Media > SIP Definitions > DialPlan

Click on DialPlan Rule X items > Add a new DialPlan Rule > New

Microsoft Teams - Delegated Persmissions

For my job i’m working with a lot of customers that have been onboarded within in the Microsoft Cloud Solutions Provider program (CSP).

From this point of view it’s easy to manage multiple tenants securely without having to manage all kind of admin identities for each customer.

In the Microsoft Partner Center you can easily browse to a customer and go to service management menu to open the specific admin center.