Microsoft Teams: Use PowerShell to Check for Unused Teams Based on Chat Activity from Administrator Perspective


This below script shows Teams statistics from an Administrator’s point of view using Exchange Online PowerShell.

Log In to Exchange Online with PowerShell

$UserCredential = Get-Credential
$Session = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri -Credential $UserCredential -Authentication  Basic -AllowRedirection
Import-PSSession $Session

Put Exchange Groups with Microsoft Teams “Team Chat” Folders into an Object

The below PowerShell will look for all the “UnifiedGroups” that have a Microsoft Teams chat folder in them (effectively groups that are Microsoft Teams Groups) and put them into an object. Note: This PowerShell will take a while to run, even on a small Office 365 tenant.

$TeamsStats = Get-UnifiedGroup | Get-MailboxFolderStatistics  | ? {$_.Name -eq “Team Chat”}

Now you can see which teams are new and active to run clean up procedures you want. Below are some examples:

Get Teams With No Chat Activity for Last 90 Days

$TeamsStats | ? {$_.LastModifiedTime -lt (get-date).AddDays(-90)} | Format-Table Identity, Name, ItemsInFolder, LastModified*, creationtime

Get Teams Created in the Last 30 Days

$TeamsStats | ? {$_.CreationTime -gt (get-date).AddDays(-30)} | Format-Table Identity, Name, ItemsInFolder, LastModified*, CreationTime

Obviously you can do your other creative checks and tests as well and trigger automatic or manual actions on specific teams now, armed with this information.

Tony Redmond PowerShell for Inspiration

Find Teams Enabled o365 Groups

Microsoft Teams User Tip #23: Quickly Get Microsoft Teams Ring & Version (Works with App or Browser)

