0

In an effort to help reduce costs for the NFP organisation I work in, I'm hoping to find out which staff or volunteers have been assigned an Office2016 ProPlus subscription licence but not used it. (Managers tend to request it for all new starters regardless of job function, and such costs don't come out of their local budgets...)

Is it possible to identify users of licences that have been assigned but not used?

Sub-criteria that are not essential but would be nice are:

  • Licensed users who haven't downloaded and installed the software from the Office365 Portal (there is a "mostly-accurate" report; several of my users are definitely using the software long-term but the report claims no activation)
  • Licensed users who have not run any of the Office applications on their PC (in the last three months)

I'm not particularly looking for a full scripted solution (although I'd never say no to one). Rather, useful pointers to appropriate Powershell commands, or even menu options and reports within the Office365 Administrator Portal would be wonderful.

I have looked around but nothing popped out at me other than finding inactive users, seeing which users have been assigned what licences, counting unassigned subscriptions, and those I already keep at a minimal level (one or zero, usually).

roaima
  • 1,591
  • 14
  • 28

1 Answers1

1

Have you tried the activity reports available in the Administration console?

https://support.office.com/en-us/article/activity-reports-in-the-office-365-admin-center-0d6dfb17-8582-4172-a9a9-aed798150263

Update

That information would not be available from Office 365 alone. You would need a third party solution which installs agents on each workstation to determine the exact usage of applications. Whilst I have yet to use it in a production environment, it sounds like Microsoft AppLocker might be worth looking into.

George
  • 366
  • 2
  • 7
  • Hello George. https://portal.office.com/adminportal/home#/reportsUsage/OfficeActivations gets me a list of users who have activated the product, thank you. I can negate that to get a list of licensed users who have _not activated_ it, so I think that'll get me somewhere. – roaima Sep 25 '18 at 11:27
  • That's an interesting starting point but unfortunately doesn't help me find the users who activated it but simply don't use it. Thoughts appreciated... – roaima Sep 25 '18 at 11:49
  • How about the user level signon log in AzureAD? I'm not sure if it logs just running the desktop application. – JOTN Sep 29 '18 at 19:05