Office 365 Licensed Users

Office 365 licensed users refer to the individuals within an organization who have been assigned some, all, or none of the available licenses for accessing Office 365 services. These licenses are managed within the organization's tenant, and PowerShell for Microsoft 365 can be used to identify the status of these users, determining who is licensed and who is not.

The management of user licenses is crucial for an organization as it dictates who has access to the variety of different services and features included with Office 365, such as Microsoft Bookings, Microsoft Clipchamp, Exchange Online, and MyAnalytics. Licenses are available through various Microsoft 365 Enterprise and Office 365 Enterprise plans, catering to different business sizes and needs.

To effectively manage these licenses and user accounts, administrators can utilize the Microsoft Graph PowerShell SDK, which requires specific permission scopes such as User.Read.All to read user properties including license details, and Organization.Read.All to read the available licenses in the tenant. The Get-MgUser cmdlet is a specific command that can be employed to find information about both licensed and unlicensed users.

Streamline Your Workflow with Sourcetable

Instead of the traditional method of exporting Office 365 licensed users to a CSV and then importing them into another spreadsheet program, consider the advanced capabilities of Sourcetable. With Sourcetable, you can directly sync your live data from Office 365, eliminating the need for cumbersome export and import processes. This seamless integration not only saves you valuable time but also ensures that your data is always up-to-date.

Sourcetable's powerful automation features allow you to effortlessly combine data from various apps or databases. This means that you can have a comprehensive view of your Office 365 licensed users alongside other critical business data, all within a familiar spreadsheet interface. By using Sourcetable, you enhance your business intelligence capabilities, enabling you to make informed decisions quickly and efficiently based on real-time data.

Frequently Asked Questions

What is the best method to export all Microsoft 365 user licenses to a CSV?

The best method to export all Microsoft 365 user licenses to a CSV is by using the Export-Microsoft365LicenseStatus.ps1 PowerShell script, which generates a report of all users and their license details and is faster and easier than exporting from the Microsoft 365 admin center.

Can I see the details of the assigned licenses and apps for all users directly in the Microsoft 365 admin center?

No, the list from the admin center does not show the details of the assigned licenses and apps for all users. You must click on each user to get information about their licenses.

Is it necessary to use PowerShell to export Office 365 users to a CSV?

Yes, the process of exporting Office 365 users to a CSV involves using PowerShell, and you need to install the PowerShell cmdlets for Windows Azure Active Directory and Office 365 to run the necessary commands.

How do I retrieve a list of licensed Office 365 users using PowerShell?

To retrieve a list of licensed Office 365 users using PowerShell, you need to run the command Get-MsolUser.

What script should I use to export a list of all Office 365 users and their licenses in all customer tenants with delegated administration?

To export such a list, you should use the provided script that utilizes Office 365 delegated admin credentials to retrieve all customer tenants and pulls user and license info from each customer, appending this information to a CSV.