Enable management and reporting of Office ProPlus using Admin portal and/or PowerShell. What version? How many installs? etc
I would like to report installs by user. Similar to Telemetry dashboard with how many installs a user is using vs remaining installs. Machine name (because I have seen duplicates using 2 licenses on 1 machine). Usage. Is the user a heavy Excel user, PowerPoint, Word, etc.
Mark Francis commented
Management via Powershell would be great.
We have just had a mix up with shared configuration and switching to device based activation!
Now some internal pcs are counted against user's licence counts.
I have a list so i would like to be able to do this in powershell, delete machine xyz from user abc.
I would rather be able to do this than get the users to do it themselves.
this is an essential feature for efficient license management
it's available in the admin gui, why not in powershell?
but maybe Microsoft prefers counting and selling ;-(
Still not available?! Also I would be nice to see on what computers and when it was active for te last time...
Report showing each user's machine name that has been activated on our O365 account.
We need a report showing each user's machine name that has been activated on our O365 account.
Can be extracted from AdminCenter:
Reports>Usage> Activations (drop down menu) >Office365 Activations
Leon Hedding commented
I can use PowerShell to get a full report of users that have a ProPlus license (https://gallery.technet.microsoft.com/Get-Office365-usage-f955ade4) that also lists last activity date. I would find it very useful to be able to deactivate with PowerShell (not remove the license) to force a re-activation. This would then allow us to remove the license if the activity date continues to not get updated. I can't find anyway with PowerShell to deactivate ProPlus installations.
Ashok Munisamy commented
this is a basic requirement for any enterprise reporting! Why do we even have to vote for this? Please make this feature available ASAP. thanks!
Come on guys, two years and 350+ votes ... how about giving *us* some feedback?!
Still no progress? It is a simple task from my point of view, but M$ probably looking for $$$ not for satisi´fied admins :(
Heather Adams commented
Is there an update on getting this reporting ability? I need to see who has activated their license and on what machines - and I have over 3500 users.
Tony Waite commented
This is a fundamental requirement that we need to report on for compliance. I do not understand why it is not available? Come on team - please make it happen.
Lots of votes. Any progress on this?
Robert Hammett commented
I was looking for a way to expose machine name via any reporting tool(s) (Admin portal, PowerShell, etc.). Is this simply not currently possible?
The weird thing is that data is already available, but you need to go into each individual user on your tenant > go to user properties > Office Installs > then you see a list of his/her activated Machines.
Why not consolidating these data into a single report? or even add a column under Admin Portal Home > Usage > Microsoft Office activation with computer name(s) per user ?
Machine name. Definitely this as a minimum should be added to the Office activations report. The data is sitting there under the user, so it isn't exactly a secret, it's just a short coming of the admin centre that we can't see from the top-down in a report.
Alex T. commented
agree that machine name would be a nice add. the information is visible to the user. Make it visible and reportable for admins.
Mike Higuet commented
One of the issues is the data from the Admin Reporting Activation's Aren't accurate: it says for several users they haven't activated an Installation where I am very sure they have (Because I staged & Configured the PC's or either Installed & Activated their Installation)
While on the other hand I Pulled the assigned Licenses with Powershell (with a distinguished value for E1 & E3 (AccountSkuId))
All I would need to know is which users have activated an Office Installation (obviously they'd have an E3)
The users might have received an E3 but might not have activated an Installation, if I we're able to have Accurate intell on that I would be able to Reassign them to an E1 license and not waste an E3
I am glad to see MS has exposed installs of ProPlus on PC's in the Admin portal but there is still no visibility of installs on mobile devices. This leaves 10 potential installs of Office completely unmanageable except for removing the ProPlus license all together.
I don't care where a user has installed, but I would like to be able to get a list of the users that have installed office.