Office activations pr. user with devices specified

%3CLINGO-SUB%20id%3D%22lingo-sub-830762%22%20slang%3D%22en-US%22%3EOffice%20activations%20pr.%20user%20with%20devices%20specified%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-830762%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20it%20possible%20to%20get%20a%20rapport%20over%20all%20users%20who%20have%20activated%20Office%3CEM%3Eincluding%3C%2FEM%3Ethe%20name%20of%20the%20device%20(Windows%2C%20Apple%2C%20Android%20device%20name)%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%3C%2FP%3E%3CP%3ERobert%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-830762%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAdmin%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-831033%22%20slang%3D%22en-US%22%3ERe%3A%20Office%20activations%20pr.%20user%20with%20devices%20specified%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-831033%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F138237%22%20target%3D%22_blank%22%3E%40Robert%20Vilhelmsen%3C%2FA%3E%26nbsp%3B%3CBR%20%2F%3ESo%20the%20pre-built%20reports%20for%20Office365%20pro%20plus%20activation%20do%20show%26nbsp%3B%3C%2FP%3E%3CUL%3E%3CLI%3EUser%3C%2FLI%3E%3CLI%3EProduct%20License%3C%2FLI%3E%3CLI%3Enumber%20of%20Computer%20activation%20by%20O%2FS%20type%3CUL%3E%3CLI%3EWindows%3C%2FLI%3E%3CLI%3EMac%3C%2FLI%3E%3C%2FUL%3E%3C%2FLI%3E%3CLI%3Enumbers%20of%20Phones%20%2F%20Tablet%20activation%20by%20O%2FS%20type%3CUL%3E%3CLI%3EWin10%3C%2FLI%3E%3CLI%3EiOS%3C%2FLI%3E%3CLI%3EAndroid%3C%2FLI%3E%3C%2FUL%3E%3C%2FLI%3E%3C%2FUL%3E%3CP%3EBut%20unfortunately%20it%20doesn't%20show%20the%20device%20name%26nbsp%3B%3CIMG%20class%3D%22lia-deferred-image%20lia-image-emoji%22%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Fhtml%2Fimages%2Femoticons%2Fsad_40x40_1.gif%22%20alt%3D%22%3Asad%3A%22%20title%3D%22%3Asad%3A%22%20%2F%3E%20%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETo%20get%20these%20reports%20above%20you%20can%20browse%20to%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fadmin.microsoft.com%2FAdminportal%2FHome%23%2FreportsUsage%2FOfficeActivations%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fadmin.microsoft.com%2FAdminportal%2FHome%23%2FreportsUsage%2FOfficeActivations%26nbsp%3B%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3EIt%20is%20possible%20in%20the%20portal%20to%20see%20a%20particular%20user's%20office%20activation%20and%20the%20device%20names%20but%20you%20have%20to%20navigate%20to%20an%20%3CEM%3Eindividual%20user%3C%2FEM%3Ein%20the%20Active%20Users%20screen%20and%20click%20edit%20on%20the%20Office%20installs%20section%20-%20A%20guide%20can%20be%20found%20for%20this%20%3CA%20href%3D%22https%3A%2F%2Fblogs.technet.microsoft.com%2Fodsupport%2F2015%2F06%2F22%2Foffice-365-proplus-user-activations-management%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehere%3C%2FA%3E.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-831060%22%20slang%3D%22en-US%22%3ERe%3A%20Office%20activations%20pr.%20user%20with%20devices%20specified%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-831060%22%20slang%3D%22en-US%22%3E%22It%20is%20possible%20in%20the%20portal%20to%20see%20a%20particular%20user's%20office%20activation%20and%20the%20device%20names%20but%20you%20have%20to%20navigate%20to%20an%20individual%20user%20in%20the%20Active%20Users%20screen%20and%20click%20edit%20on%20the%20Office%20installs%20section%22%3CBR%20%2F%3E%3CBR%20%2F%3EI%20know%2C%20but%20that%C2%B4s%20quite%20a%20big%20job%20to%20do%2C%20if%20i%20wan%C2%B4t%20to%20see%20all%20users.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-831102%22%20slang%3D%22en-US%22%3ERe%3A%20Office%20activations%20pr.%20user%20with%20devices%20specified%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-831102%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20100%25%20with%20you%2C%20its%20all%20good%20for%20small%20tenants%2C%20but%20once%20you%20get%20in%20to%201000's%20of%20users%20its%20a%20nightmare!!%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThere%20is%20a%20uservoice%20for%20updating%20the%20report%20here%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Foffice365.uservoice.com%2Fforums%2F264636-general%2Fsuggestions%2F19748401-add-computer-name-to-reports-usage-office-acti%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Foffice365.uservoice.com%2Fforums%2F264636-general%2Fsuggestions%2F19748401-add-computer-name-to-reports-usage-office-acti%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20vote%20for%20it%20so%20it%20can%20be%20moved%20up%20their%20priority%20list.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-831727%22%20slang%3D%22en-US%22%3ERe%3A%20Office%20activations%20pr.%20user%20with%20devices%20specified%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-831727%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20luck%20with%20that%20%3A)We%20have%20been%20requesting%20a%20proper%20report%20and%20means%20to%20manage%20the%20activations%20via%20some%20sort%20of%20an%20API%20or%20at%20least%20PowerShell%20for%20years%20now%2C%20doesn't%20look%20like%20it's%20gonna%20happen.%20But%20hopefully%20someone%20from%20Microsoft%20decides%20to%20prove%20me%20wrong%20%3A)%3C%2Fimg%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

Hi,

 

Is it possible to get a rapport over all users who have activated Office including the name of the device (Windows, Apple, Android device name)?

 

Regards

Robert

 

4 Replies
Highlighted

@Robert Vilhelmsen 
So the pre-built reports for Office365 pro plus activation do show 

  • User
  • Product License
  • number of Computer activation by O/S type
    • Windows
    • Mac
  • numbers of Phones / Tablet activation by O/S type
    • Win10
    • iOS
    • Android

But unfortunately it doesn't show the device name :sad:  

 

To get these reports above you can browse to:

https://admin.microsoft.com/Adminportal/Home#/reportsUsage/OfficeActivations 

It is possible in the portal to see a particular user's office activation and the device names but you have to navigate to an individual user in the Active Users screen and click edit on the Office installs section - A guide can be found for this here.

 

Highlighted
"It is possible in the portal to see a particular user's office activation and the device names but you have to navigate to an individual user in the Active Users screen and click edit on the Office installs section"

I know, but that´s quite a big job to do, if i wan´t to see all users.
Highlighted

I am 100% with you, its all good for small tenants, but once you get in to 1000's of users its a nightmare!! 

 

There is a uservoice for updating the report here:

https://office365.uservoice.com/forums/264636-general/suggestions/19748401-add-computer-name-to-repo...

 

Please vote for it so it can be moved up their priority list.

Highlighted

Good luck with that :) We have been requesting a proper report and means to manage the activations via some sort of an API or at least PowerShell for years now, doesn't look like it's gonna happen. But hopefully someone from Microsoft decides to prove me wrong :)