Forum Discussion

PushpinderRavi's avatar
PushpinderRavi
Copper Contributor
Oct 10, 2019

Powershell command to get all users with specific service plan

Hi all,

 

I am looking for a powershell command to get list of all users with specific plan in Office 365.

 

E.g. I need to get all users with Teams enabled in Office 365. I tried the following command and it didn't return anything.

Get-MsolUser -All | Where-Object {($_.licenses).AccountSkuId.ServicePlan -match "Teams1"} | select DisplayName, UserPrincipalName

 

I can run following command to find users with specific license, e.g. users with Office 365 E3 license, however still no success with specific plans inside E3 license

 

Get-MsolUser -All | Where-Object {($_.licenses).AccountSkuId -match "ENTERPRISEPACK"} | select DisplayName, UserPrincipalName

 

Any help, will be greatly appreciated.

 

Thanks in Advance.

office 365
powershell
  • VasilMichev's avatar
    VasilMichev
    Oct 11, 2019

    And by looking did you mean actually performing a search, as I've answered this question dozen times already? 🙂

     

    Here's how to do it via the MSOnline cmdlets:

     

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

  • VasilMichev's avatar
    VasilMichev
    MVP
    Oct 11, 2019

    And by looking did you mean actually performing a search, as I've answered this question dozen times already? 🙂

     

    Here's how to do it via the MSOnline cmdlets:

     

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

    • PushpinderRavi's avatar
      PushpinderRavi
      Copper Contributor
      Oct 15, 2019
      Thanks for your reply, Vasil. I swear, I did find your old posts and executed the same command before, however, it didn't work. However, you may have heard this excuse in the past, so this time this command worked.

      Thanks again

Resources