Link to home
Start Free TrialLog in
Avatar of AHAC EL
AHAC EL

asked on

Which users are not using Visio and Project licenses

I have been looking for a way to PowerShell a script that will tell me which users in the company are not using their Visio and Project licenses so i can reassign these licenses to users that need them instead of buying more. Any help is appreciated.
Avatar of Vasil Michev (MVP)
Vasil Michev (MVP)
Flag of Bulgaria image

There's no way to obtain such information from PowerShell. Best you can do is check whether they have a valid license applied, the usage information needs to come from someplace else, such as any report you can obtain from Project, or the Office 365 Unified Audit log or similar.
Avatar of AHAC EL
AHAC EL

ASKER

Can you expand more on how to find this information using Office 365 Unified Audit log ?
You'll basically have to search for "login" events, and for each of those look at the client info (if such is available) in order to determine whether the request came from Visio or Project. Keep in mind that with Modern authentication and the current token lifetimes, one a user successfully authenticates, it might be *months* before you see another event, and in the meantime he can keep accessing/using the service just fine.

Check the documentation for more info: https://docs.microsoft.com/en-us/office365/securitycompliance/detailed-properties-in-the-office-365-audit-log
if you have a tool such as SCCM, there are canned reports in there.  From SCCM you will use software inventory and then you can create a collection of users that have not used project (or visio) in say 30 days and apply a script to that collection to uninstall the offending program.  Without using some sort of mgmt. tool like SCCM or Altiris there is no real way to do what you are asking.
  Sorry
This question needs an answer!
Become an EE member today
7 DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.