I need to query my sccm environment for workstations or Users which have Office365 installed, but have not successfully activated. Is there are registry key for this, or a way to query for this?

There is no registry key for license information. You have to use "ospp.vbs /dstatus " to get such information. I would suggest to use Configuration Baseline in your case. See more How to Create Windows Configuration Items for Compliance Settings in Configuration Manager - https://technet.microsoft.com/en-us/library/gg712331.aspx?f=255&MSPPError=-2147217396

IMHO it worth checking anyway. Take unlicensed workstation and activate it while running http://www.nirsoft.net/utils/reg_file_from_application.html or something like that.

Please give me your feedback.

Hi,

I agree with Slava Fedenko, the ospp.vbs script displays the licenses that are available to Office products on that computer. Steps:

1)Determine whether the 32-bit or 64-bit version of Office 365 ProPlus is installed. To do this, open an Office 365 ProPlus application, such as Word, and choose File > Account > About {name of app}. 64-bit or 32-bit is displayed next to the application version.

2)Determine whether the computer has the 32-bit or 64-bit version of Windows installed. To do this, press the Windows logo key+E, then choose System properties or Computer > System properties. Under System, the System type property will indicate either a 32-bit or 64-bit operating system.

3)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

4)Review the LICENSE STATUS. The following table describes what each status means.

Reference:

https://technet.microsoft.com/en-us/library/gg702620.aspx

PS: There is also coming new feature to Office 365 admin center, where "Office 365 ProPlus user activation management allows administrators to view and manage Office 365 ProPlus activations on PCs or Macs directly from the Office 365 Admin Center".

https://blogs.office.com/2015/03/19/office-365-proplus-it-control-and-management-update/

Regards,

George Zhao
TechNet Community Support