How to determine Microsoft Teams Ring you are on (from Browser or Teams App):

  1. Press Ctrl + Alt + Shift + 1
  2. Open the “MSTeam Diagnostics Log…” file that is created.
    1. On Browser it will be easy to open directly from Browser
    2. On MS Teams App open from “%userprofile%\Downloads\MSTeams Diagnostics Log*” (On Win10 click Start & just type %userprofile%\Downloads)
  3. Look at section of file near the top that looks like this: "ring": {     "id": "ring4"
    1. 4
    2. 3 (TAP)
    3. 1.5 (IT)

That’s all.

To see more Microsoft Teams User Tips:

.[Video] Learn Microsoft Teams in 5 Minutes:

AT&T TL86103 USB Desk Phone + DECT Handset Almost “Compatible with Lync” (& Skype for Business/Office 365 Phone System) Review: Almost Interesting!


NOTE: This device is NOT Skype for Business Certified

I was perusing simple multiline AT&T desk phones at my local Staples when I noticed a phone with this sticker on it: “AT&T Softphone Call Manager—Compatible with Microsoft Lync”. What?!


I decided to just take it along home and investigate how this phone interfaces with Skype for Business & Office 365 Phone System, not the least because we have common scenario in Office 365 Phone System implementations in small offices who just need one simple, good ole, DECT portable phone.

I quickly discovered that this phone is designed to act as a USB phone for Lync (explicitly for Lync in the documentation, but because of the shared desktop API, by extension it seems to work with Skype for Business and Office 365 Phone System! Note: This devices is NOT Skype for Business Certified!)

Video Review


How to Setup

Setup involves a few simple steps:

  1. Download and install the AT&T Softphone Call Manager (very simple)
  2. Plug the provided USB cable from the desk phone into your PC running Skype for Business client & signed into a local Skype for Business Server or Office 365 Phone System
  3. Select AT&T TL86103 as the audio device in Skype for Business
  4. Start receiving calls. (or making calls…from the Skype for Business client. see below)

How to Use with Skype for Business

To answer a call: An incoming call on Skype for Business will ring the desk phone and DECT handset and you can answer by picking up the handset.

To make a call: According to manuals you should be able to dial on the handsets and press the “PC Call” soft button, but in my test this fails after a few seconds. So you seem to need to make calls from the Skype for Business client, which works fine in my tests.


  1. DECT phone that (kind of…see below) works with Skype for Business & Office 365 Phone System
  2. Traditional desk phone and portable phone user experience
  3. 1 button hold and pickup between TL86103 desk phone and portable phones.
  4. Send DTMF to a call using the desk phone or portable phone keypad
  5. The PTT (which works entirely outside any Skype for Business infrastructure) is kind of nice


  1. Seem to need to initiate calls from Skype for Business/Lync client. (If you try to initiate a call from the desk phone or portable phone, the call will be initiated from the Skype for Business client, but after a few seconds you will get the error message “Unable to Call. Try Again.”)
    1. Work around: call out using Skype for Business client.
  2. 1 call handling only. (Users will hear the “beep beep” of the 2nd incoming call, but there is no way to answer the 2nd call from the handsets)
    1. Work around: Using Skype for Business client to answer and handle 2nd call.
  3. 3 digit extension dialing seems not to be supported. (4 digit and longer seems to work)
  4. Need to use Skype for Business client to transfer calls.
  5. Sometimes incoming calls take a bit to start ringing on the TL86103
  6. AT&T support is limited to “reinstall the software” & return the device.


I’ve often wonder why vendors don’t do exactly what AT&T (aka VTech aka Advanced American Telephone) has attempted to do with this phone. Yes, some Chinese vendors have made half hearted attempts with very mediocre USB hardware, but why not traditional phone hardware with a USB connection to a PC?

My thought in written this article is mainly to save others the time of testing how (& if)  it works. I think needing to use Skype for Business client to dial out will be a show stopper for many scenarios. (but not all) A secondary reason is: if someone has found a fix for the issue of it not correctly dialing out, please comment.

But for this one, but significant issue, it could solve a common challenge for small business wanting to implement Office 365 Phone System.


Download AT&T Softphone Call Manager:

Install Guide AT&T Softphone Call Manager for TL8603:

Amazon AT&T TL86103;

Microsoft Teams User Tip #22: Quickly Create a Folder & Copy Files to It from Multiple Mobile Devices

The Challenge

What should be easier than creating a folder in a Team and copying multiple files to it from various Mobile devices? At the moment this is stymied by several Microsoft Teams limitations:

  • Users cannot copy a file directly from a mobile device to a specific Teams Folder using the Teams mobile app
  • Users cannot select several files at once to upload to a conversation. User need to select each file, then wait (a considerable time till it uploads for a typical Android photo file), then select the next. No user will do this…

So how can users achieve this?

This process will essentially require a desktop Teams client to get started, then mobile users can contribute.

1 - Create a file folder in a team using Microsoft Teams on a PC.

2 - Now open this folder using Sharepoint (Open in Sharepoint) to get the Sharepoint URL.


3 - Next, copy the Sharepoint URL into a Conversation in this team labeled something like “Link to efficiently upload file to this folder”

4 – Now on Mobiles and PC’s users can click on the Sharepoint URL and efficiently send multiple files to this Teams folder.

5 – On the mobile devices click on the Sharepoint URL | “…” | Upload | Files | and now select the multiple files to be uploaded…

To see more Microsoft Teams User Tips:

.[Video] Learn Microsoft Teams in 5 Minutes:

Enterprise Connect 2018 Microsoft Teams and Skype for Business Observations

Microsoft started EC18 with a bunch of announcements, demonstrating the rapid  (even dizzying) pace of development of their Microsoft Teams product. Some of the big items include:

Read more details here:

Microsoft Teams Phone Application (Vendors Audiocdoes & Yealink)

Both Yealink and AudioCodes have prelease demonstration models of Microsoft Teams native desk phones running Microsoft developed android app.

I’ve done a blog listing some of the items we know about these new devices along with a quick first look video here:

SRS (Skype Room System/ to eventually be Teams Room System) Continue to Proliferate (Vendors Lenovo & HP)

To demonstrate how big Lenovo is betting on their new SRS, they have a complete booth dedicated to their SRS device.

Room Phones by Various Vendors

Polycom Trio, Yealink CP960 and Crestron Mercury. See Tom’s article:

Busy Light Vendors Continue to Innovate (Embrava)

Embrava brings a presence light that includes a name display for dynamics office spaces.

Landis Technologies is Showing Contact Center for Microsoft Teams

Our team is announcement and showing an Office 365 (Microsoft Teams, Skype for Business Online & Skype for Business Server) Contact Center at Booth 744.