Need a powershell script - provisioned licenses against users

[timbo343]

If anyone has the time, i could do with a powershell script that checks each user in O365 for which products / licenses are assigned to all users and export it to a CSV.

 

Ive got a CSV that shows the license type but this isn't enough, i need it to show the products too with enabled / disabled.

 

i've also seen this https://blogs.technet.microsoft.com/cloudpfe/2013/12/27/how-to-tell-which-office-365-services-have-been-provisioned but dont know how to do it for all users.

 

EDIT:

 

I think ive found it:

 

$collections = @()

Get-MsolUser -All | ? {$_.isLicensed -eq $true} |%{

foreach($l in $_.Licenses.ServiceStatus)

{

$data = New-Object psObject -Property @{

ObjectID = $_.ObjectID

UPN = $_.UserPrincipalName

DisplayName = $_.

ServiceName = $l.ServicePlan.ServiceName

ServiceStatus = $l.ProvisioningStatus

}

$collections += $data

}

}

$collections | Export-Csv C:TempLicenseInformation.csv -NoTypeInformation

Edited March 31, 2017 by timbo343

[Cache]

Will try and check my scripts on Monday (can't remember where I got up to) however, I've used this before and it's been handy: https://gallery.technet.microsoft.com/office/Office365-License-cfd9489c

[timbo343]

Thanks for the link, ive seen and used that before. It was only on a trail basis, which has now run out and it only restricted me to edit 5 lines at a time. The one you've posted too is the same version - Trail version will expire in 14 days.

 

The script i posted worked for me in the end. I just had to filter some of the columns in excel to give me the results i required.

Edited April 3, 2017 by timbo343