# Need help viewing licensed users who dont use licenses

**URL:** https://forums.powershell.org/t/need-help-viewing-licensed-users-who-dont-use-licenses/9911
**Category:** PowerShell Help
**Created:** [December 28, 2017, 1:07pm UTC](https://forums.powershell.org/t/need-help-viewing-licensed-users-who-dont-use-licenses/9911 "2017-12-28T13:07:27Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![ruckus](https://avatars.discourse-cdn.com/v4/letter/r/e68b1a/32.png) [@ruckus](https://forums.powershell.org/u/ruckus)
#### Post date: [December 28, 2017, 1:07pm UTC](https://forums.powershell.org/t/need-help-viewing-licensed-users-who-dont-use-licenses/9911/1 "2017-12-28T13:07:27Z")

</div>

Is there a powershell way to view users who have e3 licenses but no active 365 pro plus installs? I have over 5k users and know I can probably move 1k of them to e1 licenses but i dont want to open 5k accounts to view installs.

---

<div class="post-metadata">

### Author: ![postanote](https://avatars.discourse-cdn.com/v4/letter/p/ebca7d/32.png) [@postanote](https://forums.powershell.org/u/postanote)
#### Post date: [December 28, 2017, 5:44pm UTC](https://forums.powershell.org/t/need-help-viewing-licensed-users-who-dont-use-licenses/9911/2 "2017-12-28T17:44:10Z")

</div>

As per MS…  
‘[Redirecting](http://answers.microsoft.com/en-us/msoffice/forum/msoffice_o365admin-mso_dep365/get-list-of-activated-installations-of-proplus-vs/95071f4a-0b81-4ca7-b759-8f323e4b2b93)’

See also:  
‘[microsoft.com/en-us/download/details.aspx?id=36852](http://microsoft.com/en-us/download/details.aspx?id=36852)’

You could try this, if the file is on the user system, then an install happened.

use ospp.vbs script…  
Open a command prompt and type one of the following commands, depending on your versions of Windows and Office:

If the 32-bit version of Office 365 ProPlus is installed on the 32-bit version of Windows:  
cscript.exe "%ProgramFiles%\Microsoft Office\Office15"ospp.vbs /dstatus

If the 32-bit version of Office 365 ProPlus is installed on the 64-bit version of Windows:  
cscript.exe "%ProgramFiles(x86)%\Microsoft Office\Office15"ospp.vbs /dstatus

If the 64-bit version of Office 365 ProPlus is installed on the 64-bit version of Windows:  
cscript.exe "%ProgramFiles%\Microsoft Office\Office15"ospp.vbs /dstatus

Or , you can try this.  
Create a script to enumerate all machines in you enterprise which are office targets.

Running the following…

reg query HKCU\SOFTWARE\Microsoft\Office\16.0\Common\Identity\IdToAuthorityUrlMapping

Should result to this…

HKEY\_CURRENT\_USER\SOFTWARE\Microsoft\Office\16.0\Common\Identity\IdToAuthorityUrlMapping.…

Then do this…

Get-ItemProperty “HKCU:\SOFTWARE\Microsoft\Office\16.0\Common\Identity\IdToAuthorityUrlMapping.…”

AuthorityUrl : [Sign in to your account](https://login.windows.net/common/oauth2/authorize)  
EmailAddress : [username@mydomain.com](mailto:username@mydomain.com)  
PSPath : Microsoft.PowerShell.Core\Registry::HKEY\_CURRENT\_USER\SOFTWARE\Microsoft\Office\16.0\Common\Identity\IdToAuthorityUrlMapping.…  
PSParentPath : Microsoft.PowerShell.Core\Registry::HKEY\_CURRENT\_USER\SOFTWARE\Microsoft\Office\16.0\Common\Identity\IdToAuthorityUrlMapping  
PSChildName : …  
PSDrive : HKCU

PSProvider : Microsoft.PowerShell.Core\Registry

Grab the computer name inline with this Reg check, thus leading to a potential automated way to report of which machines are using which installs for office.  
Of course this is not a thing if the device is not domain joined. Think, mobile, tablets, etc…

---

<div class="post-metadata">

### Author: ![dotnVo](https://avatars.discourse-cdn.com/v4/letter/d/4af34b/32.png) [@dotnVo](https://forums.powershell.org/u/dotnVo)
#### Post date: [May 16, 2024, 8:36pm UTC](https://forums.powershell.org/t/need-help-viewing-licensed-users-who-dont-use-licenses/9911/3 "2024-05-16T20:36:58Z")

</div>


