<div>
There is no server-side to filter them out quickly, you need to get the full user list and filter it client-side. Which in turn means you can simply get the full list, export it to CSV and do the filtering in Excel. Anyway, this will return all the users with specific license:<br />
<br />

<pre><code id="code-20-42931781-1">Get-MsolUser -All | ? {$_.Licenses.AccountSkuId -eq &quot;tenant:ENTERPRISEPREMIUM&quot;}</code></pre>
<br />
Rinse and repeat for the other SKUs.
</div>


There is no server-side to filter them out quickly, you need to get the full user list and filter it client-side. Which in turn means you can simply get the full list, export it to CSV and do the filtering in Excel. Anyway, this will return all the users with specific license:



Get-MsolUser -All | ? {$_.Licenses.AccountSkuId -eq "tenant:ENTERPRISEPREMIUM"}


Rinse and repeat for the other SKUs.

<div>
@vasil,<br />
<br />
Thanks, But I would require a command that can give me an output for all 3 license packs at once
</div>


@vasil,

Thanks, But I would require a command that can give me an output for all 3 license packs at once

Sr. Tech Specialist

Mahesh babu

<div>
Not sure this is what you want but connect to O365 with powershell and run<br />
get-msoluser -all | select Displayname,Licenses <br />
You can pipe it to a text file<br />
<br />
You will need to know the SKU that belongs to each level you are looking for. (no easy fix there. Look here <br />
<br />
<a href="https://docs.microsoft.com/en-us/azure/active-directory/users-groups-roles/licensing-service-plan-reference" rel="ugc">https://docs.microsoft.com/en-us/azure/active-directory/users-groups-roles/licensing-service-plan-reference</a><br />
<br />
You can see how many are assigned by just running get-msolaccountsku
</div>


Not sure this is what you want but connect to O365 with powershell and run
get-msoluser -all | select Displayname,Licenses
You can pipe it to a text file

You will need to know the SKU that belongs to each level you are looking for. (no easy fix there. Look here

https://docs.microsoft.com/en-us/azure/active-directory/users-groups-roles/licensing-service-plan-reference [https://docs.microsoft.com/en-us/azure/active-directory/users-groups-roles/licensing-service-plan-reference]

You can see how many are assigned by just running get-msolaccountsku

<div>
<div class="content wysiwyg-content">
All,<br />
<br />
Need help with. Powershell command<br />
<br />
I need to get the output of list of o365 users in our tenant that has e1, E3 and F1 licenses.<br />
<br />
Thank you
</div>
</div>


All,

Need help with. Powershell command

I need to get the output of list of o365 users in our tenant that has e1, E3 and F1 licenses.

Thank you

Powershell command for list of e1, E3, F1 users

Windows PowerShell is a task automation and configuration management framework from Microsoft, consisting of a command-line shell and associated scripting language built on the .NET Framework. PowerShell provides full access to the Component Object Model (COM) and Windows Management Instrumentation (WMI), enabling administrators to perform administrative tasks on both local and remote Windows systems as well as WS-Management and Common Information Model (CIM) enabling management of remote Linux systems and network devices.

Powershell

Exchange is the server side of a collaborative application product that is part of the Microsoft Server infrastructure. Exchange's major features include email, calendaring, contacts and tasks, support for mobile and web-based access to information, and support for data storage.

Exchange

Office 365 is a group of software plus services subscriptions that provides productivity software and related services to its subscribers. Office 365 allows the use of Microsoft Office apps on Windows and OS X, provides storage space on Microsoft's cloud storage service OneDrive, and grants 60 Skype minutes per month. Office 365 includes e-mail and social networking services through hosted versions of Exchange Server, Skype for Business Server, SharePoint and Office Online, integration with Yammer, as well as access to the Office software. All of Office 365's components can be managed and configured through an online portal; users can be added manually, imported from a CSV file, or Office 365 can be set up for single sign-on with a local Active Directory using Active Directory Federation Services.