SOLVED

Powershell command to check all the users who have office pro plus license assigned

%3CLINGO-SUB%20id%3D%22lingo-sub-312807%22%20slang%3D%22en-US%22%3EPowershell%20command%20to%20check%20all%20the%20users%20who%20have%20office%20pro%20plus%20license%20assigned%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-312807%22%20slang%3D%22en-US%22%3EI%20am%20in%20search%20of%20a%20powershell%20customized%20command%20by%20which%20we%20can%20list%20the%20office%20365%20users%20who%20has%20pro%20plus%20licenses%20assigned%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-312807%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExchange%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPowerShell%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-313052%22%20slang%3D%22en-US%22%3ERe%3A%20Powershell%20command%20to%20check%20all%20the%20users%20who%20have%20office%20pro%20plus%20license%20assigned%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-313052%22%20slang%3D%22en-US%22%3EThank%20you%20for%20your%20help.%3CBR%20%2F%3EThe%20command%20worked%20just%20fine.%3CBR%20%2F%3EThanks%20again%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-312918%22%20slang%3D%22en-US%22%3ERe%3A%20Powershell%20command%20to%20check%20all%20the%20users%20who%20have%20office%20pro%20plus%20license%20assigned%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-312918%22%20slang%3D%22en-US%22%3EThank%20you%20for%20your%20help%20and%20assistance.%20I%20have%20already%20followd%20the%20article%20and%20it%20only%20shows%20the%20detailed%20service%20status%20but%20i%20want%20to%20list%20only%20those%20users%20who%20has%20pro%20plus%20license%20assigned..%3CBR%20%2F%3EI%20hope%20you%20understand%20this.%3CBR%20%2F%3EIf%20you%20could%20assist%20me%20creating%20a%20command%20i%20would%20greatly%20appreciate%20this.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-312878%22%20slang%3D%22en-US%22%3ERe%3A%20Powershell%20command%20to%20check%20all%20the%20users%20who%20have%20office%20pro%20plus%20license%20assigned%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-312878%22%20slang%3D%22en-US%22%3E%3CP%3EHere's%20a%20quick%20example%20you%20can%20use%20to%20find%20any%20users%20assigned%20a%20given%20plan%2Fservice%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EGet-MsolUser%26nbsp%3B%20%7C%20%3F%20%7B%24_.Licenses.ServiceStatus%20%7C%20%3F%20%7B%24_.ServicePlan.ServiceName%20-eq%20%22OFFICESUBSCRIPTION%22%20-and%20%24_.ProvisioningStatus%20-eq%20%22Success%22%7D%7D%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ETo%20get%20the%20corresponding%20ServiceName%2C%20use%20this%20document%3A%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Factive-directory%2Factive-directory-licensing-product-and-service-plan-reference%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Factive-directory%2Factive-directory-licensing-product-and-service-plan-reference%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-312856%22%20slang%3D%22en-US%22%3ERe%3A%20Powershell%20command%20to%20check%20all%20the%20users%20who%20have%20office%20pro%20plus%20license%20assigned%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-312856%22%20slang%3D%22en-US%22%3Eplease%20see%20the%20following%20link%20for%20reference%3A%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Foffice365%2Fenterprise%2Fpowershell%2Fview-licenses-and-services-with-office-365-powershell%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Foffice365%2Fenterprise%2Fpowershell%2Fview-licenses-and-services-with-office-365-powershell%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3EIf%20you%20need%20more%20help%20building%20it%20I%20can%20be%20of%20assistance%20later%20on!!%20On%20a%20flight%20right%20now%20%3A)%3C%2Fimg%3E%3CBR%20%2F%3E%3CBR%20%2F%3EAdam%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-797497%22%20slang%3D%22en-US%22%3ERe%3A%20Powershell%20command%20to%20check%20all%20the%20users%20who%20have%20office%20pro%20plus%20license%20assigned%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-797497%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F262922%22%20target%3D%22_blank%22%3E%40Kashu855%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHello%2C%20what%20powershell%20command%20did%20you%20use%20to%20check%20for%20users%20with%20Office%20Pro%20Plus%20licenses%20assigned%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank-you.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor
I am in search of a powershell customized command by which we can list the office 365 users who has pro plus licenses assigned
5 Replies
Highlighted
please see the following link for reference:

https://docs.microsoft.com/en-us/office365/enterprise/powershell/view-licenses-and-services-with-off...

If you need more help building it I can be of assistance later on!! On a flight right now :)

Adam
Highlighted
Solution

Here's a quick example you can use to find any users assigned a given plan/service:

 

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

 

To get the corresponding ServiceName, use this document: https://docs.microsoft.com/en-us/azure/active-directory/active-directory-licensing-product-and-servi...

Highlighted
Thank you for your help and assistance. I have already followd the article and it only shows the detailed service status but i want to list only those users who has pro plus license assigned..
I hope you understand this.
If you could assist me creating a command i would greatly appreciate this.
Highlighted
Thank you for your help.
The command worked just fine.
Thanks again
Highlighted

@Kashu855 

 

Hello, what powershell command did you use to check for users with Office Pro Plus licenses assigned?

 

Thank-you.