Forum Discussion

Sahin Boluk's avatar
Sahin Boluk
Copper Contributor
Apr 27, 2020
Solved

Search for users that have MS Teams enabled in O365

Trying to run a quick Powershell to find users that are enabled or disabled for MS Teams with a E3 license.

 

I tried the below, but it is returning all users in my environment, enabled or disabled:

 

Get-MsolUser -All | Where-Object { $_.Licenses.ServiceStatus.ServicePlan.ServiceName -eq "TEAMS1" -and $_.Licenses.ServiceStatus.ProvisioningStatus -eq "Success" } | Select-Object UserPrincipalName, DisplayName | Export-Csv C:\Scripts\MSTeams\TEAMS1_04262020.csv

 

Am I missing something?

 

If I set a variable, $MSOLUser to one user, then run the below it shows the Servicenames and if I run the 2nd it returns the ProvisioningStatus (Success or Disabled).

 

$MSOLUser.Licenses.ServiceStatus.ServicePlan.ServiceName

 

$MSOLUser.Licenses.ServiceStatus.ProvisioningStatus

  • The logic in your where statement is flawed, use this instead:

     

    Get-MsolUser -All | ? {$_.Licenses.ServiceStatus | ? {$_.ServicePlan.ServiceName -eq "TEAMS1" -and $_.ProvisioningStatus -eq "Success"}}
  • The logic in your where statement is flawed, use this instead:

     

    Get-MsolUser -All | ? {$_.Licenses.ServiceStatus | ? {$_.ServicePlan.ServiceName -eq "TEAMS1" -and $_.ProvisioningStatus -eq "Success"}}

Resources