Office 365 inactivity report, script, method?

Hi Experts,

Is there any other way or method of gathering inactivity reports other than going to the Office 365 portal in reporting and exporting Office 365 active users?  How accurate/reliable is the data in this for last activity in exchange, skype, sharepoint, etc.?

I also ran this PS script, but this only give me the lastlogon time/date stamp of the mailbox:
Get-LastLogonStats.ps1
https://gallery.technet.microsoft.com/scriptcenter/Export-Office-365-User-7fc0b73f

My goal is to manage 30k users, and clean up licenses that are no longer needed by 90 days of inactivity.  This would include all aspects of the license:  mail/exchange, skype, sharepoint, access any of the online apps such as word, excel, powerpoint, etc.

Appreciate any direction anyone can point me in!
Ron ShortsAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Vasil Michev (MVP)Commented:
The reports in the O365 admin portal/Graph are much more accurate than using the lastlogon date as reported by the script, Tony blogged about this here: https://www.petri.com/get-mailboxstatistics-cmdlet-wrong

If you want to automate the process, simply fetch the reports via the Graph API instead of doing it manually from the portal. But in any case, you will probably be running this on a monthly cadence, so logging to the portal and downloading them manually should not be a big overhead.
1

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Ron ShortsAuthor Commented:
Thanks Vasil!  Btw, just purchased O365 for IT Pros, fifth edition, very well done, lot of info to assimilate.
1
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Powershell

From novice to tech pro — start learning today.